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.

APPS.PAY_SE_GENERAL dependencies on PER_ALL_PEOPLE_F

Line 67: from per_all_assignments_f PAAF,per_all_people_f PAPF

63:
64: cursor csr_Get_Age
65: is
66: select floor((months_between(TRUNC(p_DATE_EARNED,'yyyy') ,PAPF.DATE_OF_BIRTH ))/12)
67: from per_all_assignments_f PAAF,per_all_people_f PAPF
68: where PAAF.ASSIGNMENT_ID =p_ASSIGNMENT_ID
69: and PAAF.PERSON_ID = PAPF.PERSON_ID
70: and PAAF.BUSINESS_GROUP_ID= PAPF.BUSINESS_GROUP_ID
71: and p_DATE_EARNED between

Line 229: ,per_all_people_f per

225: CURSOR get_details(csr_v_input_value VARCHAR2 ) IS
226: SELECT eev1.screen_entry_value screen_entry_value
227: FROM per_all_assignments_f asg1
228: ,per_all_assignments_f asg2
229: ,per_all_people_f per
230: ,pay_element_links_f el
231: ,pay_element_types_f et
232: ,pay_input_values_f iv1
233: ,pay_element_entries_f ee