APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_JOB_PRTE_F

Line 7861: -- and tr.where_clause = l_BEN_ELIG_JOB_PRTE_F

7857: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7858: pqh_table_route tr
7859: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7860: and cpe.table_route_id = tr.table_route_id
7861: -- and tr.where_clause = l_BEN_ELIG_JOB_PRTE_F
7862: and tr.table_alias = l_table_alias
7863: and cpe.number_of_copies = 1 -- ADDITION
7864: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7865: order by information1, information2; --added for bug: 5151945

Line 7899: from BEN_ELIG_JOB_PRTE_F EJP

7895: c_business_group_id number,
7896: c_new_pk_id number) is
7897: select
7898: EJP.elig_job_prte_id new_value
7899: from BEN_ELIG_JOB_PRTE_F EJP
7900: where
7901: EJP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
7902: EJP.JOB_ID = l_JOB_ID and
7903: EJP.ORDR_NUM = l_ORDR_NUM and

Line 7911: from BEN_ELIG_JOB_PRTE_F EJP1

7907: and effective_end_date ;
7908: --END TEMPIK
7909: /*TEMPIK
7910: and exists ( select null
7911: from BEN_ELIG_JOB_PRTE_F EJP1
7912: where
7913: EJP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
7914: EJP1.JOB_ID = l_JOB_ID and
7915: EJP1.ORDR_NUM = l_ORDR_NUM and

Line 7919: from BEN_ELIG_JOB_PRTE_F EJP2

7915: EJP1.ORDR_NUM = l_ORDR_NUM and
7916: EJP1.business_group_id = c_business_group_id
7917: and EJP1.effective_start_date <= c_effective_start_date )
7918: and exists ( select null
7919: from BEN_ELIG_JOB_PRTE_F EJP2
7920: where
7921: EJP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
7922: EJP2.JOB_ID = l_JOB_ID and
7923: EJP2.ORDR_NUM = l_ORDR_NUM and

Line 8093: (p_base_table_name => 'BEN_ELIG_JOB_PRTE_F',

8089: if c_find_EJP_in_target%found then
8090: --
8091: --TEMPIK
8092: l_dt_rec_found := dt_api.check_min_max_dates
8093: (p_base_table_name => 'BEN_ELIG_JOB_PRTE_F',
8094: p_base_key_column => 'ELIG_JOB_PRTE_ID',
8095: p_base_key_value => l_new_value,
8096: p_from_date => l_min_esd,
8097: p_to_date => l_max_eed );

Line 8155: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F CREATE_ELIGY_JOB_PRTE ',20);

8151: end if;
8152:
8153: if l_first_rec and not l_update then
8154: -- Call Create routine.
8155: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F CREATE_ELIGY_JOB_PRTE ',20);
8156: BEN_ELIGY_JOB_PRTE_API.CREATE_ELIGY_JOB_PRTE(
8157: --
8158: P_VALIDATE => false
8159: ,P_EFFECTIVE_DATE => l_effective_date

Line 8228: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F UPDATE_ELIGY_JOB_PRTE ',30);

8224: else
8225: --
8226: -- Call Update routine for the pk_id created in prev run .
8227: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
8228: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F UPDATE_ELIGY_JOB_PRTE ',30);
8229: --UPD START
8230: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
8231: --
8232: if l_update then