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_SG_CPFLINE dependencies on PAY_SG_CPFLINE_BALANCES

Line 58: to_char(pay_sg_cpfline_balances.stat_type_amount

54: pay_magtape_generic.get_parameter_value('MONTH') month,
55: 'ADVICE_CODE=P',
56: '01' advice_code,
57: 'AV1_AMOUNT=P',
58: to_char(pay_sg_cpfline_balances.stat_type_amount
59: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV1')) av1_amount,
60: 'AV3_AMOUNT=P',
61: to_char(pay_sg_cpfline_balances.stat_type_amount
62: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV3')) av3_amount,

Line 61: to_char(pay_sg_cpfline_balances.stat_type_amount

57: 'AV1_AMOUNT=P',
58: to_char(pay_sg_cpfline_balances.stat_type_amount
59: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV1')) av1_amount,
60: 'AV3_AMOUNT=P',
61: to_char(pay_sg_cpfline_balances.stat_type_amount
62: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV3')) av3_amount,
63: 'AV4_AMOUNT=P',
64: to_char(pay_sg_cpfline_balances.stat_type_amount
65: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV4')) av4_amount,

Line 64: to_char(pay_sg_cpfline_balances.stat_type_amount

60: 'AV3_AMOUNT=P',
61: to_char(pay_sg_cpfline_balances.stat_type_amount
62: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV3')) av3_amount,
63: 'AV4_AMOUNT=P',
64: to_char(pay_sg_cpfline_balances.stat_type_amount
65: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV4')) av4_amount,
66: 'AV5_AMOUNT=P',
67: to_char(pay_sg_cpfline_balances.stat_type_amount
68: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV5')) av5_amount,

Line 67: to_char(pay_sg_cpfline_balances.stat_type_amount

63: 'AV4_AMOUNT=P',
64: to_char(pay_sg_cpfline_balances.stat_type_amount
65: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV4')) av4_amount,
66: 'AV5_AMOUNT=P',
67: to_char(pay_sg_cpfline_balances.stat_type_amount
68: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV5')) av5_amount,
69: 'AV7_AMOUNT=P',
70: to_char(pay_sg_cpfline_balances.stat_type_amount
71: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV7')) av7_amount,

Line 70: to_char(pay_sg_cpfline_balances.stat_type_amount

66: 'AV5_AMOUNT=P',
67: to_char(pay_sg_cpfline_balances.stat_type_amount
68: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV5')) av5_amount,
69: 'AV7_AMOUNT=P',
70: to_char(pay_sg_cpfline_balances.stat_type_amount
71: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV7')) av7_amount,
72: 'AVA_AMOUNT=P',
73: to_char(pay_sg_cpfline_balances.stat_type_amount
74: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVA')) ava_amount,

Line 73: to_char(pay_sg_cpfline_balances.stat_type_amount

69: 'AV7_AMOUNT=P',
70: to_char(pay_sg_cpfline_balances.stat_type_amount
71: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV7')) av7_amount,
72: 'AVA_AMOUNT=P',
73: to_char(pay_sg_cpfline_balances.stat_type_amount
74: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVA')) ava_amount,
75: 'AVE_AMOUNT=P',
76: to_char(pay_sg_cpfline_balances.stat_type_amount
77: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVE')) ave_amount,

Line 76: to_char(pay_sg_cpfline_balances.stat_type_amount

72: 'AVA_AMOUNT=P',
73: to_char(pay_sg_cpfline_balances.stat_type_amount
74: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVA')) ava_amount,
75: 'AVE_AMOUNT=P',
76: to_char(pay_sg_cpfline_balances.stat_type_amount
77: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVE')) ave_amount,
78: 'AVG_AMOUNT=P',
79: to_char(pay_sg_cpfline_balances.stat_type_amount
80: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVG')) avg_amount,

Line 79: to_char(pay_sg_cpfline_balances.stat_type_amount

75: 'AVE_AMOUNT=P',
76: to_char(pay_sg_cpfline_balances.stat_type_amount
77: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVE')) ave_amount,
78: 'AVG_AMOUNT=P',
79: to_char(pay_sg_cpfline_balances.stat_type_amount
80: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVG')) avg_amount,
81: 'MUS_COUNT=P',
82: to_char(pay_sg_cpfline_balances.stat_type_count
83: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'MUS')) mus_count,

Line 82: to_char(pay_sg_cpfline_balances.stat_type_count

78: 'AVG_AMOUNT=P',
79: to_char(pay_sg_cpfline_balances.stat_type_amount
80: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVG')) avg_amount,
81: 'MUS_COUNT=P',
82: to_char(pay_sg_cpfline_balances.stat_type_count
83: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'MUS')) mus_count,
84: 'SHA_COUNT=P',
85: to_char(pay_sg_cpfline_balances.stat_type_count
86: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SHA')) sha_count,

Line 85: to_char(pay_sg_cpfline_balances.stat_type_count

81: 'MUS_COUNT=P',
82: to_char(pay_sg_cpfline_balances.stat_type_count
83: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'MUS')) mus_count,
84: 'SHA_COUNT=P',
85: to_char(pay_sg_cpfline_balances.stat_type_count
86: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SHA')) sha_count,
87: 'SIN_COUNT=P',
88: to_char(pay_sg_cpfline_balances.stat_type_count
89: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SIN')) sin_count,

Line 88: to_char(pay_sg_cpfline_balances.stat_type_count

84: 'SHA_COUNT=P',
85: to_char(pay_sg_cpfline_balances.stat_type_count
86: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SHA')) sha_count,
87: 'SIN_COUNT=P',
88: to_char(pay_sg_cpfline_balances.stat_type_count
89: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SIN')) sin_count,
90: 'CDA_COUNT=P',
91: to_char(pay_sg_cpfline_balances.stat_type_count
92: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'CDA')) cda_count,

Line 91: to_char(pay_sg_cpfline_balances.stat_type_count

87: 'SIN_COUNT=P',
88: to_char(pay_sg_cpfline_balances.stat_type_count
89: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SIN')) sin_count,
90: 'CDA_COUNT=P',
91: to_char(pay_sg_cpfline_balances.stat_type_count
92: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'CDA')) cda_count,
93: 'ECF_COUNT=P',
94: to_char(pay_sg_cpfline_balances.stat_type_count
95: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'ECF')) ecf_count,

Line 94: to_char(pay_sg_cpfline_balances.stat_type_count

90: 'CDA_COUNT=P',
91: to_char(pay_sg_cpfline_balances.stat_type_count
92: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'CDA')) cda_count,
93: 'ECF_COUNT=P',
94: to_char(pay_sg_cpfline_balances.stat_type_count
95: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'ECF')) ecf_count,
96: 'TOTAL_CONTRIBUTION=P',
97: to_char(pay_sg_cpfline_balances.stat_type_amount
98: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'TOT')) total_contribution,

Line 97: to_char(pay_sg_cpfline_balances.stat_type_amount

93: 'ECF_COUNT=P',
94: to_char(pay_sg_cpfline_balances.stat_type_count
95: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'ECF')) ecf_count,
96: 'TOTAL_CONTRIBUTION=P',
97: to_char(pay_sg_cpfline_balances.stat_type_amount
98: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'TOT')) total_contribution,
99: 'CPF_INTEREST=P',
100: pay_sg_cpfline_balances.get_cpf_interest
101: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,

Line 100: pay_sg_cpfline_balances.get_cpf_interest

96: 'TOTAL_CONTRIBUTION=P',
97: to_char(pay_sg_cpfline_balances.stat_type_amount
98: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'TOT')) total_contribution,
99: 'CPF_INTEREST=P',
100: pay_sg_cpfline_balances.get_cpf_interest
101: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,
102: 'FWL_INTEREST=P',
103: pay_sg_cpfline_balances.get_fwl_interest
104: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest

Line 103: pay_sg_cpfline_balances.get_fwl_interest

99: 'CPF_INTEREST=P',
100: pay_sg_cpfline_balances.get_cpf_interest
101: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,
102: 'FWL_INTEREST=P',
103: pay_sg_cpfline_balances.get_fwl_interest
104: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest
105: from hr_organization_units hou,
106: hr_organization_information hoi1,
107: hr_organization_information hoi2

Line 205: pay_sg_cpfline_balances.get_balance_value( 'EE',

201: 'SORT=P',
202: decode(pai.action_information1,null,'1',(decode(pai.action_information21,'WP','1',(decode(pai.action_information21,'EP','1',(decode(pai.action_information21,'SP','1','0'))))))) sort,
203: pai.action_information3 hire_date,
204: 'VOL_CPF_LIAB=P',
205: pay_sg_cpfline_balances.get_balance_value( 'EE',
206: paa.assignment_id,
207: nvl(pai.action_information1,pai.source_id),
208: pai.action_information22,
209: paa.assignment_action_id,

Line 217: pay_sg_cpfline_balances.get_balance_value( 'EE',

213: ppa.payroll_action_id,
214: pai.action_information21
215: ) vol_cpf_liab,
216: 'CPF_LIAB=P',
217: pay_sg_cpfline_balances.get_balance_value( 'EE',
218: paa.assignment_id,
219: nvl(pai.action_information1,pai.source_id),
220: pai.action_information22,
221: paa.assignment_action_id,

Line 229: pay_sg_cpfline_balances.get_balance_value( 'EE',

225: ppa.payroll_action_id,
226: pai.action_information21
227: ) cpf_liab,
228: 'VOL_CPF_WITHHELD=P',
229: pay_sg_cpfline_balances.get_balance_value( 'EE',
230: paa.assignment_id,
231: nvl(pai.action_information1,pai.source_id),
232: pai.action_information22,
233: paa.assignment_action_id,

Line 241: pay_sg_cpfline_balances.get_balance_value( 'EE',

237: ppa.payroll_action_id,
238: pai.action_information21
239: ) vol_cpf_withheld,
240: 'CPF_WITHHELD=P',
241: pay_sg_cpfline_balances.get_balance_value( 'EE',
242: paa.assignment_id,
243: nvl(pai.action_information1,pai.source_id),
244: pai.action_information22,
245: paa.assignment_action_id,

Line 253: pay_sg_cpfline_balances.get_balance_value( 'EE',

249: ppa.payroll_action_id,
250: pai.action_information21
251: ) cpf_withheld,
252: 'MBMF_WITHHELD=P',
253: pay_sg_cpfline_balances.get_balance_value( 'EE',
254: paa.assignment_id,
255: nvl(pai.action_information1,pai.source_id),
256: pai.action_information22,
257: paa.assignment_action_id,

Line 265: pay_sg_cpfline_balances.get_balance_value( 'EE',

261: ppa.payroll_action_id,
262: pai.action_information21
263: ) mbmf_withheld,
264: 'SINDA_WITHHELD=P',
265: pay_sg_cpfline_balances.get_balance_value( 'EE',
266: paa.assignment_id,
267: nvl(pai.action_information1,pai.source_id),
268: pai.action_information22,
269: paa.assignment_action_id,

Line 277: pay_sg_cpfline_balances.get_balance_value( 'EE',

273: ppa.payroll_action_id,
274: pai.action_information21
275: ) sinda_withheld,
276: 'CDAC_WITHHELD=P',
277: pay_sg_cpfline_balances.get_balance_value( 'EE',
278: paa.assignment_id,
279: nvl(pai.action_information1,pai.source_id),
280: pai.action_information22,
281: paa.assignment_action_id,

Line 289: pay_sg_cpfline_balances.get_balance_value( 'EE',

285: ppa.payroll_action_id,
286: pai.action_information21
287: ) cdac_withheld,
288: 'ECF_WITHHELD=P',
289: pay_sg_cpfline_balances.get_balance_value( 'EE',
290: paa.assignment_id,
291: nvl(pai.action_information1,pai.source_id),
292: pai.action_information22,
293: paa.assignment_action_id,

Line 301: pay_sg_cpfline_balances.get_balance_value( 'EE',

297: ppa.payroll_action_id,
298: pai.action_information21
299: ) ecf_withheld,
300: 'CPF_ORD_ELIG_COMP=P',
301: pay_sg_cpfline_balances.get_balance_value( 'EE',
302: paa.assignment_id,
303: nvl(pai.action_information1,pai.source_id),
304: pai.action_information22,
305: paa.assignment_action_id,

Line 313: pay_sg_cpfline_balances.get_balance_value( 'EE',

309: ppa.payroll_action_id,
310: pai.action_information21
311: ) cpf_ord_elig_comp,
312: 'CPF_ADD_ELIG_COMP=P',
313: pay_sg_cpfline_balances.get_balance_value( 'EE',
314: paa.assignment_id,
315: nvl(pai.action_information1,pai.source_id),
316: pai.action_information22,
317: paa.assignment_action_id,

Line 325: pay_sg_cpfline_balances.get_balance_value( 'EE',

321: ppa.payroll_action_id,
322: pai.action_information21
323: ) cpf_add_elig_comp ,
324: 'LEGAL_NAME=P',
325: pay_sg_cpfline_balances.get_balance_value( 'EE',
326: paa.assignment_id,
327: nvl(pai.action_information1,pai.source_id),
328: pai.action_information22,
329: paa.assignment_action_id,

Line 337: pay_sg_cpfline_balances.get_balance_value( 'EE',

333: ppa.payroll_action_id,
334: pai.action_information21
335: ) legal_name,
336: 'EMPLOYEE_NUMBER=P',
337: pay_sg_cpfline_balances.get_balance_value( 'EE',
338: paa.assignment_id,
339: nvl(pai.action_information1,pai.source_id),
340: pai.action_information22,
341: paa.assignment_action_id,

Line 349: pay_sg_cpfline_balances.get_balance_value( 'EE',

345: ppa.payroll_action_id,
346: pai.action_information21
347: ) employee_number,
348: 'EMP_TERMINATION_DATE=P',
349: pay_sg_cpfline_balances.get_balance_value( 'EE',
350: paa.assignment_id,
351: nvl(pai.action_information1,pai.source_id),
352: pai.action_information22,
353: paa.assignment_action_id,

Line 475: pay_sg_cpfline_balances.get_balance_value( 'NEW',

471: 'SORT=P',
472: decode(pai.action_information1,null,'1',(decode(pai.action_information21,'WP','1',(decode(pai.action_information21,'EP','1',(decode(pai.action_information21,'SP','1','0'))))))) sort,
473: pai.action_information3 hire_date,
474: 'VOL_CPF_LIAB=P',
475: pay_sg_cpfline_balances.get_balance_value( 'NEW',
476: paa.assignment_id,
477: nvl(pai.action_information1,pai.source_id),
478: pai.action_information22,
479: paa.assignment_action_id,

Line 487: pay_sg_cpfline_balances.get_balance_value( 'NEW',

483: ppa.payroll_action_id,
484: pai.action_information21
485: ) vol_cpf_liab,
486: 'CPF_LIAB=P',
487: pay_sg_cpfline_balances.get_balance_value( 'NEW',
488: paa.assignment_id,
489: nvl(pai.action_information1,pai.source_id),
490: pai.action_information22,
491: paa.assignment_action_id,

Line 499: pay_sg_cpfline_balances.get_balance_value( 'NEW',

495: ppa.payroll_action_id,
496: pai.action_information21
497: ) cpf_liab,
498: 'VOL_CPF_WITHHELD=P',
499: pay_sg_cpfline_balances.get_balance_value( 'NEW',
500: paa.assignment_id,
501: nvl(pai.action_information1,pai.source_id),
502: pai.action_information22,
503: paa.assignment_action_id,

Line 511: pay_sg_cpfline_balances.get_balance_value( 'NEW',

507: ppa.payroll_action_id,
508: pai.action_information21
509: ) vol_cpf_withheld,
510: 'CPF_WITHHELD=P',
511: pay_sg_cpfline_balances.get_balance_value( 'NEW',
512: paa.assignment_id,
513: nvl(pai.action_information1,pai.source_id),
514: pai.action_information22,
515: paa.assignment_action_id,

Line 523: pay_sg_cpfline_balances.get_balance_value( 'NEW',

519: ppa.payroll_action_id,
520: pai.action_information21
521: ) cpf_withheld,
522: 'MBMF_WITHHELD=P',
523: pay_sg_cpfline_balances.get_balance_value( 'NEW',
524: paa.assignment_id,
525: nvl(pai.action_information1,pai.source_id),
526: pai.action_information22,
527: paa.assignment_action_id,

Line 535: pay_sg_cpfline_balances.get_balance_value( 'NEW',

531: ppa.payroll_action_id,
532: pai.action_information21
533: ) mbmf_withheld,
534: 'SINDA_WITHHELD=P',
535: pay_sg_cpfline_balances.get_balance_value( 'NEW',
536: paa.assignment_id,
537: nvl(pai.action_information1,pai.source_id),
538: pai.action_information22,
539: paa.assignment_action_id,

Line 547: pay_sg_cpfline_balances.get_balance_value( 'NEW',

543: ppa.payroll_action_id,
544: pai.action_information21
545: ) sinda_withheld,
546: 'CDAC_WITHHELD=P',
547: pay_sg_cpfline_balances.get_balance_value( 'NEW',
548: paa.assignment_id,
549: nvl(pai.action_information1,pai.source_id),
550: pai.action_information22,
551: paa.assignment_action_id,

Line 559: pay_sg_cpfline_balances.get_balance_value( 'NEW',

555: ppa.payroll_action_id,
556: pai.action_information21
557: ) cdac_withheld,
558: 'ECF_WITHHELD=P',
559: pay_sg_cpfline_balances.get_balance_value( 'NEW',
560: paa.assignment_id,
561: nvl(pai.action_information1,pai.source_id),
562: pai.action_information22,
563: paa.assignment_action_id,

Line 571: pay_sg_cpfline_balances.get_balance_value( 'NEW',

567: ppa.payroll_action_id,
568: pai.action_information21
569: ) ecf_withheld,
570: 'CPF_ORD_ELIG_COMP=P',
571: pay_sg_cpfline_balances.get_balance_value( 'NEW',
572: paa.assignment_id,
573: nvl(pai.action_information1,pai.source_id),
574: pai.action_information22,
575: paa.assignment_action_id,

Line 583: pay_sg_cpfline_balances.get_balance_value( 'NEW',

579: ppa.payroll_action_id,
580: pai.action_information21
581: ) cpf_ord_elig_comp,
582: 'CPF_ADD_ELIG_COMP=P',
583: pay_sg_cpfline_balances.get_balance_value( 'NEW',
584: paa.assignment_id,
585: nvl(pai.action_information1,pai.source_id),
586: pai.action_information22,
587: paa.assignment_action_id,

Line 595: pay_sg_cpfline_balances.get_balance_value( 'NEW',

591: ppa.payroll_action_id,
592: pai.action_information21
593: ) cpf_add_elig_comp ,
594: 'LEGAL_NAME=P',
595: pay_sg_cpfline_balances.get_balance_value( 'NEW',
596: paa.assignment_id,
597: nvl(pai.action_information1,pai.source_id),
598: pai.action_information22,
599: paa.assignment_action_id,

Line 607: pay_sg_cpfline_balances.get_balance_value( 'NEW',

603: ppa.payroll_action_id,
604: pai.action_information21
605: ) legal_name,
606: 'EMPLOYEE_NUMBER=P',
607: pay_sg_cpfline_balances.get_balance_value( 'NEW',
608: paa.assignment_id,
609: nvl(pai.action_information1,pai.source_id),
610: pai.action_information22,
611: paa.assignment_action_id,

Line 619: pay_sg_cpfline_balances.get_balance_value( 'NEW',

615: ppa.payroll_action_id,
616: pai.action_information21
617: ) employee_number,
618: 'EMP_TERMINATION_DATE=P',
619: pay_sg_cpfline_balances.get_balance_value( 'NEW',
620: paa.assignment_id,
621: nvl(pai.action_information1,pai.source_id),
622: pai.action_information22,
623: paa.assignment_action_id,