DBA Data[Home] [Help]

APPS.PER_NL_LTSRR_ARCHIVE dependencies on HR_NL_ORG_INFO

Line 398: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

394: AND paat.absence_category = 'S'
395: AND pab.abs_information_category = 'NL_S'
396: AND pab.abs_information4 = 'L'
397: AND (
398: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
399: ,paa.organization_id) IS NOT NULL
400: OR per_nl_ltsrr_archive.org_check (pap.business_group_id
401: ,NULL
402: ,nvl (paa.establishment_id,- 1)

Line 867: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

863: AND pab.business_group_id = pap.business_group_id
864: AND pab.person_id = pap.person_id
865: AND pap.person_id = paa.person_id
866: AND (
867: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
868: ,paa.organization_id) IS NOT NULL
869: OR per_nl_ltsrr_archive.org_check (pap.business_group_id
870: ,NULL
871: ,nvl (paa.establishment_id, - 1)

Line 1029: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

1025: )
1026: AND paa.assignment_id = pai.assignment_id
1027: AND pap.person_id = paa.person_id
1028: AND (
1029: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1030: ,paa.organization_id) IS NOT NULL
1031: OR per_nl_dsr_archive.org_check (pap.business_group_id
1032: ,NULL
1033: ,nvl (paa.establishment_id,- 1)

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

1179: AND p_abs_start_date BETWEEN posv.date_from
1180: AND nvl (posv.date_to
1181: ,hr_general.end_of_time)
1182: AND pas.assignment_id = p_assignment_id
1183: AND hou.organization_id = hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1184: ,pas.organization_id)
1185: AND hoi.organization_id = hou.organization_id
1186: AND hoi.org_information_context = 'NL_ORG_INFORMATION';
1187: /**************************************************************************/