APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_EE_STAT_RT_F

Line 2624: -- and tr.where_clause = l_BEN_EE_STAT_RT_F

2620: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2621: pqh_table_route tr
2622: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2623: and cpe.table_route_id = tr.table_route_id
2624: -- and tr.where_clause = l_BEN_EE_STAT_RT_F
2625: and tr.table_alias = l_table_alias
2626: and cpe.number_of_copies = 1 -- ADDITION
2627: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2628: order by information1, information2; --added for bug: 5151945

Line 2662: from BEN_EE_STAT_RT_F ESR

2658: c_business_group_id number,
2659: c_new_pk_id number) is
2660: select
2661: ESR.ee_stat_rt_id new_value
2662: from BEN_EE_STAT_RT_F ESR
2663: where
2664: ESR.ASSIGNMENT_STATUS_TYPE_ID = l_ASSIGNMENT_STATUS_TYPE_ID and
2665: ESR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
2666: ESR.ORDR_NUM = l_ORDR_NUM and

Line 2675: from BEN_EE_STAT_RT_F ESR1

2671: and effective_end_date ;
2672: --END TEMPIK
2673: /*TEMPIK
2674: and exists ( select null
2675: from BEN_EE_STAT_RT_F ESR1
2676: where
2677: ESR1.ASSIGNMENT_STATUS_TYPE_ID = l_ASSIGNMENT_STATUS_TYPE_ID and
2678: ESR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
2679: ESR1.ORDR_NUM = l_ORDR_NUM and

Line 2683: from BEN_EE_STAT_RT_F ESR2

2679: ESR1.ORDR_NUM = l_ORDR_NUM and
2680: ESR1.business_group_id = c_business_group_id
2681: and ESR1.effective_start_date <= c_effective_start_date )
2682: and exists ( select null
2683: from BEN_EE_STAT_RT_F ESR2
2684: where
2685: ESR2.ASSIGNMENT_STATUS_TYPE_ID = l_ASSIGNMENT_STATUS_TYPE_ID and
2686: ESR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
2687: ESR2.ORDR_NUM = l_ORDR_NUM and

Line 2837: (p_base_table_name => 'BEN_EE_STAT_RT_F',

2833: if c_find_ESR_in_target%found then
2834: --
2835: --TEMPIK
2836: l_dt_rec_found := dt_api.check_min_max_dates
2837: (p_base_table_name => 'BEN_EE_STAT_RT_F',
2838: p_base_key_column => 'EE_STAT_RT_ID',
2839: p_base_key_value => l_new_value,
2840: p_from_date => l_min_esd,
2841: p_to_date => l_max_eed );

Line 2895: hr_utility.set_location(' BEN_EE_STAT_RT_F CREATE_EMPLOYEE_STATUS_RT ',20);

2891: end if;
2892:
2893: if l_first_rec and not l_update then
2894: -- Call Create routine.
2895: hr_utility.set_location(' BEN_EE_STAT_RT_F CREATE_EMPLOYEE_STATUS_RT ',20);
2896: BEN_EMPLOYEE_STATUS_RT_API.CREATE_EMPLOYEE_STATUS_RT(
2897: --
2898: P_VALIDATE => false
2899: ,P_EFFECTIVE_DATE => l_effective_date

Line 2987: hr_utility.set_location(' BEN_EE_STAT_RT_F UPDATE_EMPLOYEE_STATUS_RT ',30);

2983: --
2984: IF l_update OR l_dml_operation <> 'UPDATE' THEN
2985: --UPD END
2986: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
2987: hr_utility.set_location(' BEN_EE_STAT_RT_F UPDATE_EMPLOYEE_STATUS_RT ',30);
2988: BEN_EMPLOYEE_STATUS_RT_API.UPDATE_EMPLOYEE_STATUS_RT(
2989: --
2990: P_VALIDATE => false
2991: ,P_EFFECTIVE_DATE => l_effective_date