DBA Data[Home] [Help]

APPS.HR_DYNSQL dependencies on PAY_ELEMENT_LINKS_F

Line 209: pay_element_links_f pel,

205: lookup_type,
206: uom,
207: input_curr
208: from pay_element_entries_f pee,
209: pay_element_links_f pel,
210: pay_element_types_f pet,
211: pay_input_values_f piv,
212: per_all_assignments_f asg
213: where asg.assignment_id = p_assignment_id

Line 762: pay_element_links_f pel,

758: pel.element_link_id,
759: pee.effective_start_date
760: into stop_ee_id, link_id, stop_ee_start_date
761: from pay_element_entries_f pee,
762: pay_element_links_f pel,
763: per_all_assignments_f asg
764: where asg.assignment_id = p_assignment_id
765: and p_date_earned between
766: asg.effective_start_date and asg.effective_end_date