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_KR_YEA_MAGTAPE_PKG dependencies on PAY_KR_YEA_MAGTAPE_FUN_PKG

Line 64: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),

60:
61: cursor csr_b is
62: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
63: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
64: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
65: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
66: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
67: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),

Line 65: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),

61: cursor csr_b is
62: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
63: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
64: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
65: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
66: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
67: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
69: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),

Line 66: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),

62: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
63: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
64: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
65: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
66: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
67: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
69: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
70: 'REP_PERIOD_CODE=P', g_rep_period_code

Line 67: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),

63: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
64: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
65: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
66: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
67: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
69: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
70: 'REP_PERIOD_CODE=P', g_rep_period_code
71: from hr_organization_information hoi3,

Line 68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),

64: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
65: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
66: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
67: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
69: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
70: 'REP_PERIOD_CODE=P', g_rep_period_code
71: from hr_organization_information hoi3,
72: hr_organization_information hoi2,

Line 69: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),

65: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
66: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
67: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
68: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
69: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS'),
70: 'REP_PERIOD_CODE=P', g_rep_period_code
71: from hr_organization_information hoi3,
72: hr_organization_information hoi2,
73: hr_all_organization_units_tl bptl2,

Line 138: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),

134: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
135: 'FULL_NAME=P', pp.last_name || pp.first_name,
136: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),
137: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),
138: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),
139: 'COUNTRY_CODE=P', ft.territory_code,
140: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) , -- 4738717
141: /* Bug 10184055 */
142: 'NATIONALITY_CODE=P', pp.NATIONALITY,

Line 140: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) , -- 4738717

136: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),
137: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),
138: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),
139: 'COUNTRY_CODE=P', ft.territory_code,
140: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) , -- 4738717
141: /* Bug 10184055 */
142: 'NATIONALITY_CODE=P', pp.NATIONALITY,
143: 'REPORT_CATEGORY=P', ppa.report_category
144: from per_people_f pp,

Line 175: and ((g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, g_payroll_action_id, g_target_year) = 'Y')) -- Bug 4726974

171: and paa.payroll_action_id = ppa.payroll_action_id
172: and ppa.payroll_action_id = ppa.payroll_action_id
173: -- Bug 3248513
174: and ((g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(g_assignment_set_id, paa.assignment_id) = 'Y'))
175: and ((g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, g_payroll_action_id, g_target_year) = 'Y')) -- Bug 4726974
176: --
177: and paa.tax_unit_id = bp.organization_id
178: and paa.action_status = 'C'
179: and pa.assignment_id = paa.assignment_id

Line 209: 'PREV_NTAX_G01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'G01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

205: 'PREV_TAX_BRK_FDATE=P', nvl(aei.aei_information24,fnd_date.date_to_canonical(to_date('1900/01/01','YYYY/MM/DD'))),
206: 'PREV_TAX_BRK_TDATE=P', nvl(aei.aei_information25,fnd_date.date_to_canonical(to_date('1900/01/01','YYYY/MM/DD'))),
207: -- End of Bug 9386289
208: 'PREV_ESOP_EARN=P', nvl(aei.aei_information26, 0),
209: 'PREV_NTAX_G01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'G01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
210: 'PREV_NTAX_H01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 210: 'PREV_NTAX_H01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

206: 'PREV_TAX_BRK_TDATE=P', nvl(aei.aei_information25,fnd_date.date_to_canonical(to_date('1900/01/01','YYYY/MM/DD'))),
207: -- End of Bug 9386289
208: 'PREV_ESOP_EARN=P', nvl(aei.aei_information26, 0),
209: 'PREV_NTAX_G01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'G01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
210: 'PREV_NTAX_H01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

207: -- End of Bug 9386289
208: 'PREV_ESOP_EARN=P', nvl(aei.aei_information26, 0),
209: 'PREV_NTAX_G01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'G01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
210: 'PREV_NTAX_H01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

208: 'PREV_ESOP_EARN=P', nvl(aei.aei_information26, 0),
209: 'PREV_NTAX_G01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'G01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
210: 'PREV_NTAX_H01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

209: 'PREV_NTAX_G01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'G01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
210: 'PREV_NTAX_H01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
217: --Start of Bug 15911822 2012 YEA EFile Updates

