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_MAGTAPE_GENERIC

Line 44: pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID') business_group_id,

40: -- Bug#3501950 - Added CPF_Interest and FWL_Interest parameters
41: --------------------------------------------------------------------------
42: cursor company_identification is
43: select 'BUSINESS_GROUP_ID=C',
44: pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID') business_group_id,
45: 'TAX_UNIT_ID=C',
46: pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID') tax_unit_id,
47: 'DOCUMENT_DATE=P',
48: to_char(sysdate,'YYYYMMDD') document_date,

Line 46: pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID') tax_unit_id,

42: cursor company_identification is
43: select 'BUSINESS_GROUP_ID=C',
44: pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID') business_group_id,
45: 'TAX_UNIT_ID=C',
46: pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID') tax_unit_id,
47: 'DOCUMENT_DATE=P',
48: to_char(sysdate,'YYYYMMDD') document_date,
49: 'LEGAL_ENTITY=P',
50: hou.name legal_entity,

Line 52: replace(pay_magtape_generic.get_parameter_value('CSN'),'#',' ') csn,

48: to_char(sysdate,'YYYYMMDD') document_date,
49: 'LEGAL_ENTITY=P',
50: hou.name legal_entity,
51: 'CSN=P',
52: replace(pay_magtape_generic.get_parameter_value('CSN'),'#',' ') csn,
53: 'MONTH=P',
54: pay_magtape_generic.get_parameter_value('MONTH') month,
55: 'ADVICE_CODE=P',
56: '01' advice_code,

Line 54: pay_magtape_generic.get_parameter_value('MONTH') month,

50: hou.name legal_entity,
51: 'CSN=P',
52: replace(pay_magtape_generic.get_parameter_value('CSN'),'#',' ') csn,
53: 'MONTH=P',
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

Line 59: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV1')) av1_amount,

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,
63: 'AV4_AMOUNT=P',

Line 62: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV3')) av3_amount,

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,
66: 'AV5_AMOUNT=P',

Line 65: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV4')) av4_amount,

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,
69: 'AV7_AMOUNT=P',

Line 68: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV5')) av5_amount,

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,
72: 'AVA_AMOUNT=P',

Line 71: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AV7')) av7_amount,

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,
75: 'AVE_AMOUNT=P',

Line 74: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVA')) ava_amount,

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,
78: 'AVG_AMOUNT=P',

Line 77: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVE')) ave_amount,

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,
81: 'MUS_COUNT=P',

Line 80: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'AVG')) avg_amount,

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,
84: 'SHA_COUNT=P',

Line 83: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'MUS')) mus_count,

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,
87: 'SIN_COUNT=P',

Line 86: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SHA')) sha_count,

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,
90: 'CDA_COUNT=P',

Line 89: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'SIN')) sin_count,

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,
93: 'ECF_COUNT=P',

Line 92: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'CDA')) cda_count,

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,
96: 'TOTAL_CONTRIBUTION=P',

Line 95: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'ECF')) ecf_count,

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,
99: 'CPF_INTEREST=P',

Line 98: ( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'), 'TOT')) total_contribution,

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,
102: 'FWL_INTEREST=P',

Line 101: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,

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
105: from hr_organization_units hou,

Line 104: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest

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
108: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')

Line 108: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')

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
108: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')
109: and hou.organization_id = hoi1.organization_id(+)
110: and hou.organization_id = hoi2.organization_id
111: and hoi1.org_information_context = 'SG_LEGAL_ENTITY'
112: and hoi2.org_information_context = 'CLASS'

Line 167: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

163: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
164: from pay_payroll_actions ppa,
165: pay_assignment_actions paa,
166: pay_action_information pai
167: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
168: and ppa.payroll_action_id = paa.payroll_action_id
169: and paa.assignment_action_id = pai.action_context_id
170: and pai.action_information_category = 'SG CPF DETAILS'
171: and pai.action_context_type = 'AAC'

Line 174: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')

170: and pai.action_information_category = 'SG CPF DETAILS'
171: and pai.action_context_type = 'AAC'
172: and pai.action_information2 = 'EE'
173: and (
174: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')
175: and (pai.action_information25 is null
176: or (pai.action_information25 is not null
177: and (to_number(pai.action_information7)<>0
178: or to_number(pai.action_information6)<>0)))

Line 180: pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))

176: or (pai.action_information25 is not null
177: and (to_number(pai.action_information7)<>0
178: or to_number(pai.action_information6)<>0)))
179: or
180: pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
181: and not exists ( select 1
182: from pay_action_information pai_dup,
183: pay_assignment_actions paa_dup
184: where pai.action_information_category = pai_dup.action_information_category

Line 363: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

359: ) emp_termination_date
360: from pay_payroll_actions ppa,
361: pay_assignment_actions paa,
362: pay_action_information pai
363: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
364: and ppa.payroll_action_id = paa.payroll_action_id
365: and paa.assignment_action_id = pai.action_context_id
366: and pai.action_information_category = 'SG CPF DETAILS'
367: and pai.action_context_type = 'AAC'

