APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_PYRL_RT_F

Line 9274: -- and tr.where_clause = l_BEN_PYRL_RT_F

9270: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9271: pqh_table_route tr
9272: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9273: and cpe.table_route_id = tr.table_route_id
9274: -- and tr.where_clause = l_BEN_PYRL_RT_F
9275: and tr.table_alias = l_table_alias
9276: and cpe.number_of_copies = 1 -- ADDITION
9277: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode ;
9278: --

Line 9311: from BEN_PYRL_RT_F PR_

9307: c_business_group_id number,
9308: c_new_pk_id number) is
9309: select
9310: PR_.pyrl_rt_id new_value
9311: from BEN_PYRL_RT_F PR_
9312: where
9313: PR_.PAYROLL_ID = l_PAYROLL_ID and
9314: PR_.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9315: PR_.business_group_id = c_business_group_id

Line 9323: from BEN_PYRL_RT_F PR_1

9319: and effective_end_date ;
9320: --END TEMPIK
9321: /*TEMPIK
9322: and exists ( select null
9323: from BEN_PYRL_RT_F PR_1
9324: where
9325: PR_1.PAYROLL_ID = l_PAYROLL_ID and
9326: PR_1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9327: PR_1.business_group_id = c_business_group_id

Line 9330: from BEN_PYRL_RT_F PR_2

9326: PR_1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9327: PR_1.business_group_id = c_business_group_id
9328: and PR_1.effective_start_date <= c_effective_start_date )
9329: and exists ( select null
9330: from BEN_PYRL_RT_F PR_2
9331: where
9332: PR_2.PAYROLL_ID = l_PAYROLL_ID and
9333: PR_2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9334: PR_2.business_group_id = c_business_group_id

Line 9482: (p_base_table_name => 'BEN_PYRL_RT_F',

9478: if c_find_PR__in_target%found then
9479: --
9480: --TEMPIK
9481: l_dt_rec_found := dt_api.check_min_max_dates
9482: (p_base_table_name => 'BEN_PYRL_RT_F',
9483: p_base_key_column => 'PYRL_RT_ID',
9484: p_base_key_value => l_new_value,
9485: p_from_date => l_min_esd,
9486: p_to_date => l_max_eed );

Line 9540: hr_utility.set_location(' BEN_PYRL_RT_F CREATE_PAYROLL_RATE ',20);

9536: end if;
9537:
9538: if l_first_rec and not l_update then
9539: -- Call Create routine.
9540: hr_utility.set_location(' BEN_PYRL_RT_F CREATE_PAYROLL_RATE ',20);
9541: BEN_PAYROLL_RATE_API.CREATE_PAYROLL_RATE(
9542: --
9543: P_VALIDATE => false
9544: ,P_EFFECTIVE_DATE => l_effective_date

Line 9632: hr_utility.set_location(' BEN_PYRL_RT_F UPDATE_PAYROLL_RATE ',30);

9628: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
9629: --
9630: IF l_update OR l_dml_operation <> 'UPDATE' THEN
9631: --UPD END
9632: hr_utility.set_location(' BEN_PYRL_RT_F UPDATE_PAYROLL_RATE ',30);
9633: BEN_PAYROLL_RATE_API.UPDATE_PAYROLL_RATE(
9634: --
9635: P_VALIDATE => false
9636: ,P_EFFECTIVE_DATE => l_effective_date