APPS.HXT_GEN_AAI dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V

Line 44: from hxt_pay_element_types_f_ddf_v v

40: and erp.effective_end_date
41: AND erp.business_group_id = nvl(asg_bus_grp_id, -99)
42: AND EXISTS
43: (select 1
44: from hxt_pay_element_types_f_ddf_v v
45: , pay_element_types_f t
46: , hxt_earning_rules r
47: where r.egp_id = erp.id
48: and p_effective_start_date between r.effective_start_date

Line 116: from hxt_pay_element_types_f_ddf_v v

112: and nvl(sdp.date_to
113: ,p_effective_start_date)
114: AND EXISTS
115: (select 1
116: from hxt_pay_element_types_f_ddf_v v
117: ,pay_element_types_f t
118: ,hxt_shift_diff_rules r
119: where r.sdp_id = sdp.id
120: and p_effective_start_date between r.effective_start_date