DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on HR_NL_ORG_INFO

Line 532: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

528: AND paat.absence_category = 'S'
529: AND pab.abs_information_category = 'NL_S'
530: AND pab.abs_information4 = 'S'
531: AND (
532: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
533: ,paa.organization_id) IS NOT NULL
534: OR per_nl_dsr_archive.org_check (pap.business_group_id
535: ,NULL
536: ,nvl (paa.establishment_id,- 1)

Line 995: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

991: AND pab.business_group_id = pap.business_group_id
992: AND pab.person_id = pap.person_id
993: AND pap.person_id = paa.person_id
994: AND (
995: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
996: ,paa.organization_id) IS NOT NULL
997: OR per_nl_dsr_archive.org_check (pap.business_group_id
998: ,NULL
999: ,nvl (paa.establishment_id,- 1)

Line 1158: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

1154: AND ppa.payroll_action_id = p_payroll_action_id
1155: AND pap.business_group_id = ppa.business_group_id
1156: AND pap.person_id = paa.person_id
1157: AND (
1158: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1159: ,paa.organization_id) IS NOT NULL
1160: OR per_nl_dsr_archive.org_check (pap.business_group_id
1161: ,NULL
1162: ,nvl (paa.establishment_id,- 1)

Line 1312: AND hou.organization_id = hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

1308: AND p_abs_start_date BETWEEN posv.date_from
1309: AND nvl (posv.date_to
1310: ,hr_general.end_of_time)
1311: AND pas.assignment_id = p_assignment_id
1312: AND hou.organization_id = hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1313: ,pas.organization_id)
1314: AND hoi.organization_id = hou.organization_id
1315: AND hoi.org_information_context = 'NL_ORG_INFORMATION';
1316: /**************************************************************************/