APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_QUA_IN_GR_PRTE_F

Line 28159: l_QUAR_IN_GRADE_CD ben_elig_qua_in_gr_prte_f.quar_in_grade_cd%type;

28155: ,p_prefix_suffix_cd in varchar2 default null
28156: ) is
28157: --
28158: l_ELIGY_PRFL_ID number;
28159: l_QUAR_IN_GRADE_CD ben_elig_qua_in_gr_prte_f.quar_in_grade_cd%type;
28160: l_ORDR_NUM ben_elig_qua_in_gr_prte_f.ordr_num%type;
28161:
28162: cursor c_unique_EQG(l_table_alias varchar2) is
28163: select distinct cpe.information1,

Line 28160: l_ORDR_NUM ben_elig_qua_in_gr_prte_f.ordr_num%type;

28156: ) is
28157: --
28158: l_ELIGY_PRFL_ID number;
28159: l_QUAR_IN_GRADE_CD ben_elig_qua_in_gr_prte_f.quar_in_grade_cd%type;
28160: l_ORDR_NUM ben_elig_qua_in_gr_prte_f.ordr_num%type;
28161:
28162: cursor c_unique_EQG(l_table_alias varchar2) is
28163: select distinct cpe.information1,
28164: cpe.information2,

Line 28171: -- and tr.where_clause = l_BEN_ELIG_QUA_IN_GR_PRTE_F

28167: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
28168: pqh_table_route tr
28169: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28170: and cpe.table_route_id = tr.table_route_id
28171: -- and tr.where_clause = l_BEN_ELIG_QUA_IN_GR_PRTE_F
28172: and tr.table_alias = l_table_alias
28173: and cpe.number_of_copies = 1 -- ADDITION
28174: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
28175: order by information1, information2; --added for bug: 5151945

Line 28209: from BEN_ELIG_QUA_IN_GR_PRTE_F EQG

28205: c_business_group_id number,
28206: c_new_pk_id number) is
28207: select
28208: EQG.elig_qua_in_gr_prte_id new_value
28209: from BEN_ELIG_QUA_IN_GR_PRTE_F EQG
28210: where
28211: EQG.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
28212: EQG.QUAR_IN_GRADE_CD = l_QUAR_IN_GRADE_CD and
28213: EQG.ORDR_NUM = l_ORDR_NUM and

Line 28221: from BEN_ELIG_QUA_IN_GR_PRTE_F EQG1

28217: and effective_end_date ;
28218: --END TEMPIK
28219: /*TEMPIK
28220: and exists ( select null
28221: from BEN_ELIG_QUA_IN_GR_PRTE_F EQG1
28222: where
28223: EQG1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
28224: EQG1.QUAR_IN_GRADE_CD = l_QUAR_IN_GRADE_CD and
28225: EQG1.ORDR_NUM = l_ORDR_NUM and

Line 28229: from BEN_ELIG_QUA_IN_GR_PRTE_F EQG2

28225: EQG1.ORDR_NUM = l_ORDR_NUM and
28226: EQG1.business_group_id = c_business_group_id
28227: and EQG1.effective_start_date <= c_effective_start_date )
28228: and exists ( select null
28229: from BEN_ELIG_QUA_IN_GR_PRTE_F EQG2
28230: where
28231: EQG2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
28232: EQG2.QUAR_IN_GRADE_CD = l_QUAR_IN_GRADE_CD and
28233: EQG2.ORDR_NUM = l_ORDR_NUM and

Line 28387: (p_base_table_name => 'BEN_ELIG_QUA_IN_GR_PRTE_F',

28383: if c_find_EQG_in_target%found then
28384: --
28385: --TEMPIK
28386: l_dt_rec_found := dt_api.check_min_max_dates
28387: (p_base_table_name => 'BEN_ELIG_QUA_IN_GR_PRTE_F',
28388: p_base_key_column => 'ELIG_QUA_IN_GR_PRTE_ID',
28389: p_base_key_value => l_new_value,
28390: p_from_date => l_min_esd,
28391: p_to_date => l_max_eed );

Line 28447: hr_utility.set_location(' BEN_ELIG_QUA_IN_GR_PRTE_F CREATE_ELIG_QUA_IN_GR_PRTE ',20);

28443: end if;
28444:
28445: if l_first_rec and not l_update then
28446: -- Call Create routine.
28447: hr_utility.set_location(' BEN_ELIG_QUA_IN_GR_PRTE_F CREATE_ELIG_QUA_IN_GR_PRTE ',20);
28448: BEN_ELIG_QUA_IN_GR_PRTE_API.CREATE_ELIG_QUA_IN_GR_PRTE(
28449: --
28450: P_VALIDATE => false
28451: ,P_EFFECTIVE_DATE => l_effective_date

Line 28520: hr_utility.set_location(' BEN_ELIG_QUA_IN_GR_PRTE_F UPDATE_ELIG_QUA_IN_GR_PRTE ',30);

28516: else
28517: --
28518: -- Call Update routine for the pk_id created in prev run .
28519: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
28520: hr_utility.set_location(' BEN_ELIG_QUA_IN_GR_PRTE_F UPDATE_ELIG_QUA_IN_GR_PRTE ',30);
28521: --UPD START
28522: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
28523: --
28524: if l_update then