DBA Data[Home] [Help]

APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 243: FROM per_all_people_f ppl

239: ,p_info_type IN VARCHAR2)
240: RETURN VARCHAR2 AS
241: CURSOR csr_get_marital_status IS
242: SELECT marital_status
243: FROM per_all_people_f ppl
244: ,per_all_assignments_f asg
245: WHERE asg.assignment_id = p_assignment_id
246: AND ppl.person_id = asg.person_id
247: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date