DBA Data[Home] [Help]

APPS.PAY_NL_WTS_REPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 261: FROM per_org_structure_elements pose

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

Line 861: FROM per_org_structure_elements pose

857: and ppa.date_earned between to_date(p_month_from,'MMYYYY') AND LAST_DAY(to_date(P_MONTH_TO,'MMYYYY'))
858: and ppa.date_earned between paa.effective_start_date and paa.effective_end_date
859: and paa.organization_id in
860: ((SELECT pose.organization_id_child
861: FROM per_org_structure_elements pose
862: WHERE pose.org_structure_version_id = GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to)
863: START with pose.organization_id_parent = nvl(p_top_org_id,p_bg_id)
864: CONNECT BY prior organization_id_child = organization_id_parent )
865: union