query to fetch 9box data assignment

Summary:

select p.person_id,c.content_item_code, pi.item_number_1 BOX_NUM,pi.section_id
FROM HRT_PROFILES_VL P,
HRT_PROFILE_ITEMS PI,
HRT_CONTENT_TYPES_VL CT,
hrt_content_items_vl c
WHERE PI.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID
and PI.PROFILE_ID = P.PROFILE_ID
and CT.BUSINESS_GROUP_ID =PI.BUSINESS_GROUP_ID
and CT.CONTENT_TYPE_ID = PI.CONTENT_TYPE_ID
and pi.content_item_id = c.content_item_id
and p.business_Group_id = c.business_group_id
and (CT.CONTEXT_NAME = 'N_BOX_ASSIGNMENT')
—and p.person_id='0000'