DBA Data[Home] [Help]

APPS.PER_NL_LTSR_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_ltsr_archive.org_check (pap.business_group_id
401: ,NULL
402: ,nvl (paa.establishment_id,- 1)

Line 860: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

856: AND pab.business_group_id = pap.business_group_id
857: AND pab.person_id = pap.person_id
858: AND pap.person_id = paa.person_id
859: AND (
860: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
861: ,paa.organization_id) IS NOT NULL
862: OR per_nl_ltsr_archive.org_check (pap.business_group_id
863: ,NULL
864: ,nvl (paa.establishment_id,- 1)

Line 1023: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

1019: AND ppa.payroll_action_id = p_payroll_action_id
1020: AND pap.business_group_id = ppa.business_group_id
1021: AND pap.person_id = paa.person_id
1022: AND (
1023: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1024: ,paa.organization_id) IS NOT NULL
1025: OR per_nl_ltsr_archive.org_check (pap.business_group_id
1026: ,NULL
1027: ,nvl (paa.establishment_id,- 1)

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

1171: AND p_abs_start_date BETWEEN posv.date_from
1172: AND nvl (posv.date_to
1173: ,hr_general.end_of_time)
1174: AND pas.assignment_id = p_assignment_id
1175: AND hou.organization_id = hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
1176: ,pas.organization_id)
1177: AND hoi.organization_id = hou.organization_id
1178: AND hoi.org_information_context = 'NL_ORG_INFORMATION';
1179: /**************************************************************************/