DBA Data[Home] [Help]

APPS.PER_NL_WAZO_ARCHIVE dependencies on PER_NL_WAZO_ARCHIVE

Line 1: PACKAGE BODY PER_NL_WAZO_ARCHIVE as

1: PACKAGE BODY PER_NL_WAZO_ARCHIVE as
2: /* $Header: penlwazo.pkb 120.9.12020000.1 2012/07/17 08:56:34 asudhaka noship $ */
3:
4:
5: EOL VARCHAR2(5) := fnd_global.newline();

Line 402: OR per_nl_wazo_archive.org_check (pap.business_group_id

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)
405: ,c_start_date
406: ,c_end_date) = 1

Line 862: OR per_nl_wazo_archive.org_check (pap.business_group_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)
865: ,p_start_date
866: ,p_end_date) = 1

Line 1025: OR per_nl_wazo_archive.org_check (pap.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)
1028: ,p_start_date
1029: ,p_end_date) = 1

Line 2448: END PER_NL_WAZO_ARCHIVE;

2444: WHEN others THEN
2445: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2446: END gen_body_xml;
2447:
2448: END PER_NL_WAZO_ARCHIVE;
2449: