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 48: to_char(pay_sg_cpfline_balances.stat_type_amount

44: pay_magtape_generic.get_parameter_value('MONTH') month,
45: 'ADVICE_CODE=P',
46: '01' advice_code,
47: 'AV1_AMOUNT=P',
48: to_char(pay_sg_cpfline_balances.stat_type_amount
49: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV1')) av1_amount,
50: 'AV3_AMOUNT=P',
51: to_char(pay_sg_cpfline_balances.stat_type_amount
52: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV3')) av3_amount,

Line 51: to_char(pay_sg_cpfline_balances.stat_type_amount

47: 'AV1_AMOUNT=P',
48: to_char(pay_sg_cpfline_balances.stat_type_amount
49: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV1')) av1_amount,
50: 'AV3_AMOUNT=P',
51: to_char(pay_sg_cpfline_balances.stat_type_amount
52: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV3')) av3_amount,
53: 'AV4_AMOUNT=P',
54: to_char(pay_sg_cpfline_balances.stat_type_amount
55: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV4')) av4_amount,

Line 54: to_char(pay_sg_cpfline_balances.stat_type_amount

50: 'AV3_AMOUNT=P',
51: to_char(pay_sg_cpfline_balances.stat_type_amount
52: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV3')) av3_amount,
53: 'AV4_AMOUNT=P',
54: to_char(pay_sg_cpfline_balances.stat_type_amount
55: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV4')) av4_amount,
56: 'AV5_AMOUNT=P',
57: to_char(pay_sg_cpfline_balances.stat_type_amount
58: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV5')) av5_amount,

Line 57: to_char(pay_sg_cpfline_balances.stat_type_amount

53: 'AV4_AMOUNT=P',
54: to_char(pay_sg_cpfline_balances.stat_type_amount
55: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV4')) av4_amount,
56: 'AV5_AMOUNT=P',
57: to_char(pay_sg_cpfline_balances.stat_type_amount
58: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV5')) av5_amount,
59: 'AV7_AMOUNT=P',
60: to_char(pay_sg_cpfline_balances.stat_type_amount
61: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV7')) av7_amount,

Line 60: to_char(pay_sg_cpfline_balances.stat_type_amount

56: 'AV5_AMOUNT=P',
57: to_char(pay_sg_cpfline_balances.stat_type_amount
58: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV5')) av5_amount,
59: 'AV7_AMOUNT=P',
60: to_char(pay_sg_cpfline_balances.stat_type_amount
61: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV7')) av7_amount,
62: 'AVA_AMOUNT=P',
63: to_char(pay_sg_cpfline_balances.stat_type_amount
64: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVA')) ava_amount,

Line 63: to_char(pay_sg_cpfline_balances.stat_type_amount

59: 'AV7_AMOUNT=P',
60: to_char(pay_sg_cpfline_balances.stat_type_amount
61: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV7')) av7_amount,
62: 'AVA_AMOUNT=P',
63: to_char(pay_sg_cpfline_balances.stat_type_amount
64: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVA')) ava_amount,
65: 'AVE_AMOUNT=P',
66: to_char(pay_sg_cpfline_balances.stat_type_amount
67: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVE')) ave_amount,

Line 66: to_char(pay_sg_cpfline_balances.stat_type_amount

62: 'AVA_AMOUNT=P',
63: to_char(pay_sg_cpfline_balances.stat_type_amount
64: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVA')) ava_amount,
65: 'AVE_AMOUNT=P',
66: to_char(pay_sg_cpfline_balances.stat_type_amount
67: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVE')) ave_amount,
68: 'AVG_AMOUNT=P',
69: to_char(pay_sg_cpfline_balances.stat_type_amount
70: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVG')) avg_amount,

Line 69: to_char(pay_sg_cpfline_balances.stat_type_amount

65: 'AVE_AMOUNT=P',
66: to_char(pay_sg_cpfline_balances.stat_type_amount
67: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVE')) ave_amount,
68: 'AVG_AMOUNT=P',
69: to_char(pay_sg_cpfline_balances.stat_type_amount
70: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVG')) avg_amount,
71: 'MUS_COUNT=P',
72: to_char(pay_sg_cpfline_balances.stat_type_count
73: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'MUS')) mus_count,

Line 72: to_char(pay_sg_cpfline_balances.stat_type_count

68: 'AVG_AMOUNT=P',
69: to_char(pay_sg_cpfline_balances.stat_type_amount
70: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVG')) avg_amount,
71: 'MUS_COUNT=P',
72: to_char(pay_sg_cpfline_balances.stat_type_count
73: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'MUS')) mus_count,
74: 'SHA_COUNT=P',
75: to_char(pay_sg_cpfline_balances.stat_type_count
76: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SHA')) sha_count,

Line 75: to_char(pay_sg_cpfline_balances.stat_type_count

71: 'MUS_COUNT=P',
72: to_char(pay_sg_cpfline_balances.stat_type_count
73: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'MUS')) mus_count,
74: 'SHA_COUNT=P',
75: to_char(pay_sg_cpfline_balances.stat_type_count
76: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SHA')) sha_count,
77: 'SIN_COUNT=P',
78: to_char(pay_sg_cpfline_balances.stat_type_count
79: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SIN')) sin_count,

Line 78: to_char(pay_sg_cpfline_balances.stat_type_count

74: 'SHA_COUNT=P',
75: to_char(pay_sg_cpfline_balances.stat_type_count
76: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SHA')) sha_count,
77: 'SIN_COUNT=P',
78: to_char(pay_sg_cpfline_balances.stat_type_count
79: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SIN')) sin_count,
80: 'CDA_COUNT=P',
81: to_char(pay_sg_cpfline_balances.stat_type_count
82: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'CDA')) cda_count,

Line 81: to_char(pay_sg_cpfline_balances.stat_type_count

77: 'SIN_COUNT=P',
78: to_char(pay_sg_cpfline_balances.stat_type_count
79: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SIN')) sin_count,
80: 'CDA_COUNT=P',
81: to_char(pay_sg_cpfline_balances.stat_type_count
82: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'CDA')) cda_count,
83: 'ECF_COUNT=P',
84: to_char(pay_sg_cpfline_balances.stat_type_count
85: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'ECF')) ecf_count,

Line 84: to_char(pay_sg_cpfline_balances.stat_type_count

80: 'CDA_COUNT=P',
81: to_char(pay_sg_cpfline_balances.stat_type_count
82: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'CDA')) cda_count,
83: 'ECF_COUNT=P',
84: to_char(pay_sg_cpfline_balances.stat_type_count
85: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'ECF')) ecf_count,
86: 'TOTAL_CONTRIBUTION=P',
87: to_char(pay_sg_cpfline_balances.stat_type_amount
88: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'TOT')) total_contribution,

Line 87: to_char(pay_sg_cpfline_balances.stat_type_amount

83: 'ECF_COUNT=P',
84: to_char(pay_sg_cpfline_balances.stat_type_count
85: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'ECF')) ecf_count,
86: 'TOTAL_CONTRIBUTION=P',
87: to_char(pay_sg_cpfline_balances.stat_type_amount
88: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'TOT')) total_contribution,
89: 'CPF_INTEREST=P',
90: pay_sg_cpfline_balances.get_cpf_interest
91: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,

Line 90: pay_sg_cpfline_balances.get_cpf_interest

86: 'TOTAL_CONTRIBUTION=P',
87: to_char(pay_sg_cpfline_balances.stat_type_amount
88: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'TOT')) total_contribution,
89: 'CPF_INTEREST=P',
90: pay_sg_cpfline_balances.get_cpf_interest
91: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,
92: 'FWL_INTEREST=P',
93: pay_sg_cpfline_balances.get_fwl_interest
94: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest

Line 93: pay_sg_cpfline_balances.get_fwl_interest

89: 'CPF_INTEREST=P',
90: pay_sg_cpfline_balances.get_cpf_interest
91: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,
92: 'FWL_INTEREST=P',
93: pay_sg_cpfline_balances.get_fwl_interest
94: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest
95: from hr_organization_units hou,
96: hr_organization_information hoi1,
97: hr_organization_information hoi2

Line 187: pay_sg_cpfline_balances.get_balance_value( 'EE',

183: 'SORT=P',
184: 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,
185: pai.action_information3 hire_date,
186: 'VOL_CPF_LIAB=P',
187: pay_sg_cpfline_balances.get_balance_value( 'EE',
188: paa.assignment_id,
189: nvl(pai.action_information1,pai.source_id),
190: pai.action_information22,
191: paa.assignment_action_id,

Line 199: pay_sg_cpfline_balances.get_balance_value( 'EE',

195: ppa.payroll_action_id,
196: pai.action_information21
197: ) vol_cpf_liab,
198: 'CPF_LIAB=P',
199: pay_sg_cpfline_balances.get_balance_value( 'EE',
200: paa.assignment_id,
201: nvl(pai.action_information1,pai.source_id),
202: pai.action_information22,
203: paa.assignment_action_id,

Line 211: pay_sg_cpfline_balances.get_balance_value( 'EE',

207: ppa.payroll_action_id,
208: pai.action_information21
209: ) cpf_liab,
210: 'VOL_CPF_WITHHELD=P',
211: pay_sg_cpfline_balances.get_balance_value( 'EE',
212: paa.assignment_id,
213: nvl(pai.action_information1,pai.source_id),
214: pai.action_information22,
215: paa.assignment_action_id,

Line 223: pay_sg_cpfline_balances.get_balance_value( 'EE',

219: ppa.payroll_action_id,
220: pai.action_information21
221: ) vol_cpf_withheld,
222: 'CPF_WITHHELD=P',
223: pay_sg_cpfline_balances.get_balance_value( 'EE',
224: paa.assignment_id,
225: nvl(pai.action_information1,pai.source_id),
226: pai.action_information22,
227: paa.assignment_action_id,

Line 235: pay_sg_cpfline_balances.get_balance_value( 'EE',

231: ppa.payroll_action_id,
232: pai.action_information21
233: ) cpf_withheld,
234: 'MBMF_WITHHELD=P',
235: pay_sg_cpfline_balances.get_balance_value( 'EE',
236: paa.assignment_id,
237: nvl(pai.action_information1,pai.source_id),
238: pai.action_information22,
239: paa.assignment_action_id,

Line 247: pay_sg_cpfline_balances.get_balance_value( 'EE',

243: ppa.payroll_action_id,
244: pai.action_information21
245: ) mbmf_withheld,
246: 'SINDA_WITHHELD=P',
247: pay_sg_cpfline_balances.get_balance_value( 'EE',
248: paa.assignment_id,
249: nvl(pai.action_information1,pai.source_id),
250: pai.action_information22,
251: paa.assignment_action_id,

Line 259: pay_sg_cpfline_balances.get_balance_value( 'EE',

255: ppa.payroll_action_id,
256: pai.action_information21
257: ) sinda_withheld,
258: 'CDAC_WITHHELD=P',
259: pay_sg_cpfline_balances.get_balance_value( 'EE',
260: paa.assignment_id,
261: nvl(pai.action_information1,pai.source_id),
262: pai.action_information22,
263: paa.assignment_action_id,

Line 271: pay_sg_cpfline_balances.get_balance_value( 'EE',

267: ppa.payroll_action_id,
268: pai.action_information21
269: ) cdac_withheld,
270: 'ECF_WITHHELD=P',
271: pay_sg_cpfline_balances.get_balance_value( 'EE',
272: paa.assignment_id,
273: nvl(pai.action_information1,pai.source_id),
274: pai.action_information22,
275: paa.assignment_action_id,

Line 283: pay_sg_cpfline_balances.get_balance_value( 'EE',

279: ppa.payroll_action_id,
280: pai.action_information21
281: ) ecf_withheld,
282: 'CPF_ORD_ELIG_COMP=P',
283: pay_sg_cpfline_balances.get_balance_value( 'EE',
284: paa.assignment_id,
285: nvl(pai.action_information1,pai.source_id),
286: pai.action_information22,
287: paa.assignment_action_id,

Line 295: pay_sg_cpfline_balances.get_balance_value( 'EE',

291: ppa.payroll_action_id,
292: pai.action_information21
293: ) cpf_ord_elig_comp,
294: 'CPF_ADD_ELIG_COMP=P',
295: pay_sg_cpfline_balances.get_balance_value( 'EE',
296: paa.assignment_id,
297: nvl(pai.action_information1,pai.source_id),
298: pai.action_information22,
299: paa.assignment_action_id,

Line 307: pay_sg_cpfline_balances.get_balance_value( 'EE',

303: ppa.payroll_action_id,
304: pai.action_information21
305: ) cpf_add_elig_comp ,
306: 'LEGAL_NAME=P',
307: pay_sg_cpfline_balances.get_balance_value( 'EE',
308: paa.assignment_id,
309: nvl(pai.action_information1,pai.source_id),
310: pai.action_information22,
311: paa.assignment_action_id,

Line 319: pay_sg_cpfline_balances.get_balance_value( 'EE',

315: ppa.payroll_action_id,
316: pai.action_information21
317: ) legal_name,
318: 'EMPLOYEE_NUMBER=P',
319: pay_sg_cpfline_balances.get_balance_value( 'EE',
320: paa.assignment_id,
321: nvl(pai.action_information1,pai.source_id),
322: pai.action_information22,
323: paa.assignment_action_id,

Line 331: pay_sg_cpfline_balances.get_balance_value( 'EE',

327: ppa.payroll_action_id,
328: pai.action_information21
329: ) employee_number,
330: 'EMP_TERMINATION_DATE=P',
331: pay_sg_cpfline_balances.get_balance_value( 'EE',
332: paa.assignment_id,
333: nvl(pai.action_information1,pai.source_id),
334: pai.action_information22,
335: paa.assignment_action_id,

Line 443: pay_sg_cpfline_balances.get_balance_value( 'NEW',

439: 'SORT=P',
440: 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,
441: pai.action_information3 hire_date,
442: 'VOL_CPF_LIAB=P',
443: pay_sg_cpfline_balances.get_balance_value( 'NEW',
444: paa.assignment_id,
445: nvl(pai.action_information1,pai.source_id),
446: pai.action_information22,
447: paa.assignment_action_id,

Line 455: pay_sg_cpfline_balances.get_balance_value( 'NEW',

451: ppa.payroll_action_id,
452: pai.action_information21
453: ) vol_cpf_liab,
454: 'CPF_LIAB=P',
455: pay_sg_cpfline_balances.get_balance_value( 'NEW',
456: paa.assignment_id,
457: nvl(pai.action_information1,pai.source_id),
458: pai.action_information22,
459: paa.assignment_action_id,

Line 467: pay_sg_cpfline_balances.get_balance_value( 'NEW',

463: ppa.payroll_action_id,
464: pai.action_information21
465: ) cpf_liab,
466: 'VOL_CPF_WITHHELD=P',
467: pay_sg_cpfline_balances.get_balance_value( 'NEW',
468: paa.assignment_id,
469: nvl(pai.action_information1,pai.source_id),
470: pai.action_information22,
471: paa.assignment_action_id,

Line 479: pay_sg_cpfline_balances.get_balance_value( 'NEW',

475: ppa.payroll_action_id,
476: pai.action_information21
477: ) vol_cpf_withheld,
478: 'CPF_WITHHELD=P',
479: pay_sg_cpfline_balances.get_balance_value( 'NEW',
480: paa.assignment_id,
481: nvl(pai.action_information1,pai.source_id),
482: pai.action_information22,
483: paa.assignment_action_id,

Line 491: pay_sg_cpfline_balances.get_balance_value( 'NEW',

487: ppa.payroll_action_id,
488: pai.action_information21
489: ) cpf_withheld,
490: 'MBMF_WITHHELD=P',
491: pay_sg_cpfline_balances.get_balance_value( 'NEW',
492: paa.assignment_id,
493: nvl(pai.action_information1,pai.source_id),
494: pai.action_information22,
495: paa.assignment_action_id,

Line 503: pay_sg_cpfline_balances.get_balance_value( 'NEW',

499: ppa.payroll_action_id,
500: pai.action_information21
501: ) mbmf_withheld,
502: 'SINDA_WITHHELD=P',
503: pay_sg_cpfline_balances.get_balance_value( 'NEW',
504: paa.assignment_id,
505: nvl(pai.action_information1,pai.source_id),
506: pai.action_information22,
507: paa.assignment_action_id,

Line 515: pay_sg_cpfline_balances.get_balance_value( 'NEW',

511: ppa.payroll_action_id,
512: pai.action_information21
513: ) sinda_withheld,
514: 'CDAC_WITHHELD=P',
515: pay_sg_cpfline_balances.get_balance_value( 'NEW',
516: paa.assignment_id,
517: nvl(pai.action_information1,pai.source_id),
518: pai.action_information22,
519: paa.assignment_action_id,

Line 527: pay_sg_cpfline_balances.get_balance_value( 'NEW',

523: ppa.payroll_action_id,
524: pai.action_information21
525: ) cdac_withheld,
526: 'ECF_WITHHELD=P',
527: pay_sg_cpfline_balances.get_balance_value( 'NEW',
528: paa.assignment_id,
529: nvl(pai.action_information1,pai.source_id),
530: pai.action_information22,
531: paa.assignment_action_id,

Line 539: pay_sg_cpfline_balances.get_balance_value( 'NEW',

535: ppa.payroll_action_id,
536: pai.action_information21
537: ) ecf_withheld,
538: 'CPF_ORD_ELIG_COMP=P',
539: pay_sg_cpfline_balances.get_balance_value( 'NEW',
540: paa.assignment_id,
541: nvl(pai.action_information1,pai.source_id),
542: pai.action_information22,
543: paa.assignment_action_id,

Line 551: pay_sg_cpfline_balances.get_balance_value( 'NEW',

547: ppa.payroll_action_id,
548: pai.action_information21
549: ) cpf_ord_elig_comp,
550: 'CPF_ADD_ELIG_COMP=P',
551: pay_sg_cpfline_balances.get_balance_value( 'NEW',
552: paa.assignment_id,
553: nvl(pai.action_information1,pai.source_id),
554: pai.action_information22,
555: paa.assignment_action_id,

Line 563: pay_sg_cpfline_balances.get_balance_value( 'NEW',

559: ppa.payroll_action_id,
560: pai.action_information21
561: ) cpf_add_elig_comp ,
562: 'LEGAL_NAME=P',
563: pay_sg_cpfline_balances.get_balance_value( 'NEW',
564: paa.assignment_id,
565: nvl(pai.action_information1,pai.source_id),
566: pai.action_information22,
567: paa.assignment_action_id,

Line 575: pay_sg_cpfline_balances.get_balance_value( 'NEW',

571: ppa.payroll_action_id,
572: pai.action_information21
573: ) legal_name,
574: 'EMPLOYEE_NUMBER=P',
575: pay_sg_cpfline_balances.get_balance_value( 'NEW',
576: paa.assignment_id,
577: nvl(pai.action_information1,pai.source_id),
578: pai.action_information22,
579: paa.assignment_action_id,

Line 587: pay_sg_cpfline_balances.get_balance_value( 'NEW',

583: ppa.payroll_action_id,
584: pai.action_information21
585: ) employee_number,
586: 'EMP_TERMINATION_DATE=P',
587: pay_sg_cpfline_balances.get_balance_value( 'NEW',
588: paa.assignment_id,
589: nvl(pai.action_information1,pai.source_id),
590: pai.action_information22,
591: paa.assignment_action_id,