APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_BRGNG_UNIT_RT_F

Line 2159: -- and tr.where_clause = l_BEN_BRGNG_UNIT_RT_F

2155: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2156: pqh_table_route tr
2157: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2158: and cpe.table_route_id = tr.table_route_id
2159: -- and tr.where_clause = l_BEN_BRGNG_UNIT_RT_F
2160: and tr.table_alias = l_table_alias
2161: and cpe.number_of_copies = 1 -- ADDITION
2162: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2163: order by information1, information2; --added for bug: 5151945

Line 2197: from BEN_BRGNG_UNIT_RT_F BUR

2193: c_business_group_id number,
2194: c_new_pk_id number) is
2195: select
2196: BUR.brgng_unit_rt_id new_value
2197: from BEN_BRGNG_UNIT_RT_F BUR
2198: where
2199: BUR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
2200: BUR.BRGNG_UNIT_CD = l_BRGNG_UNIT_CD and
2201: BUR.ORDR_NUM = l_ORDR_NUM and

Line 2210: from BEN_BRGNG_UNIT_RT_F BUR1

2206: and effective_end_date ;
2207: --END TEMPIK
2208: /*TEMPIK
2209: and exists ( select null
2210: from BEN_BRGNG_UNIT_RT_F BUR1
2211: where
2212: BUR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
2213: BUR1.BRGNG_UNIT_CD = l_BRGNG_UNIT_CD and
2214: BUR1.ORDR_NUM = l_ORDR_NUM and

Line 2218: from BEN_BRGNG_UNIT_RT_F BUR2

2214: BUR1.ORDR_NUM = l_ORDR_NUM and
2215: BUR1.business_group_id = c_business_group_id
2216: and BUR1.effective_start_date <= c_effective_start_date )
2217: and exists ( select null
2218: from BEN_BRGNG_UNIT_RT_F BUR2
2219: where
2220: BUR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
2221: BUR2.BRGNG_UNIT_CD = l_BRGNG_UNIT_CD and
2222: BUR2.ORDR_NUM = l_ORDR_NUM and

Line 2357: (p_base_table_name => 'BEN_BRGNG_UNIT_RT_F',

2353: if c_find_BUR_in_target%found then
2354: --
2355: --TEMPIK
2356: l_dt_rec_found := dt_api.check_min_max_dates
2357: (p_base_table_name => 'BEN_BRGNG_UNIT_RT_F',
2358: p_base_key_column => 'BRGNG_UNIT_RT_ID',
2359: p_base_key_value => l_new_value,
2360: p_from_date => l_min_esd,
2361: p_to_date => l_max_eed );

Line 2415: hr_utility.set_location(' BEN_BRGNG_UNIT_RT_F CREATE_BARGAINING_UNIT_RT ',20);

2411: end if;
2412:
2413: if l_first_rec and not l_update then
2414: -- Call Create routine.
2415: hr_utility.set_location(' BEN_BRGNG_UNIT_RT_F CREATE_BARGAINING_UNIT_RT ',20);
2416: BEN_BARGAINING_UNIT_RT_API.CREATE_BARGAINING_UNIT_RT(
2417: --
2418: P_VALIDATE => false
2419: ,P_EFFECTIVE_DATE => l_effective_date

Line 2507: hr_utility.set_location(' BEN_BRGNG_UNIT_RT_F UPDATE_BARGAINING_UNIT_RT ',30);

2503: --
2504: IF l_update OR l_dml_operation <> 'UPDATE' THEN
2505: --UPD END
2506: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
2507: hr_utility.set_location(' BEN_BRGNG_UNIT_RT_F UPDATE_BARGAINING_UNIT_RT ',30);
2508: BEN_BARGAINING_UNIT_RT_API.UPDATE_BARGAINING_UNIT_RT(
2509: --
2510: P_VALIDATE => false
2511: ,P_EFFECTIVE_DATE => l_effective_date