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_DK_EINR dependencies on PAY_ACTION_INFORMATION

Line 18: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;

14: l_counter number := 0;
15: l_ctr number := 0;
16: l_line_num number := 0;
17: l_sender_id VARCHAR2(8);
18: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;
19: l_flag VARCHAR2(1):='N';
20: l_flag_end VARCHAR2(1):='N';
21: /* End of declaration*/
22:

Line 27: FROM pay_action_information pai

23: /* Cursors */
24: /* Cursor to fetch data related to Record 1000*/
25: CURSOR csr_1000 (p_payroll_action_id NUMBER) IS
26: SELECT pai.*
27: FROM pay_action_information pai
28: WHERE pai.action_context_id= p_payroll_action_id
29: AND pai.action_context_type= 'PA'
30: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
31: AND pai.action_information1 = 'PYDKEINA'

Line 38: FROM pay_action_information pai

34:
35: /* Cursor to fetch data related to Record 2001*/
36: CURSOR csr_2001 (p_payroll_action_id NUMBER) IS
37: SELECT pai.*
38: FROM pay_action_information pai
39: WHERE pai.action_context_id= p_payroll_action_id
40: AND pai.action_context_type= 'PA'
41: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
42: AND pai.action_information1 = 'PYDKEINA'

Line 54: FROM pay_action_information pai , pay_assignment_actions paa

50: /* Cursor to fetch data related to Record 2101*/
51: /* bug 10367494 added new parameter p_se_no */
52: CURSOR csr_2101(p_payroll_action_id NUMBER,p_se_no varchar2) IS
53: SELECT pai.*
54: FROM pay_action_information pai , pay_assignment_actions paa
55: WHERE paa.payroll_action_id = p_payroll_action_id
56: AND pai.action_context_id= paa.assignment_action_id
57: AND pai.action_context_type= 'AAP'
58: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 69: FROM pay_action_information pai

65:
66: /* Cursor to fetch data related to Record 5000*/
67: CURSOR csr_5000(p_payroll_action_id NUMBER,p_se_no varchar2) IS
68: SELECT pai.*
69: FROM pay_action_information pai
70: WHERE pai.action_context_id = p_payroll_action_id
71: AND pai.action_context_type= 'PA'
72: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
73: AND pai.action_information1 = 'PYDKEINA'

Line 81: FROM pay_action_information pai

77: rg_csr_5000 csr_5000%rowtype;
78:
79: CURSOR csr_5000R(p_payroll_action_id NUMBER,p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER,p_se_no varchar2) IS
80: SELECT pai.*
81: FROM pay_action_information pai
82: WHERE pai.action_context_id = p_payroll_action_id
83: AND pai.action_context_type= 'PA'
84: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
85: AND pai.action_information1 = 'PYDKEINA'

Line 97: FROM pay_action_information pai, pay_assignment_actions paa

93: /* Cursor to fetch data related to Record 6000*/
94: /* bug 10367494 added new parameter p_se_no */
95: CURSOR csr_6000(p_payroll_action_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER,p_se_no varchar2) IS /* 9489806 */
96: SELECT pai.*
97: FROM pay_action_information pai, pay_assignment_actions paa
98: WHERE paa.payroll_action_id= p_payroll_action_id
99: AND pai.action_context_id= paa.assignment_action_id
100: AND pai.action_context_type= 'AAP'
101: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 114: FROM pay_action_information pai, pay_assignment_actions paa