Line 214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

210: 'PREV_NTAX_H01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
217: --Start of Bug 15911822 2012 YEA EFile Updates
218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

211: 'PREV_NTAX_H05=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H05',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
217: --Start of Bug 15911822 2012 YEA EFile Updates
218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

212: 'PREV_NTAX_H06=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H06',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
213: 'PREV_NTAX_H07=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H07',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
217: --Start of Bug 15911822 2012 YEA EFile Updates
218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
220: --End of Bug 15911822

Line 218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

214: 'PREV_NTAX_H08=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H08',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
217: --Start of Bug 15911822 2012 YEA EFile Updates
218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
220: --End of Bug 15911822
221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

215: 'PREV_NTAX_H09=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H09',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
216: 'PREV_NTAX_H10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
217: --Start of Bug 15911822 2012 YEA EFile Updates
218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
220: --End of Bug 15911822
221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

217: --Start of Bug 15911822 2012 YEA EFile Updates
218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
220: --End of Bug 15911822
221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

218: 'PREV_NTAX_H14=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H14',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
220: --End of Bug 15911822
221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

219: 'PREV_NTAX_H15=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H15',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
220: --End of Bug 15911822
221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
227: 'PREV_NTAX_M02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

220: --End of Bug 15911822
221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
227: 'PREV_NTAX_M02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
228: 'PREV_NTAX_M03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

221: 'PREV_NTAX_H11=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H11',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
227: 'PREV_NTAX_M02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
228: 'PREV_NTAX_M03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
229: 'PREV_NTAX_O01=P', nvl(aei.aei_information8, 0),

Line 226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

222: 'PREV_NTAX_H12=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H12',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
227: 'PREV_NTAX_M02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
228: 'PREV_NTAX_M03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
229: 'PREV_NTAX_O01=P', nvl(aei.aei_information8, 0),
230: 'PREV_NTAX_Q01=P', nvl(aei.aei_information21, 0),

Line 227: 'PREV_NTAX_M02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

223: 'PREV_NTAX_H13=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'H13',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
227: 'PREV_NTAX_M02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
228: 'PREV_NTAX_M03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
229: 'PREV_NTAX_O01=P', nvl(aei.aei_information8, 0),
230: 'PREV_NTAX_Q01=P', nvl(aei.aei_information21, 0),
231: -- Bug : 13484283 : 2011 YEA Efile Updates.

Line 228: 'PREV_NTAX_M03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

224: 'PREV_NTAX_I01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'I01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
225: 'PREV_NTAX_K01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'K01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
226: 'PREV_NTAX_M01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
227: 'PREV_NTAX_M02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
228: 'PREV_NTAX_M03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
229: 'PREV_NTAX_O01=P', nvl(aei.aei_information8, 0),
230: 'PREV_NTAX_Q01=P', nvl(aei.aei_information21, 0),
231: -- Bug : 13484283 : 2011 YEA Efile Updates.
232: 'PREV_NTAX_R10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'R10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 232: 'PREV_NTAX_R10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'R10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

228: 'PREV_NTAX_M03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'M03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
229: 'PREV_NTAX_O01=P', nvl(aei.aei_information8, 0),
230: 'PREV_NTAX_Q01=P', nvl(aei.aei_information21, 0),
231: -- Bug : 13484283 : 2011 YEA Efile Updates.
232: 'PREV_NTAX_R10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'R10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
233: 'PREV_NTAX_S01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'S01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
234: 'PREV_NTAX_T01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
235: 'PREV_NTAX_X01=P', nvl(aei.aei_information22, 0),
236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 233: 'PREV_NTAX_S01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'S01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

229: 'PREV_NTAX_O01=P', nvl(aei.aei_information8, 0),
230: 'PREV_NTAX_Q01=P', nvl(aei.aei_information21, 0),
231: -- Bug : 13484283 : 2011 YEA Efile Updates.
232: 'PREV_NTAX_R10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'R10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
233: 'PREV_NTAX_S01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'S01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
234: 'PREV_NTAX_T01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
235: 'PREV_NTAX_X01=P', nvl(aei.aei_information22, 0),
236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 234: 'PREV_NTAX_T01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

