APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 21676: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F

21672: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21673: pqh_table_route tr
21674: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21675: and cpe.table_route_id = tr.table_route_id
21676: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F
21677: and tr.table_alias = l_table_alias
21678: and cpe.number_of_copies = 1 -- ADDITION
21679: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
21680: order by information1, information2; --added for bug: 5151945

Line 21714: from BEN_ELIG_TO_PRTE_RSN_F PEO

21710: c_business_group_id number,
21711: c_new_pk_id number) is
21712: select
21713: PEO.elig_to_prte_rsn_id new_value
21714: from BEN_ELIG_TO_PRTE_RSN_F PEO
21715: where
21716: PEO.LER_ID = l_LER_ID and
21717: nvl(PEO.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
21718: nvl(PEO.PGM_ID,-999) = nvl(l_PGM_ID,-999) and

Line 21730: from BEN_ELIG_TO_PRTE_RSN_F PEO1

21726: and effective_end_date ;
21727: --END TEMPIK
21728: /*
21729: and exists ( select null
21730: from BEN_ELIG_TO_PRTE_RSN_F PEO1
21731: where
21732: PEO1.LER_ID = l_LER_ID and
21733: nvl(PEO1.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
21734: nvl(PEO1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and

Line 21741: from BEN_ELIG_TO_PRTE_RSN_F PEO2

21737: nvl(PEO1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
21738: PEO1.business_group_id = c_business_group_id
21739: and PEO1.effective_start_date <= c_effective_start_date )
21740: and exists ( select null
21741: from BEN_ELIG_TO_PRTE_RSN_F PEO2
21742: where
21743: PEO2.LER_ID = l_LER_ID and
21744: nvl(PEO2.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
21745: nvl(PEO2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and

Line 21908: (p_base_table_name => 'BEN_ELIG_TO_PRTE_RSN_F',

21904: if c_find_PEO_in_target%found then
21905: --
21906: --TEMPIK
21907: l_dt_rec_found := dt_api.check_min_max_dates
21908: (p_base_table_name => 'BEN_ELIG_TO_PRTE_RSN_F',
21909: p_base_key_column => 'ELIG_TO_PRTE_RSN_ID',
21910: p_base_key_value => l_new_value,
21911: p_from_date => l_min_esd,
21912: p_to_date => l_max_eed );

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

21963: end if;
21964:
21965: if l_first_rec and not l_update then
21966: -- Call Create routine.
21967: hr_utility.set_location(' BEN_ELIG_TO_PRTE_RSN_F CREATE_ELIG_TO_PRTE_REASON ',20);
21968: BEN_ELIG_TO_PRTE_REASON_API.CREATE_ELIG_TO_PRTE_REASON(
21969: --
21970: P_VALIDATE => false
21971: ,P_EFFECTIVE_DATE => l_effective_date

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

22052: else
22053: --
22054: -- Call Update routine for the pk_id created in prev run .
22055: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
22056: hr_utility.set_location(' BEN_ELIG_TO_PRTE_RSN_F UPDATE_ELIG_TO_PRTE_REASON ',30);
22057: --UPD START
22058: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
22059: --
22060: if l_update then