DBA Data[Home] [Help]

APPS.PER_NL_DSRR_ARCHIVE dependencies on PER_NL_DSRR_ARCHIVE

Line 1: PACKAGE BODY PER_NL_DSRR_ARCHIVE as

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

Line 867: OR per_nl_dsrr_archive.org_check (pap.business_group_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)
870: ,p_start_date
871: ,p_end_date) = 1

Line 1519: AND per_nl_dsrr_archive.org_check(l_bg_id

1515:
1516: l_est_id := l_person_info.establishment_id;
1517:
1518: IF l_est_id IS NOT NULL
1519: AND per_nl_dsrr_archive.org_check(l_bg_id
1520: ,NULL
1521: ,l_est_id
1522: ,l_abs_start_date
1523: ,l_abs_end_date) = 1 THEN

Line 2052: END PER_NL_DSRR_ARCHIVE;

2048: WHEN others THEN
2049: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2050: END gen_body_xml;
2051:
2052: END PER_NL_DSRR_ARCHIVE;
2053: