APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_REGY_PRP_F

Line 25789: l_PL_REGY_PRPS_CD ben_pl_regy_prp_f.pl_regy_prps_cd%type;

25785: ) is
25786: --
25787: l_PL_REGY_BOD_ID number;
25788:
25789: l_PL_REGY_PRPS_CD ben_pl_regy_prp_f.pl_regy_prps_cd%type;
25790: cursor c_unique_PRP(l_table_alias varchar2) is
25791: select distinct cpe.information1,
25792: cpe.information2,
25793: cpe.information3,

Line 25799: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F

25795: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25796: pqh_table_route tr
25797: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25798: and cpe.table_route_id = tr.table_route_id
25799: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F
25800: and tr.table_alias = l_table_alias
25801: and cpe.number_of_copies = 1 -- ADDITION
25802: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
25803: order by information1, information2; --added for bug: 5151945

Line 25837: from BEN_PL_REGY_PRP_F PRP

25833: c_business_group_id number,
25834: c_new_pk_id number) is
25835: select
25836: PRP.pl_regy_prps_id new_value
25837: from BEN_PL_REGY_PRP_F PRP
25838: where
25839: PRP.PL_REGY_BOD_ID = l_PL_REGY_BOD_ID and
25840: PRP.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25841: PRP.business_group_id = c_business_group_id

Line 25849: from BEN_PL_REGY_PRP_F PRP1

25845: and effective_end_date ;
25846: --END TEMPIK
25847: /*
25848: and exists ( select null
25849: from BEN_PL_REGY_PRP_F PRP1
25850: where
25851: PRP1.PL_REGY_BOD_ID = l_PL_REGY_BOD_ID and
25852: PRP1.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25853: PRP1.business_group_id = c_business_group_id

Line 25856: from BEN_PL_REGY_PRP_F PRP2

25852: PRP1.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25853: PRP1.business_group_id = c_business_group_id
25854: and PRP1.effective_start_date <= c_effective_start_date )
25855: and exists ( select null
25856: from BEN_PL_REGY_PRP_F PRP2
25857: where
25858: PRP2.PL_REGY_BOD_ID = l_PL_REGY_BOD_ID and
25859: PRP2.PL_REGY_PRPS_CD = l_PL_REGY_PRPS_CD and
25860: PRP2.business_group_id = c_business_group_id

Line 26006: (p_base_table_name => 'BEN_PL_REGY_PRP_F', --bug 12558413

26002: if c_find_PRP_in_target%found then
26003: --
26004: --TEMPIK
26005: l_dt_rec_found := dt_api.check_min_max_dates
26006: (p_base_table_name => 'BEN_PL_REGY_PRP_F', --bug 12558413
26007: p_base_key_column => 'PL_REGY_PRPS_ID',
26008: p_base_key_value => l_new_value,
26009: p_from_date => l_min_esd,
26010: p_to_date => l_max_eed );

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

26061: end if;
26062:
26063: if l_first_rec and not l_update then
26064: -- Call Create routine.
26065: hr_utility.set_location(' BEN_PL_REGY_PRP_F CREATE_REGULATORY_PURPOSE ',20);
26066: BEN_REGULATORY_PURPOSE_API.CREATE_REGULATORY_PURPOSE(
26067: --
26068: P_VALIDATE => false
26069: ,P_EFFECTIVE_DATE => l_effective_date

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

26126: else
26127: --
26128: -- Call Update routine for the pk_id created in prev run .
26129: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
26130: hr_utility.set_location(' BEN_PL_REGY_PRP_F UPDATE_REGULATORY_PURPOSE ',30);
26131: --UPD START
26132: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
26133: --
26134: if l_update then