Line 370: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')

366: and pai.action_information_category = 'SG CPF DETAILS'
367: and pai.action_context_type = 'AAC'
368: and pai.action_information2 = 'EE'
369: and (
370: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')
371: and (pai.action_information25 is null
372: or (pai.action_information25 is not null
373: and (to_number(pai.action_information7)<>0
374: or to_number(pai.action_information6)<>0)))

Line 375: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))

371: and (pai.action_information25 is null
372: or (pai.action_information25 is not null
373: and (to_number(pai.action_information7)<>0
374: or to_number(pai.action_information6)<>0)))
375: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
376: and exists ( select 1
377: from pay_action_information pai_dup,
378: pay_assignment_actions paa_dup
379: where pai.action_information_category = pai_dup.action_information_category

Line 438: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

434: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
435: from pay_payroll_actions ppa,
436: pay_assignment_actions paa,
437: pay_action_information pai
438: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
439: and ppa.payroll_action_id = paa.payroll_action_id
440: and paa.assignment_action_id = pai.action_context_id
441: and pai.action_information_category = 'SG CPF DETAILS'
442: and pai.action_context_type = 'AAC'

Line 445: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')

441: and pai.action_information_category = 'SG CPF DETAILS'
442: and pai.action_context_type = 'AAC'
443: and pai.action_information2 = 'NEW'
444: and (
445: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')
446: and (pai.action_information25 is null
447: or (pai.action_information25 is not null
448: and (to_number(pai.action_information7)<>0
449: or to_number(pai.action_information6)<>0)))

Line 450: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))

446: and (pai.action_information25 is null
447: or (pai.action_information25 is not null
448: and (to_number(pai.action_information7)<>0
449: or to_number(pai.action_information6)<>0)))
450: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
451: and not exists ( select 1
452: from pay_action_information pai_dup,
453: pay_assignment_actions paa_dup
454: where pai.action_information_category = pai_dup.action_information_category

Line 633: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

629: ) emp_termination_date
630: from pay_payroll_actions ppa,
631: pay_assignment_actions paa,
632: pay_action_information pai
633: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
634: and ppa.payroll_action_id = paa.payroll_action_id
635: and paa.assignment_action_id = pai.action_context_id
636: and pai.action_information_category = 'SG CPF DETAILS'
637: and pai.action_context_type = 'AAC'

Line 640: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')

636: and pai.action_information_category = 'SG CPF DETAILS'
637: and pai.action_context_type = 'AAC'
638: and pai.action_information2 = 'NEW'
639: and (
640: pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN')
641: and (pai.action_information25 is null
642: or (pai.action_information25 is not null
643: and (to_number(pai.action_information7)<>0
644: or to_number(pai.action_information6)<>0)))

Line 645: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))

641: and (pai.action_information25 is null
642: or (pai.action_information25 is not null
643: and (to_number(pai.action_information7)<>0
644: or to_number(pai.action_information6)<>0)))
645: or pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN'))
646: and exists ( select 1
647: from pay_action_information pai_dup,
648: pay_assignment_actions paa_dup
649: where pai.action_information_category = pai_dup.action_information_category

Line 678: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

674: from pay_payroll_actions ppa,
675: pay_assignment_actions paa,
676: pay_action_information pai,
677: hr_lookups hl
678: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
679: and ppa.payroll_action_id = paa.payroll_action_id
680: and paa.assignment_action_id = pai.action_context_id
681: and pai.action_information_category = 'SG CPF DETAILS'
682: and pai.action_context_type = 'AAC'

Line 692: (pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN') and (pai.action_information25 is null

688: 'ECF Fund', pai.action_information11,
689: 'FWL', pai.action_information16,
690: 'SHARE Program Donations', pai.action_information14) <> 0
691: and (
692: (pai.action_information24 = pay_magtape_generic.get_parameter_value('CSN') and (pai.action_information25 is null
693: or (pai.action_information25 is not null
694: and (pai.action_information6 <> 0
695: or pai.action_information7 <> 0))))
696: or

Line 697: (pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN')))

693: or (pai.action_information25 is not null
694: and (pai.action_information6 <> 0
695: or pai.action_information7 <> 0))))
696: or
697: (pai.action_information25 = pay_magtape_generic.get_parameter_value('CSN')))
698: group by hl.meaning,hl.lookup_code, pai.action_information17, nvl(pai.action_information1,pai.source_id)
699: order by hl.lookup_code, pai.action_information17;
700:
701: