APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_POPL_RPTG_GRP_F

Line 14532: -- and tr.where_clause = l_BEN_POPL_RPTG_GRP_F

14528: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14529: pqh_table_route tr
14530: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14531: and cpe.table_route_id = tr.table_route_id
14532: -- and tr.where_clause = l_BEN_POPL_RPTG_GRP_F
14533: and tr.table_alias = l_table_alias
14534: and cpe.number_of_copies = 1 -- ADDITION
14535: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14536: order by information1, information2; --added for bug: 5151945

Line 14570: from BEN_POPL_RPTG_GRP_F RGR

14566: c_business_group_id number,
14567: c_new_pk_id number) is
14568: select
14569: RGR.popl_rptg_grp_id new_value
14570: from BEN_POPL_RPTG_GRP_F RGR
14571: where
14572: nvl(RGR.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
14573: nvl(RGR.PL_ID,-999) = nvl(l_PL_ID,-999) and
14574: RGR.RPTG_GRP_ID = l_RPTG_GRP_ID and

Line 14583: from BEN_POPL_RPTG_GRP_F RGR1

14579: and effective_end_date ;
14580: --END TEMPIK
14581: /*TEMPIK
14582: and exists ( select null
14583: from BEN_POPL_RPTG_GRP_F RGR1
14584: where
14585: nvl(RGR1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
14586: nvl(RGR1.PL_ID,-999) = nvl(l_PL_ID,-999) and
14587: RGR1.RPTG_GRP_ID = l_RPTG_GRP_ID and

Line 14591: from BEN_POPL_RPTG_GRP_F RGR2

14587: RGR1.RPTG_GRP_ID = l_RPTG_GRP_ID and
14588: RGR1.business_group_id = c_business_group_id
14589: and RGR1.effective_start_date <= c_effective_start_date )
14590: and exists ( select null
14591: from BEN_POPL_RPTG_GRP_F RGR2
14592: where
14593: nvl(RGR2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
14594: nvl(RGR2.PL_ID,-999) = nvl(l_PL_ID,-999) and
14595: RGR2.RPTG_GRP_ID = l_RPTG_GRP_ID and

Line 14745: (p_base_table_name => 'BEN_POPL_RPTG_GRP_F',

14741: if c_find_RGR_in_target%found then
14742: --
14743: --TEMPIK
14744: l_dt_rec_found := dt_api.check_min_max_dates
14745: (p_base_table_name => 'BEN_POPL_RPTG_GRP_F',
14746: p_base_key_column => 'POPL_RPTG_GRP_ID',
14747: p_base_key_value => l_new_value,
14748: p_from_date => l_min_esd,
14749: p_to_date => l_max_eed );

Line 14805: hr_utility.set_location(' BEN_POPL_RPTG_GRP_F CREATE_POPL_RPTG_GRP ',20);

14801: end if;
14802:
14803: if l_first_rec and not l_update then
14804: -- Call Create routine.
14805: hr_utility.set_location(' BEN_POPL_RPTG_GRP_F CREATE_POPL_RPTG_GRP ',20);
14806: BEN_POPL_RPTG_GRP_API.CREATE_POPL_RPTG_GRP(
14807: --
14808: P_VALIDATE => false
14809: ,P_EFFECTIVE_DATE => l_effective_date

Line 14871: hr_utility.set_location(' BEN_POPL_RPTG_GRP_F UPDATE_POPL_RPTG_GRP ',30);

14867: else
14868: --
14869: -- Call Update routine for the pk_id created in prev run .
14870: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
14871: hr_utility.set_location(' BEN_POPL_RPTG_GRP_F UPDATE_POPL_RPTG_GRP ',30);
14872: --UPD START
14873: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
14874: --
14875: if l_update then