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_TRNR dependencies on PAY_PAYROLL_ACTIONS

Line 47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

43: p_legal_employer_id pay_action_information.action_information13%TYPE --,
44: -- p_sort_order pay_action_information.action_information20%TYPE
45: ) IS
46: SELECT DISTINCT action_information14 division_code, action_information16 division
47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
48: WHERE paa.payroll_action_id = p_payroll_action_id
49: AND assg.payroll_action_id = paa.payroll_action_id
50: AND pai.action_context_id = assg.assignment_action_id
51: AND action_context_type = 'AAP'

Line 64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

60: p_legal_employer_id pay_action_information.action_information13%TYPE,
61: p_div pay_action_information.action_information14%TYPE
62: ) IS
63: SELECT DISTINCT action_information15 area_code, action_information17 agreement_area
64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
65: WHERE paa.payroll_action_id = p_payroll_action_id
66: AND assg.payroll_action_id = paa.payroll_action_id
67: AND pai.action_context_id = assg.assignment_action_id
68: AND action_context_type = 'AAP'

Line 99: FROM pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1

95: IF p_payroll_action_id IS NULL THEN
96: BEGIN
97: SELECT payroll_action_id
98: INTO l_payroll_action_id
99: FROM pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1
100: WHERE fcrs.request_id = fnd_global.conc_request_id
101: AND fcrs.priority_request_id = fcrs1.priority_request_id
102: AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
103: AND ppa.request_id = fcrs1.request_id;

Line 211: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

207: precedence_date,
208: fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,
209: action_information12
210: emp_sec
211: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
212: WHERE paa.payroll_action_id = '
213: || l_payroll_action_id
214: || ' AND assg.payroll_action_id = paa.payroll_action_id
215: AND pai.action_context_id = assg.assignment_action_id