APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 20774: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F

20770: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20771: pqh_table_route tr
20772: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20773: and cpe.table_route_id = tr.table_route_id
20774: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F
20775: and tr.table_alias = l_table_alias
20776: and cpe.number_of_copies = 1 -- ADDITION
20777: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
20778: order by information1, information2; --added for bug: 5151945

Line 20812: from BEN_LER_CHG_DPNT_CVG_F LDC

20808: c_business_group_id number,
20809: c_new_pk_id number) is
20810: select
20811: LDC.ler_chg_dpnt_cvg_id new_value
20812: from BEN_LER_CHG_DPNT_CVG_F LDC
20813: where
20814: LDC.LER_ID = l_LER_ID and
20815: nvl(LDC.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
20816: nvl(LDC.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 20826: from BEN_LER_CHG_DPNT_CVG_F LDC1

20822: and effective_end_date ;
20823: --END TEMPIK
20824: /*TEMPIK
20825: and exists ( select null
20826: from BEN_LER_CHG_DPNT_CVG_F LDC1
20827: where
20828: LDC1.LER_ID = l_LER_ID and
20829: nvl(LDC1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
20830: nvl(LDC1.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 20835: from BEN_LER_CHG_DPNT_CVG_F LDC2

20831: nvl(LDC1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
20832: LDC1.business_group_id = c_business_group_id
20833: and LDC1.effective_start_date <= c_effective_start_date )
20834: and exists ( select null
20835: from BEN_LER_CHG_DPNT_CVG_F LDC2
20836: where
20837: LDC2.LER_ID = l_LER_ID and
20838: nvl(LDC2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
20839: nvl(LDC2.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 20989: (p_base_table_name => 'BEN_LER_CHG_DPNT_CVG_F',

20985: if c_find_LDC_in_target%found then
20986: --
20987: --TEMPIK
20988: l_dt_rec_found := dt_api.check_min_max_dates
20989: (p_base_table_name => 'BEN_LER_CHG_DPNT_CVG_F',
20990: p_base_key_column => 'LER_CHG_DPNT_CVG_ID',
20991: p_base_key_value => l_new_value,
20992: p_from_date => l_min_esd,
20993: p_to_date => l_max_eed );

Line 21048: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F CREATE_LER_CHG_DEPENDENT_CVG ',20);

21044: end if;
21045:
21046: if l_first_rec and not l_update then
21047: -- Call Create routine.
21048: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F CREATE_LER_CHG_DEPENDENT_CVG ',20);
21049: BEN_LER_CHG_DEPENDENT_CVG_API.CREATE_LER_CHG_DEPENDENT_CVG(
21050: --
21051: P_VALIDATE => false
21052: ,P_EFFECTIVE_DATE => l_effective_date

Line 21124: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F UPDATE_LER_CHG_DEPENDENT_CVG ',30);

21120: else
21121: --
21122: -- Call Update routine for the pk_id created in prev run .
21123: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
21124: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F UPDATE_LER_CHG_DEPENDENT_CVG ',30);
21125: --UPD START
21126: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
21127: --
21128: if l_update then