APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_PY_BSS_RT_F

Line 9748: -- and tr.where_clause = l_BEN_PY_BSS_RT_F

9744: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9745: pqh_table_route tr
9746: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9747: and cpe.table_route_id = tr.table_route_id
9748: -- and tr.where_clause = l_BEN_PY_BSS_RT_F
9749: and tr.table_alias = l_table_alias
9750: and cpe.number_of_copies = 1 -- ADDITION
9751: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
9752: order by information1, information2; --added for bug: 5151945

Line 9786: from BEN_PY_BSS_RT_F PBR

9782: c_business_group_id number,
9783: c_new_pk_id number) is
9784: select
9785: PBR.py_bss_rt_id new_value
9786: from BEN_PY_BSS_RT_F PBR
9787: where
9788: PBR.PAY_BASIS_ID = l_PAY_BASIS_ID and
9789: PBR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9790: PBR.business_group_id = c_business_group_id

Line 9798: from BEN_PY_BSS_RT_F PBR1

9794: and effective_end_date ;
9795: --END TEMPIK
9796: /*TEMPIK
9797: and exists ( select null
9798: from BEN_PY_BSS_RT_F PBR1
9799: where
9800: PBR1.PAY_BASIS_ID = l_PAY_BASIS_ID and
9801: PBR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9802: PBR1.business_group_id = c_business_group_id

Line 9805: from BEN_PY_BSS_RT_F PBR2

9801: PBR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9802: PBR1.business_group_id = c_business_group_id
9803: and PBR1.effective_start_date <= c_effective_start_date )
9804: and exists ( select null
9805: from BEN_PY_BSS_RT_F PBR2
9806: where
9807: PBR2.PAY_BASIS_ID = l_PAY_BASIS_ID and
9808: PBR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
9809: PBR2.business_group_id = c_business_group_id

Line 9958: (p_base_table_name => 'BEN_PY_BSS_RT_F',

9954: if c_find_PBR_in_target%found then
9955: --
9956: --TEMPIK
9957: l_dt_rec_found := dt_api.check_min_max_dates
9958: (p_base_table_name => 'BEN_PY_BSS_RT_F',
9959: p_base_key_column => 'PY_BSS_RT_ID',
9960: p_base_key_value => l_new_value,
9961: p_from_date => l_min_esd,
9962: p_to_date => l_max_eed );

Line 10016: hr_utility.set_location(' BEN_PY_BSS_RT_F CREATE_PAY_BASIS_RATE ',20);

10012: end if;
10013:
10014: if l_first_rec and not l_update then
10015: -- Call Create routine.
10016: hr_utility.set_location(' BEN_PY_BSS_RT_F CREATE_PAY_BASIS_RATE ',20);
10017: BEN_PAY_BASIS_RATE_API.CREATE_PAY_BASIS_RATE(
10018: --
10019: P_VALIDATE => false
10020: ,P_EFFECTIVE_DATE => l_effective_date

Line 10107: hr_utility.set_location(' BEN_PY_BSS_RT_F UPDATE_PAY_BASIS_RATE ',30);

10103: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
10104: --
10105: IF l_update OR l_dml_operation <> 'UPDATE' THEN
10106: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
10107: hr_utility.set_location(' BEN_PY_BSS_RT_F UPDATE_PAY_BASIS_RATE ',30);
10108: BEN_PAY_BASIS_RATE_API.UPDATE_PAY_BASIS_RATE(
10109: --
10110: P_VALIDATE => false
10111: ,P_EFFECTIVE_DATE => l_effective_date