110:
111: /* Cursor to fetch data related to Record 8001 */
112: CURSOR csr_8001(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
113: SELECT pai.*
114: FROM pay_action_information pai, pay_assignment_actions paa
115: WHERE paa.payroll_action_id= p_payroll_action_id
116: AND pai.action_context_id= paa.assignment_action_id
117: AND pai.action_context_type= 'AAP'
118: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 131: FROM pay_action_information pai, pay_assignment_actions paa

127:
128: /* 9587046R */
129: CURSOR csr_8001R(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
130: SELECT pai.*
131: FROM pay_action_information pai, pay_assignment_actions paa
132: WHERE paa.payroll_action_id= p_payroll_action_id
133: AND pai.action_context_id= paa.assignment_action_id
134: AND pai.action_context_type= 'AAP'
135: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 148: FROM pay_action_information pai, pay_assignment_actions paa

144:
145: /* Cursor to fetch data related to Record 6001 */
146: CURSOR csr_6001(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
147: SELECT pai.*
148: FROM pay_action_information pai, pay_assignment_actions paa
149: WHERE paa.payroll_action_id= p_payroll_action_id
150: AND pai.action_context_id= paa.assignment_action_id
151: AND pai.action_context_type= 'AAP'
152: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 166: FROM pay_action_information pai, pay_assignment_actions paa

162:
163: /* Cursor to fetch data related to Correction Record 6001 */
164: CURSOR csr_6001_corr(p_payroll_action_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER,p_se_no varchar2) IS /* 9489806 */
165: SELECT distinct pai.action_information5,pai.action_information3,action_context_id /* 9587046R */
166: FROM pay_action_information pai, pay_assignment_actions paa
167: WHERE paa.payroll_action_id= p_payroll_action_id
168: AND pai.action_context_id= paa.assignment_action_id
169: AND pai.action_context_type= 'AAP'
170: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 184: FROM pay_action_information pai, pay_assignment_actions paa

180:
181: /* Cursor to fetch data related to Correction Record 6001 */
182: CURSOR csr_6001_corr_asst(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
183: SELECT pai.*
184: FROM pay_action_information pai, pay_assignment_actions paa
185: WHERE paa.payroll_action_id= p_payroll_action_id
186: AND pai.action_context_id= paa.assignment_action_id
187: AND pai.action_context_type= 'AAP'
188: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 202: FROM pay_action_information pai, pay_assignment_actions paa

198:
199: /* Cursor to fetch data related to Correction Record 6000*/
200: CURSOR csr_6000_corr(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER,p_se_no varchar2) IS /* 9489806 */
201: SELECT pai.*
202: FROM pay_action_information pai, pay_assignment_actions paa
203: WHERE paa.payroll_action_id= p_payroll_action_id
204: AND pai.action_context_id= paa.assignment_action_id
205: AND pai.action_context_type= 'AAP'
206: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 220: FROM pay_action_information pai, pay_assignment_actions paa

216:
217: /* Cursor to fetch data related to Record 6002 */
218: CURSOR csr_6002(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
219: SELECT pai.*
220: FROM pay_action_information pai, pay_assignment_actions paa
221: WHERE paa.payroll_action_id= p_payroll_action_id
222: AND pai.action_context_id= paa.assignment_action_id
223: AND pai.action_context_type= 'AAP'
224: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 236: FROM pay_action_information pai, pay_assignment_actions paa

232:
233: /* Cursor to fetch data related to Record 6003 */
234: CURSOR csr_6003(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
235: SELECT pai.*
236: FROM pay_action_information pai, pay_assignment_actions paa
237: WHERE paa.payroll_action_id= p_payroll_action_id
238: AND pai.action_context_id= paa.assignment_action_id
239: AND pai.action_context_type= 'AAP'
240: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 252: FROM pay_action_information pai, pay_assignment_actions paa

248:
249: /* Cursor to fetch data related to Record 6004 */
250: CURSOR csr_6004(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
251: SELECT pai.*
252: FROM pay_action_information pai, pay_assignment_actions paa
253: WHERE paa.payroll_action_id= p_payroll_action_id
254: AND pai.action_context_id= paa.assignment_action_id
255: AND pai.action_context_type= 'AAP'
256: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 268: FROM pay_action_information pai, pay_assignment_actions paa

264:
265: /* Cursor to fetch data related to Record 6005 */
266: CURSOR csr_6005(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
267: SELECT pai.*
268: FROM pay_action_information pai, pay_assignment_actions paa
269: WHERE paa.payroll_action_id= p_payroll_action_id
270: AND pai.action_context_id= paa.assignment_action_id
271: AND pai.action_context_type= 'AAP'
272: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 286: FROM pay_action_information pai, pay_assignment_actions paa

282: --13463885
283: /* Cursor to fetch data related to Record 6102 */
284: CURSOR csr_6102(p_payroll_action_id NUMBER, p_assignment_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS /* 9489806 */
285: SELECT pai.*
286: FROM pay_action_information pai, pay_assignment_actions paa
287: WHERE paa.payroll_action_id= p_payroll_action_id
288: AND pai.action_context_id= paa.assignment_action_id
289: AND pai.action_context_type= 'AAP'
290: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 304: FROM pay_action_information pai

300:
301: /* Cursor to fetch data related to Record 9999 */
302: CURSOR csr_9999(p_payroll_action_id NUMBER) IS
303: SELECT pai.*
304: FROM pay_action_information pai
305: WHERE pai.action_context_id = p_payroll_action_id
306: AND pai.action_context_type= 'PA'
307: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
308: AND pai.action_information1 = 'PYDKEINA'