DBA Data[Home] [Help]

APPS.PAY_NL_WTS_REPORT dependencies on DUAL

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

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
264: (select nvl(p_top_org_id,p_bg_id) from dual))
265: and pap.person_id=nvl(p_person_id,pap.person_id)
266: 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'))
267: 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
268: not null

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

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
797: (select nvl(p_top_org_id,p_bg_id) from dual))
798: and pap.person_id=nvl(p_person_id,pap.person_id)
799: 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'))
800: 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
801: not null