APPS.PAY_NL_WTS_REPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 259: FROM per_org_structure_elements pose

255: and ppa.date_earned between to_date(p_month_from,'MMYYYY') AND LAST_DAY(to_date(P_MONTH_TO,'MMYYYY'))
256: and ppa.date_earned between paa.effective_start_date and paa.effective_end_date
257: and paa.organization_id in
258: ((SELECT pose.organization_id_child
259: FROM per_org_structure_elements pose
260: WHERE pose.org_structure_version_id = GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to)
261: START with pose.organization_id_parent = nvl(p_top_org_id,p_bg_id)
262: CONNECT BY prior organization_id_child = organization_id_parent )
263: union

Line 792: FROM per_org_structure_elements pose

788: and ppa.date_earned between to_date(p_month_from,'MMYYYY') AND LAST_DAY(to_date(P_MONTH_TO,'MMYYYY'))
789: and ppa.date_earned between paa.effective_start_date and paa.effective_end_date
790: and paa.organization_id in
791: ((SELECT pose.organization_id_child
792: FROM per_org_structure_elements pose
793: WHERE pose.org_structure_version_id = GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to)
794: START with pose.organization_id_parent = nvl(p_top_org_id,p_bg_id)
795: CONNECT BY prior organization_id_child = organization_id_parent )
796: union