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 36: pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID') business_group_id,

32: -- Bug#3501950 - Added CPF_Interest and FWL_Interest parameters
33: --------------------------------------------------------------------------
34: cursor company_identification is
35: select 'BUSINESS_GROUP_ID=C',
36: pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID') business_group_id,
37: 'TAX_UNIT_ID=C',
38: pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID') tax_unit_id,
39: 'DOCUMENT_DATE=P',
40: to_char(sysdate,'YYYYMMDD') document_date,

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

34: cursor company_identification is
35: select 'BUSINESS_GROUP_ID=C',
36: pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID') business_group_id,
37: 'TAX_UNIT_ID=C',
38: pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID') tax_unit_id,
39: 'DOCUMENT_DATE=P',
40: to_char(sysdate,'YYYYMMDD') document_date,
41: 'LEGAL_ENTITY=P',
42: hou.name legal_entity,

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

40: to_char(sysdate,'YYYYMMDD') document_date,
41: 'LEGAL_ENTITY=P',
42: hou.name legal_entity,
43: 'MONTH=P',
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
98: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')
99: and hou.organization_id = hoi1.organization_id(+)
100: and hou.organization_id = hoi2.organization_id
101: and hoi1.org_information_context = 'SG_LEGAL_ENTITY'
102: and hoi2.org_information_context = 'CLASS'

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

153: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
154: from pay_payroll_actions ppa,
155: pay_assignment_actions paa,
156: pay_action_information pai
157: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
158: and ppa.payroll_action_id = paa.payroll_action_id
159: and paa.assignment_action_id = pai.action_context_id
160: and pai.action_information_category = 'SG CPF DETAILS'
161: and pai.action_context_type = 'AAC'

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

341: ) emp_termination_date
342: from pay_payroll_actions ppa,
343: pay_assignment_actions paa,
344: pay_action_information pai
345: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
346: and ppa.payroll_action_id = paa.payroll_action_id
347: and paa.assignment_action_id = pai.action_context_id
348: and pai.action_information_category = 'SG CPF DETAILS'
349: and pai.action_context_type = 'AAC'

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

409: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
410: from pay_payroll_actions ppa,
411: pay_assignment_actions paa,
412: pay_action_information pai
413: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
414: and ppa.payroll_action_id = paa.payroll_action_id
415: and paa.assignment_action_id = pai.action_context_id
416: and pai.action_information_category = 'SG CPF DETAILS'
417: and pai.action_context_type = 'AAC'

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

597: ) emp_termination_date
598: from pay_payroll_actions ppa,
599: pay_assignment_actions paa,
600: pay_action_information pai
601: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
602: and ppa.payroll_action_id = paa.payroll_action_id
603: and paa.assignment_action_id = pai.action_context_id
604: and pai.action_information_category = 'SG CPF DETAILS'
605: and pai.action_context_type = 'AAC'

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

635: from pay_payroll_actions ppa,
636: pay_assignment_actions paa,
637: pay_action_information pai,
638: hr_lookups hl
639: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
640: and ppa.payroll_action_id = paa.payroll_action_id
641: and paa.assignment_action_id = pai.action_context_id
642: and pai.action_information_category = 'SG CPF DETAILS'
643: and pai.action_context_type = 'AAC'