APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_SCHEDD_HRS_RT_F

Line 24684: -- and tr.where_clause = l_BEN_SCHEDD_HRS_RT_F

24680: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24681: pqh_table_route tr
24682: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24683: and cpe.table_route_id = tr.table_route_id
24684: -- and tr.where_clause = l_BEN_SCHEDD_HRS_RT_F
24685: and tr.table_alias = l_table_alias
24686: and cpe.number_of_copies = 1 -- ADDITION
24687: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
24688: order by information1, information2; --added for bug: 5151945

Line 24722: from BEN_SCHEDD_HRS_RT_F SHR

24718: c_business_group_id number,
24719: c_new_pk_id number) is
24720: select
24721: SHR.schedd_hrs_rt_id new_value
24722: from BEN_SCHEDD_HRS_RT_F SHR
24723: where
24724: SHR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
24725: NVL(SHR.HRS_NUM,-999) = NVL(l_HRS_NUM,-999) and
24726: NVL(SHR.FREQ_CD,-999) = NVL(l_FREQ_CD,-999) and

Line 24742: from BEN_SCHEDD_HRS_RT_F SHR1

24738: and effective_end_date ;
24739: --END TEMPIK
24740: /*TEMPIK
24741: and exists ( select null
24742: from BEN_SCHEDD_HRS_RT_F SHR1
24743: where
24744: SHR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
24745: NVL(SHR1.HRS_NUM,-999) = NVL(l_HRS_NUM,-999) and
24746: NVL(SHR1.FREQ_CD,-999) = NVL(l_FREQ_CD,-999) and

Line 24757: from BEN_SCHEDD_HRS_RT_F SHR2

24753: SHR1.ORDR_NUM = l_ORDR_NUM and
24754: SHR1.business_group_id = c_business_group_id
24755: and SHR1.effective_start_date <= c_effective_start_date )
24756: and exists ( select null
24757: from BEN_SCHEDD_HRS_RT_F SHR2
24758: where
24759: SHR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
24760: NVL(SHR2.HRS_NUM,-999) = NVL(l_HRS_NUM,-999) and
24761: NVL(SHR2.FREQ_CD,-999) = NVL(l_FREQ_CD,-999) and

Line 24910: (p_base_table_name => 'BEN_SCHEDD_HRS_RT_F',

24906: if c_find_SHR_in_target%found then
24907: --
24908: --TEMPIK
24909: l_dt_rec_found := dt_api.check_min_max_dates
24910: (p_base_table_name => 'BEN_SCHEDD_HRS_RT_F',
24911: p_base_key_column => 'SCHEDD_HRS_RT_ID',
24912: p_base_key_value => l_new_value,
24913: p_from_date => l_min_esd,
24914: p_to_date => l_max_eed );

Line 24968: hr_utility.set_location(' BEN_SCHEDD_HRS_RT_F CREATE_SCHEDD_HRS_RATE ',20);

24964: end if;
24965:
24966: if l_first_rec and not l_update then
24967: -- Call Create routine.
24968: hr_utility.set_location(' BEN_SCHEDD_HRS_RT_F CREATE_SCHEDD_HRS_RATE ',20);
24969: BEN_SCHEDD_HRS_RATE_API.CREATE_SCHEDD_HRS_RATE(
24970: --
24971: P_VALIDATE => false
24972: ,P_EFFECTIVE_DATE => l_effective_date

Line 25067: hr_utility.set_location(' BEN_SCHEDD_HRS_RT_F UPDATE_SCHEDD_HRS_RATE ',30);

25063: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
25064: --
25065: IF l_update OR l_dml_operation <> 'UPDATE' THEN
25066: --UPD END
25067: hr_utility.set_location(' BEN_SCHEDD_HRS_RT_F UPDATE_SCHEDD_HRS_RATE ',30);
25068: BEN_SCHEDD_HRS_RATE_API.UPDATE_SCHEDD_HRS_RATE(
25069: --
25070: P_VALIDATE => false
25071: ,P_EFFECTIVE_DATE => l_effective_date