eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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