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_IN_PAYSLIP_ARCHIVE dependencies on PER_CONTACT_RELATIONSHIPS

Line 1989: ,per_contact_relationships con

1985: ,pep.date_of_birth -- added for ECR
1986: FROM per_assignments_f asg
1987: ,per_people_f pep
1988: ,pay_assignment_actions paa
1989: ,per_contact_relationships con
1990: WHERE asg.PERSON_ID=pep.person_id
1991: AND asg.assignment_id=paa.assignment_id
1992: AND paa.assignment_action_id= p_assignment_action_id
1993: AND con.person_id(+) = pep.person_id

Line 2190: l_contact_type per_contact_relationships.contact_type%TYPE;

2186: l_excluded_employee_status NUMBER;
2187: l_contact_id NUMBER;
2188: l_procedure VARCHAR2(100);
2189: l_message VARCHAR2(255);
2190: l_contact_type per_contact_relationships.contact_type%TYPE;
2191: l_sex per_people_f.sex%TYPE;
2192: l_dob VARCHAR2(30);
2193: l_eps_wages NUMBER;
2194: l_term_date VARCHAR2(30);