DBA Data[Home] [Help]

APPS.PAY_NL_WTS_REPORT dependencies on DUAL

Line 266: (select nvl(p_top_org_id,p_bg_id) from dual))

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
266: (select nvl(p_top_org_id,p_bg_id) from dual))
267: and pap.person_id=nvl(p_person_id,pap.person_id)
268: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))
269: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is
270: not null

Line 866: (select nvl(p_top_org_id,p_bg_id) from dual))

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
866: (select nvl(p_top_org_id,p_bg_id) from dual))
867: and pap.person_id=nvl(p_person_id,pap.person_id)
868: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))
869: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is
870: not null