APPS.HXT_GEN_AAI dependencies on PAY_ELEMENT_TYPES_F

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 45: , pay_element_types_f t

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
49: and r.effective_end_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

Line 117: ,pay_element_types_f t

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
121: and r.effective_end_date

Line 132: from pay_element_types_f pet

128: and v.effective_end_date
129: and v.hxt_earning_category = 'SDF')
130: AND NOT EXISTS
131: (select 1
132: from pay_element_types_f pet
133: , hxt_shift_diff_rules hsdr
134: where hsdr.sdp_id = sdp.id
135: and p_effective_start_date between hsdr.effective_start_date
136: and hsdr.effective_end_date