230: 'PREV_NTAX_Q01=P', nvl(aei.aei_information21, 0),
231: -- Bug : 13484283 : 2011 YEA Efile Updates.
232: 'PREV_NTAX_R10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'R10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
233: 'PREV_NTAX_S01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'S01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
234: 'PREV_NTAX_T01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
235: 'PREV_NTAX_X01=P', nvl(aei.aei_information22, 0),
236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

232: 'PREV_NTAX_R10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'R10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
233: 'PREV_NTAX_S01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'S01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
234: 'PREV_NTAX_T01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
235: 'PREV_NTAX_X01=P', nvl(aei.aei_information22, 0),
236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

233: 'PREV_NTAX_S01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'S01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
234: 'PREV_NTAX_T01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
235: 'PREV_NTAX_X01=P', nvl(aei.aei_information22, 0),
236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

234: 'PREV_NTAX_T01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
235: 'PREV_NTAX_X01=P', nvl(aei.aei_information22, 0),
236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
242: -- Start of Bug 15911822 2012 YEA EFile Updates

Line 239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

235: 'PREV_NTAX_X01=P', nvl(aei.aei_information22, 0),
236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
242: -- Start of Bug 15911822 2012 YEA EFile Updates
243: 'PREV_NTAX_T10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

236: 'PREV_NTAX_Y01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
242: -- Start of Bug 15911822 2012 YEA EFile Updates
243: 'PREV_NTAX_T10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
244: 'PREV_NTAX_T20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

Line 241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

237: 'PREV_NTAX_Y02=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y02',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
238: 'PREV_NTAX_Y03=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y03',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
242: -- Start of Bug 15911822 2012 YEA EFile Updates
243: 'PREV_NTAX_T10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
244: 'PREV_NTAX_T20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
245: -- Bug : 13484283

Line 243: 'PREV_NTAX_T10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

239: 'PREV_NTAX_Y20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
242: -- Start of Bug 15911822 2012 YEA EFile Updates
243: 'PREV_NTAX_T10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
244: 'PREV_NTAX_T20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
245: -- Bug : 13484283
246: 'PREV_NTAX_ZZ=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y22',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
247: 'PREV_ITAX=P', nvl(aei.aei_information13, 0),

Line 244: 'PREV_NTAX_T20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

240: 'PREV_NTAX_Z01=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Z01',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
241: 'PREV_NTAX_Y21=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y21',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
242: -- Start of Bug 15911822 2012 YEA EFile Updates
243: 'PREV_NTAX_T10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
244: 'PREV_NTAX_T20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
245: -- Bug : 13484283
246: 'PREV_NTAX_ZZ=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y22',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
247: 'PREV_ITAX=P', nvl(aei.aei_information13, 0),
248: 'PREV_RTAX=P', nvl(aei.aei_information14, 0),

Line 246: 'PREV_NTAX_ZZ=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y22',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),

242: -- Start of Bug 15911822 2012 YEA EFile Updates
243: 'PREV_NTAX_T10=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T10',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
244: 'PREV_NTAX_T20=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'T20',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
245: -- Bug : 13484283
246: 'PREV_NTAX_ZZ=P', pay_kr_yea_magtape_fun_pkg.prev_non_tax_values(p_assignment_id,aei.aei_information3,'Y22',fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))),
247: 'PREV_ITAX=P', nvl(aei.aei_information13, 0),
248: 'PREV_RTAX=P', nvl(aei.aei_information14, 0),
249: 'PREV_STAX=P', nvl(aei.aei_information15, 0),
250: 'PREV_EFF_DATE=P', pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE') -- Bug 9386289

Line 260: -- pay_kr_yea_magtape_fun_pkg.e_record_count also.

256: order by aei_information1, 2;
257: ------------------------------------------------------------------------
258:
259: -- Note: Any change in this cursor must be included in
260: -- pay_kr_yea_magtape_fun_pkg.e_record_count also.
261:
262: cursor csr_e( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),
263: p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))
264: ) is

Line 379: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),

