APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_DSBLTY_CTG_PRTE_F

Line 21606: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_CTG_PRTE_F

21602: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21603: pqh_table_route tr
21604: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21605: and cpe.table_route_id = tr.table_route_id
21606: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_CTG_PRTE_F
21607: and tr.table_alias = l_table_alias
21608: and cpe.number_of_copies = 1 -- ADDITION
21609: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
21610: order by information1, information2; --added for bug: 5151945

Line 21644: from BEN_ELIG_DSBLTY_CTG_PRTE_F ECT

21640: c_business_group_id number,
21641: c_new_pk_id number) is
21642: select
21643: ECT.elig_dsblty_ctg_prte_id new_value
21644: from BEN_ELIG_DSBLTY_CTG_PRTE_F ECT
21645: where
21646: ECT.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
21647: ECT.CATEGORY =l_CATEGORY and
21648: ECT.ORDR_NUM =l_ORDR_NUM and

Line 21656: from BEN_ELIG_DSBLTY_CTG_PRTE_F ECT1

21652: and effective_end_date ;
21653: --END TEMPIK
21654: /*TEMPIK
21655: and exists ( select null
21656: from BEN_ELIG_DSBLTY_CTG_PRTE_F ECT1
21657: where
21658: ECT1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
21659: -- Additional Filter Condition
21660: ECT1.CATEGORY =l_CATEGORY and

Line 21666: from BEN_ELIG_DSBLTY_CTG_PRTE_F ECT2

21662:
21663: ECT1.business_group_id = c_business_group_id
21664: and ECT1.effective_start_date <= c_effective_start_date )
21665: and exists ( select null
21666: from BEN_ELIG_DSBLTY_CTG_PRTE_F ECT2
21667: where
21668: ECT2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
21669: -- Additional Filter Condition
21670: ECT2.CATEGORY = l_CATEGORY and

Line 21830: (p_base_table_name => 'BEN_ELIG_DSBLTY_CTG_PRTE_F',

21826: if c_find_ECT_in_target%found then
21827: --
21828: --TEMPIK
21829: l_dt_rec_found := dt_api.check_min_max_dates
21830: (p_base_table_name => 'BEN_ELIG_DSBLTY_CTG_PRTE_F',
21831: p_base_key_column => 'ELIG_DSBLTY_CTG_PRTE_ID',
21832: p_base_key_value => l_new_value,
21833: p_from_date => l_min_esd,
21834: p_to_date => l_max_eed );

Line 21890: hr_utility.set_location(' BEN_ELIG_DSBLTY_CTG_PRTE_F CREATE_ELIG_DSBLTY_CTG_PRTE ',20);

21886: end if;
21887:
21888: if l_first_rec and not l_update then
21889: -- Call Create routine.
21890: hr_utility.set_location(' BEN_ELIG_DSBLTY_CTG_PRTE_F CREATE_ELIG_DSBLTY_CTG_PRTE ',20);
21891: BEN_ELIG_DSBLTY_CTG_PRTE_API.CREATE_ELIG_DSBLTY_CTG_PRTE(
21892: --
21893: P_VALIDATE => false
21894: ,P_EFFECTIVE_DATE => l_effective_date

Line 21963: hr_utility.set_location(' BEN_ELIG_DSBLTY_CTG_PRTE_F UPDATE_ELIG_DSBLTY_CTG_PRTE ',30);

21959: else
21960: --
21961: -- Call Update routine for the pk_id created in prev run .
21962: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
21963: hr_utility.set_location(' BEN_ELIG_DSBLTY_CTG_PRTE_F UPDATE_ELIG_DSBLTY_CTG_PRTE ',30);
21964: --UPD START
21965: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
21966: --
21967: if l_update then