DBA Data[Home] [Help]

APPS.HXT_GEN_AAI dependencies on PER_ASSIGNMENTS_F

Line 68: , per_assignments_f asm

64: and er.effective_end_date
65: and er.element_type_id NOT IN
66: (select ern.element_type_id
67: from pay_element_links_f ell
68: , per_assignments_f asm
69: , hxt_earning_rules ern
70: where ern.egp_id = erp.id
71: and p_effective_start_date between ern.effective_start_date
72: and ern.effective_end_date

Line 150: ,per_assignments_f asm

146: and dr.effective_end_date
147: and dr.element_type_id not in
148: (select sdr.element_type_id
149: from pay_element_links_f ell
150: ,per_assignments_f asm
151: ,hxt_shift_diff_rules sdr
152: where sdr.sdp_id = sdp.id
153: and p_effective_start_date between sdr.effective_start_date
154: and sdr.effective_end_date

Line 206: FROM per_assignments_f

202: l_hdp_compatible VARCHAR2(15) := NULL;
203:
204: CURSOR c_asg_bus_grp_id IS
205: SELECT business_group_id
206: FROM per_assignments_f
207: WHERE p_effective_start_date between effective_start_date
208: and effective_end_date
209: And assignment_type = 'E'
210: And assignment_id = p_assignment_id;