375: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
376: 'ACCOUNT_NUMBER=P', aei_information4,
377: 'YEAR=P', '00' year,
378: 'CONT_AMOUNT=P', aei_information5,
379: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
380: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
381: from per_assignment_extra_info
382: where
383: information_type = 'KR_YEA_SEP_PEN_DETAILS'

Line 380: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)

376: 'ACCOUNT_NUMBER=P', aei_information4,
377: 'YEAR=P', '00' year,
378: 'CONT_AMOUNT=P', aei_information5,
379: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
380: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
381: from per_assignment_extra_info
382: where
383: information_type = 'KR_YEA_SEP_PEN_DETAILS'
384: and assignment_id = p_assignment_id

Line 386: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,

382: where
383: information_type = 'KR_YEA_SEP_PEN_DETAILS'
384: and assignment_id = p_assignment_id
385: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
386: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,
387: p_effective_date, information_type,aei_information6) > 0
388: order by to_number(aei_information6))
389: union all
390:

Line 400: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),

396: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
397: 'ACCOUNT_NUMBER=P', aei_information4,
398: 'YEAR=P', '00' year,
399: 'CONT_AMOUNT=P', aei_information5,
400: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
401: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
402: from per_assignment_extra_info
403: where
404: information_type = 'KR_YEA_PEN_SAVING_DETAILS'

Line 401: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)

397: 'ACCOUNT_NUMBER=P', aei_information4,
398: 'YEAR=P', '00' year,
399: 'CONT_AMOUNT=P', aei_information5,
400: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
401: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
402: from per_assignment_extra_info
403: where
404: information_type = 'KR_YEA_PEN_SAVING_DETAILS'
405: and assignment_id = p_assignment_id

Line 407: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,

403: where
404: information_type = 'KR_YEA_PEN_SAVING_DETAILS'
405: and assignment_id = p_assignment_id
406: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
407: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,
408: p_effective_date, information_type,aei_information6) > 0
409: order by to_number(aei_information6)
410: )
411: union all

Line 422: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),

418: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
419: 'ACCOUNT_NUMBER=P', aei_information4,
420: 'YEAR=P', '00' year,
421: 'CONT_AMOUNT=P', aei_information5,
422: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
423: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
424: from per_assignment_extra_info
425: where
426: information_type = 'KR_YEA_HOU_SAVING_DETAILS'

Line 423: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)

419: 'ACCOUNT_NUMBER=P', aei_information4,
420: 'YEAR=P', '00' year,
421: 'CONT_AMOUNT=P', aei_information5,
422: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
423: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
424: from per_assignment_extra_info
425: where
426: information_type = 'KR_YEA_HOU_SAVING_DETAILS'
427: and assignment_id = p_assignment_id

Line 429: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,

425: where
426: information_type = 'KR_YEA_HOU_SAVING_DETAILS'
427: and assignment_id = p_assignment_id
428: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
429: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,
430: p_effective_date, information_type,aei_information6) > 0
431: order by to_number(aei_information6)
432: )
433: union all

Line 444: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),

440: 'FIN_INST_NAME=P', hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',aei_information3),
441: 'ACCOUNT_NUMBER=P', aei_information4,
442: 'YEAR=P', decode(aei_information2,'1','01','2','02','3','03') year,
443: 'CONT_AMOUNT=P', aei_information5,
444: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
445: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
446: from per_assignment_extra_info
447: where
448: information_type = 'KR_YEA_LT_STOCK_SAVING_DETAILS'

Line 445: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)

441: 'ACCOUNT_NUMBER=P', aei_information4,
442: 'YEAR=P', decode(aei_information2,'1','01','2','02','3','03') year,
443: 'CONT_AMOUNT=P', aei_information5,
444: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
445: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
446: from per_assignment_extra_info
447: where
448: information_type = 'KR_YEA_LT_STOCK_SAVING_DETAILS'
449: and assignment_id = p_assignment_id

Line 451: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,

447: where
448: information_type = 'KR_YEA_LT_STOCK_SAVING_DETAILS'
449: and assignment_id = p_assignment_id
450: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
451: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,
452: p_effective_date, information_type,aei_information6) > 0
453: order by to_number(aei_information6));
454:
455: function GET_TAX_REDUCTION_DATE(p_assignment_id in number,