DBA Data[Home] [Help]

APPS.HXT_GEN_AAI dependencies on PAY_ELEMENT_LINKS_F

Line 67: from pay_element_links_f ell

63: and p_effective_start_date between er.effective_start_date
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

Line 149: from pay_element_links_f ell

145: and p_effective_start_date between dr.effective_start_date
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