DBA Data[Home] [Help]

APPS.PER_NL_DSRR_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 = 'S'
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_dsr_archive.org_check (pap.business_group_id
401: ,NULL
402: ,nvl (paa.establishment_id,- 1)

Line 865: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

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

Line 1026: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

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

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

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