DBA Data[Home] [Help]

APPS.HR_DYNSQL dependencies on PAY_ELEMENT_LINKS_F

Line 214: pay_element_links_f pel,

210: lookup_type,
211: uom,
212: input_curr
213: from pay_element_entries_f pee,
214: pay_element_links_f pel,
215: pay_element_types_f pet,
216: pay_input_values_f piv,
217: per_all_assignments_f asg
218: where asg.assignment_id = p_assignment_id

Line 767: pay_element_links_f pel,

763: pel.element_link_id,
764: pee.effective_start_date
765: into stop_ee_id, link_id, stop_ee_start_date
766: from pay_element_entries_f pee,
767: pay_element_links_f pel,
768: per_all_assignments_f asg
769: where asg.assignment_id = p_assignment_id
770: and p_date_earned between
771: asg.effective_start_date and asg.effective_end_date