APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 1660: -- and tr.where_clause = l_BEN_PL_DPNT_CVG_CTFN_F

1656: cpe.table_route_id
1657: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
1658: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1659: and cpe.table_route_id = tr.table_route_id
1660: -- and tr.where_clause = l_BEN_PL_DPNT_CVG_CTFN_F
1661: and tr.table_alias = l_table_alias
1662: and cpe.number_of_copies = 1 --ADDITION
1663: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
1664: order by information1, information2; --added for bug: 5151945

Line 1698: from BEN_PL_DPNT_CVG_CTFN_F PND

1694: c_business_group_id number,
1695: c_new_pk_id number) is
1696: select
1697: PND.pl_dpnt_cvg_ctfn_id new_value
1698: from BEN_PL_DPNT_CVG_CTFN_F PND
1699: where
1700: nvl(PND.PL_ID,-999) = nvl(l_PL_ID,-999) and
1701: PND.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
1702: PND.business_group_id = c_business_group_id

Line 1710: from BEN_PL_DPNT_CVG_CTFN_F PND1

1706: and effective_end_date ;
1707: --END TEMPIK
1708: /* TEMPIK
1709: and exists ( select null
1710: from BEN_PL_DPNT_CVG_CTFN_F PND1
1711: where
1712: nvl(PND1.PL_ID,-999) = nvl(l_PL_ID,-999) and
1713: PND1.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
1714: PND1.business_group_id = c_business_group_id

Line 1717: from BEN_PL_DPNT_CVG_CTFN_F PND2

1713: PND1.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
1714: PND1.business_group_id = c_business_group_id
1715: and PND1.effective_start_date <= c_effective_start_date )
1716: and exists ( select null
1717: from BEN_PL_DPNT_CVG_CTFN_F PND2
1718: where
1719: nvl(PND2.PL_ID,-999) = nvl(l_PL_ID,-999) and
1720: PND2.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
1721: PND2.business_group_id = c_business_group_id

Line 1860: (p_base_table_name => 'BEN_PL_DPNT_CVG_CTFN_F',

1856: if c_find_PND_in_target%found then
1857: --
1858: --TEMPIK
1859: l_dt_rec_found := dt_api.check_min_max_dates
1860: (p_base_table_name => 'BEN_PL_DPNT_CVG_CTFN_F',
1861: p_base_key_column => 'PL_DPNT_CVG_CTFN_ID',
1862: p_base_key_value => l_new_value,
1863: p_from_date => l_min_esd,
1864: p_to_date => l_max_eed );

Line 1920: hr_utility.set_location(' BEN_PL_DPNT_CVG_CTFN_F CREATE_PLAN_DPNT_CVG_CTFN ',20);

1916: end if;
1917:
1918: if l_first_rec and not l_update then
1919: -- Call Create routine.
1920: hr_utility.set_location(' BEN_PL_DPNT_CVG_CTFN_F CREATE_PLAN_DPNT_CVG_CTFN ',20);
1921: BEN_PLAN_DPNT_CVG_CTFN_API.CREATE_PLAN_DPNT_CVG_CTFN(
1922: --
1923: P_VALIDATE => false
1924: ,P_EFFECTIVE_DATE => l_effective_date

Line 1990: hr_utility.set_location(' BEN_PL_DPNT_CVG_CTFN_F UPDATE_PLAN_DPNT_CVG_CTFN ',30);

1986: else
1987: --
1988: -- Call Update routine for the pk_id created in prev run .
1989: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
1990: hr_utility.set_location(' BEN_PL_DPNT_CVG_CTFN_F UPDATE_PLAN_DPNT_CVG_CTFN ',30);
1991: --UPD START
1992: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
1993: --
1994: if l_update then