APPS.PER_NL_LTSRR_ARCHIVE dependencies on PER_NL_LTSRR_ARCHIVE

Line 1: PACKAGE BODY PER_NL_LTSRR_ARCHIVE as

1: PACKAGE BODY PER_NL_LTSRR_ARCHIVE as
2: /* $Header: penlltsrr.pkb 120.5.12020000.1 2012/07/17 08:55:43 asudhaka noship $ */
3:
4: EOL VARCHAR2(5) := fnd_global.newline();
5: g_SOURCE VARCHAR2(4000);

Line 400: OR per_nl_ltsrr_archive.org_check (pap.business_group_id

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)
403: ,c_start_date
404: ,c_end_date) = 1

Line 869: OR per_nl_ltsrr_archive.org_check (pap.business_group_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)
872: ,p_start_date
873: ,p_end_date) = 1

Line 1542: AND per_nl_ltsrr_archive.org_check(l_bg_id

1538: CLOSE csr_get_assignment_dates;
1539:
1540: l_est_id := l_person_info.establishment_id;
1541: IF l_est_id IS NOT NULL
1542: AND per_nl_ltsrr_archive.org_check(l_bg_id
1543: ,NULL
1544: ,l_est_id
1545: ,l_abs_start_date
1546: ,l_abs_end_date) = 1 THEN

Line 2078: END PER_NL_LTSRR_ARCHIVE;

2074: WHEN others THEN
2075: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2076: END gen_body_xml;
2077:
2078: END PER_NL_LTSRR_ARCHIVE;
2079: