DBA Data[Home] [Help]

APPS.PER_NL_WAZO_ARCHIVE dependencies on HR_NL_ORG_INFO

Line 400: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id

396: AND pab.business_group_id = paat.business_group_id
397: AND paat.absence_category = 'WAZO'
398: AND pab.abs_information_category = 'NL_WAZO'
399: AND (
400: hr_nl_org_info.get_tax_org_id (posv.org_structure_version_id
401: ,paa.organization_id) IS NOT NULL
402: OR per_nl_wazo_archive.org_check (pap.business_group_id
403: ,NULL
404: ,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_wazo_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_wazo_archive.org_check (pap.business_group_id
1026: ,NULL
1027: ,nvl (paa.establishment_id,- 1)

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

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