APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_REGY_PRP_F

Line 25687: l_PL_REGY_PRPS_CD ben_pl_regy_prp_f.pl_regy_prps_cd%type;

25683: ) is
25684: --
25685: l_PL_REGY_BOD_ID number;
25686:
25687: l_PL_REGY_PRPS_CD ben_pl_regy_prp_f.pl_regy_prps_cd%type;
25688: cursor c_unique_PRP(l_table_alias varchar2) is
25689: select distinct cpe.information1,
25690: cpe.information2,
25691: cpe.information3,

Line 25697: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F

25693: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25694: pqh_table_route tr
25695: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25696: and cpe.table_route_id = tr.table_route_id
25697: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F
25698: and tr.table_alias = l_table_alias
25699: and cpe.number_of_copies = 1 -- ADDITION
25700: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
25701: order by information1, information2; --added for bug: 5151945

Line 25735: from BEN_PL_REGY_PRP_F PRP

25731: c_business_group_id number,
25732: c_new_pk_id number) is
25733: select
25734: PRP.pl_regy_prps_id new_value
25735: from BEN_PL_REGY_PRP_F PRP
25736: where
25737: PRP.PL_REGY_BOD_ID = l_PL_REGY_BOD_ID and
25738: PRP.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25739: PRP.business_group_id = c_business_group_id

Line 25747: from BEN_PL_REGY_PRP_F PRP1

25743: and effective_end_date ;
25744: --END TEMPIK
25745: /*
25746: and exists ( select null
25747: from BEN_PL_REGY_PRP_F PRP1
25748: where
25749: PRP1.PL_REGY_BOD_ID = l_PL_REGY_BOD_ID and
25750: PRP1.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25751: PRP1.business_group_id = c_business_group_id

Line 25754: from BEN_PL_REGY_PRP_F PRP2

25750: PRP1.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25751: PRP1.business_group_id = c_business_group_id
25752: and PRP1.effective_start_date <= c_effective_start_date )
25753: and exists ( select null
25754: from BEN_PL_REGY_PRP_F PRP2
25755: where
25756: PRP2.PL_REGY_BOD_ID = l_PL_REGY_BOD_ID and
25757: PRP2.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25758: PRP2.business_group_id = c_business_group_id

Line 25963: hr_utility.set_location(' BEN_PL_REGY_PRP_F CREATE_REGULATORY_PURPOSE ',20);

25959: end if;
25960:
25961: if l_first_rec and not l_update then
25962: -- Call Create routine.
25963: hr_utility.set_location(' BEN_PL_REGY_PRP_F CREATE_REGULATORY_PURPOSE ',20);
25964: BEN_REGULATORY_PURPOSE_API.CREATE_REGULATORY_PURPOSE(
25965: --
25966: P_VALIDATE => false
25967: ,P_EFFECTIVE_DATE => l_effective_date

Line 26028: hr_utility.set_location(' BEN_PL_REGY_PRP_F UPDATE_REGULATORY_PURPOSE ',30);

26024: else
26025: --
26026: -- Call Update routine for the pk_id created in prev run .
26027: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
26028: hr_utility.set_location(' BEN_PL_REGY_PRP_F UPDATE_REGULATORY_PURPOSE ',30);
26029: --UPD START
26030: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
26031: --
26032: if l_update then