APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 21763: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F

21759: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21760: pqh_table_route tr
21761: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21762: and cpe.table_route_id = tr.table_route_id
21763: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F
21764: and tr.table_alias = l_table_alias
21765: and cpe.number_of_copies = 1 -- ADDITION
21766: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
21767: order by information1, information2; --added for bug: 5151945

Line 21801: from BEN_ELIG_TO_PRTE_RSN_F PEO

21797: c_business_group_id number,
21798: c_new_pk_id number) is
21799: select
21800: PEO.elig_to_prte_rsn_id new_value
21801: from BEN_ELIG_TO_PRTE_RSN_F PEO
21802: where
21803: PEO.LER_ID = l_LER_ID and
21804: nvl(PEO.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
21805: nvl(PEO.PGM_ID,-999) = nvl(l_PGM_ID,-999) and

Line 21817: from BEN_ELIG_TO_PRTE_RSN_F PEO1

21813: and effective_end_date ;
21814: --END TEMPIK
21815: /*
21816: and exists ( select null
21817: from BEN_ELIG_TO_PRTE_RSN_F PEO1
21818: where
21819: PEO1.LER_ID = l_LER_ID and
21820: nvl(PEO1.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
21821: nvl(PEO1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and

Line 21828: from BEN_ELIG_TO_PRTE_RSN_F PEO2

21824: nvl(PEO1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
21825: PEO1.business_group_id = c_business_group_id
21826: and PEO1.effective_start_date <= c_effective_start_date )
21827: and exists ( select null
21828: from BEN_ELIG_TO_PRTE_RSN_F PEO2
21829: where
21830: PEO2.LER_ID = l_LER_ID and
21831: nvl(PEO2.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
21832: nvl(PEO2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and

Line 21995: (p_base_table_name => 'BEN_ELIG_TO_PRTE_RSN_F',

21991: if c_find_PEO_in_target%found then
21992: --
21993: --TEMPIK
21994: l_dt_rec_found := dt_api.check_min_max_dates
21995: (p_base_table_name => 'BEN_ELIG_TO_PRTE_RSN_F',
21996: p_base_key_column => 'ELIG_TO_PRTE_RSN_ID',
21997: p_base_key_value => l_new_value,
21998: p_from_date => l_min_esd,
21999: p_to_date => l_max_eed );

Line 22054: hr_utility.set_location(' BEN_ELIG_TO_PRTE_RSN_F CREATE_ELIG_TO_PRTE_REASON ',20);

22050: end if;
22051:
22052: if l_first_rec and not l_update then
22053: -- Call Create routine.
22054: hr_utility.set_location(' BEN_ELIG_TO_PRTE_RSN_F CREATE_ELIG_TO_PRTE_REASON ',20);
22055: BEN_ELIG_TO_PRTE_REASON_API.CREATE_ELIG_TO_PRTE_REASON(
22056: --
22057: P_VALIDATE => false
22058: ,P_EFFECTIVE_DATE => l_effective_date

Line 22143: hr_utility.set_location(' BEN_ELIG_TO_PRTE_RSN_F UPDATE_ELIG_TO_PRTE_REASON ',30);

22139: else
22140: --
22141: -- Call Update routine for the pk_id created in prev run .
22142: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
22143: hr_utility.set_location(' BEN_ELIG_TO_PRTE_RSN_F UPDATE_ELIG_TO_PRTE_REASON ',30);
22144: --UPD START
22145: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
22146: --
22147: if l_update then