APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_PRBTN_PERD_PRTE_F

Line 15440: l_PROBATION_UNIT BEN_ELIG_PRBTN_PERD_PRTE_F.probation_unit%type;

15436: ) is
15437: --
15438: l_ELIGY_PRFL_ID number;
15439: l_PROBATION_PERIOD number;
15440: l_PROBATION_UNIT BEN_ELIG_PRBTN_PERD_PRTE_F.probation_unit%type;
15441: l_ORDR_NUM number;
15442:
15443: cursor c_unique_EPN(l_table_alias varchar2) is
15444: select distinct cpe.information1,

Line 15452: -- and tr.where_clause = l_BEN_ELIG_PRBTN_PERD_PRTE_F

15448: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15449: pqh_table_route tr
15450: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15451: and cpe.table_route_id = tr.table_route_id
15452: -- and tr.where_clause = l_BEN_ELIG_PRBTN_PERD_PRTE_F
15453: and tr.table_alias = l_table_alias
15454: and cpe.number_of_copies = 1 -- ADDITION
15455: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15456: order by information1, information2; --added for bug: 5151945

Line 15490: from BEN_ELIG_PRBTN_PERD_PRTE_F EPN

15486: c_business_group_id number,
15487: c_new_pk_id number) is
15488: select
15489: EPN.elig_prbtn_perd_prte_id new_value
15490: from BEN_ELIG_PRBTN_PERD_PRTE_F EPN
15491: where
15492: EPN.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
15493: EPN.business_group_id = c_business_group_id and
15494: EPN.PROBATION_PERIOD = l_PROBATION_PERIOD and

Line 15503: from BEN_ELIG_PRBTN_PERD_PRTE_F EPN1

15499: and effective_end_date ;
15500: --END TEMPIK
15501: /*TEMPIK
15502: and exists ( select null
15503: from BEN_ELIG_PRBTN_PERD_PRTE_F EPN1
15504: where
15505: EPN1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
15506: EPN1.PROBATION_PERIOD = l_PROBATION_PERIOD and -- Added this criteria
15507: EPN1.PROBATION_UNIT = l_PROBATION_UNIT and -- Added this criteria

Line 15512: from BEN_ELIG_PRBTN_PERD_PRTE_F EPN2

15508: EPN1.ORDR_NUM = l_ORDR_NUM and -- Added this criteria
15509: EPN1.business_group_id = c_business_group_id
15510: and EPN1.effective_start_date <= c_effective_start_date )
15511: and exists ( select null
15512: from BEN_ELIG_PRBTN_PERD_PRTE_F EPN2
15513: where
15514: EPN2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
15515: EPN2.PROBATION_PERIOD = l_PROBATION_PERIOD and -- Added this criteria
15516: EPN2.PROBATION_UNIT = l_PROBATION_UNIT and -- Added this criteria

Line 15675: (p_base_table_name => 'BEN_ELIG_PRBTN_PERD_PRTE_F',

15671: if c_find_EPN_in_target%found then
15672: --
15673: --TEMPIK
15674: l_dt_rec_found := dt_api.check_min_max_dates
15675: (p_base_table_name => 'BEN_ELIG_PRBTN_PERD_PRTE_F',
15676: p_base_key_column => 'ELIG_PRBTN_PERD_PRTE_ID',
15677: p_base_key_value => l_new_value,
15678: p_from_date => l_min_esd,
15679: p_to_date => l_max_eed );

Line 15735: hr_utility.set_location(' BEN_ELIG_PRBTN_PERD_PRTE_F CREATE_ELIG_PRBTN_PERD_PRTE ',20);

15731: end if;
15732:
15733: if l_first_rec and not l_update then
15734: -- Call Create routine.
15735: hr_utility.set_location(' BEN_ELIG_PRBTN_PERD_PRTE_F CREATE_ELIG_PRBTN_PERD_PRTE ',20);
15736: BEN_ELIG_PRBTN_PERD_PRTE_API.CREATE_ELIG_PRBTN_PERD_PRTE(
15737: --
15738: P_VALIDATE => false
15739: ,P_EFFECTIVE_DATE => l_effective_date

Line 15809: hr_utility.set_location(' BEN_ELIG_PRBTN_PERD_PRTE_F UPDATE_ELIG_PRBTN_PERD_PRTE ',30);

15805: else
15806: --
15807: -- Call Update routine for the pk_id created in prev run .
15808: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
15809: hr_utility.set_location(' BEN_ELIG_PRBTN_PERD_PRTE_F UPDATE_ELIG_PRBTN_PERD_PRTE ',30);
15810: --UPD START
15811: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15812: --
15813: if l_update then