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_MAGTAPE_GENERIC

Line 37: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')

33: 'CORP_NUMBER=P', hoi3.org_information2,
34: 'CORP_REPR_NAME=P', hoi3.org_information6,
35: 'CORP_PHONE_NUMBER=P', loc.telephone_number_1,
36: 'B_RECORDS=P', to_char(g_b_records),
37: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
38: from hr_organization_information hoi3,
39: hr_locations_all loc,
40: hr_all_organization_units_tl corptl,
41: hr_organization_units corp,

Line 77: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923

73: hr_all_organization_units_tl bptl2,
74: hr_organization_units bp2,
75: hr_organization_information hoi1,
76: hr_organization_units bp1
77: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923
78: and hoi1.organization_id = bp1.organization_id
79: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
80: and bp2.business_group_id = bp1.business_group_id
81: --Bug 5069923

Line 82: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')

78: and hoi1.organization_id = bp1.organization_id
79: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
80: and bp2.business_group_id = bp1.business_group_id
81: --Bug 5069923
82: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
83: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
84: from PER_ORG_STRUCTURE_ELEMENTS posev
85: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
86: and exists ( select null

Line 85: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))

81: --Bug 5069923
82: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
83: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
84: from PER_ORG_STRUCTURE_ELEMENTS posev
85: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
86: and exists ( select null
87: from hr_organization_information
88: where organization_id = posev.ORGANIZATION_ID_child
89: and org_information_context = 'CLASS'

Line 92: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')))

88: where organization_id = posev.ORGANIZATION_ID_child
89: and org_information_context = 'CLASS'
90: and org_information1 = 'KR_BUSINESS_PLACE'
91: )
92: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')))
93: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
94: )
95: )
96: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')

Line 96: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')

92: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')))
93: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
94: )
95: )
96: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')
97: )
98: )
99: )
100: and hoi2.organization_id = bp2.organization_id

Line 124: cursor csr_c(p_bp_number varchar2 default pay_magtape_generic.get_parameter_value('BP_NUMBER'),p_tax_office_code varchar2 default pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')) is

120: and paa.tax_unit_id = bp2.organization_id
121: and paa.action_status = 'C')
122: order by 4;
123:
124: cursor csr_c(p_bp_number varchar2 default pay_magtape_generic.get_parameter_value('BP_NUMBER'),p_tax_office_code varchar2 default pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')) is
125: select
126: 'PAYROLL_ID=C', to_char(ppa.payroll_id),
127: 'PAYROLL_ACTION_ID=C', to_char(ppa.payroll_action_id),
128: 'ASSIGNMENT_ID=C', to_char(paa.assignment_id),

Line 193: cursor csr_d(p_assignment_id number default to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'))) is

189: and ppa.effective_date
190: between pp.effective_start_date and pp.effective_end_date
191: order by 16;
192:
193: cursor csr_d(p_assignment_id number default to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'))) is
194: select
195: 'PREV_BP_NUMBER=P', aei.aei_information3,
196: 'PREV_BP_NAME=P', aei.aei_information2,
197: 'PREV_TAXABLE_MTH=P', nvl(aei.aei_information4, 0),

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 250: 'PREV_EFF_DATE=P', pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE') -- Bug 9386289

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
251: -- End of Bug 9213683
252: from per_assignment_extra_info aei
253: where aei.assignment_id = p_assignment_id
254: and aei.information_type = 'KR_YEA_PREV_ER_INFO'

Line 262: cursor csr_e( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),

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
265: -- Bug 5654127
266: -- Bug 7661820

Line 263: p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))

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
265: -- Bug 5654127
266: -- Bug 7661820
267: select 'CONTACT_TYPE=P', '0' contact_type,

Line 366: cursor csr_f( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),

362: -- End of Bug 5872042
363: -- End of Bug 5654127
364: ------------------------------------------------------------------------
365: -- Bug 10184055
366: cursor csr_f( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),
367: p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE')),
368: p_assignment_action_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')
369: ) is
370: select * from (

Line 367: p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE')),

363: -- End of Bug 5654127
364: ------------------------------------------------------------------------
365: -- Bug 10184055
366: cursor csr_f( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),
367: p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE')),
368: p_assignment_action_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')
369: ) is
370: select * from (
371: select

Line 368: p_assignment_action_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')

364: ------------------------------------------------------------------------
365: -- Bug 10184055
366: cursor csr_f( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),
367: p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE')),
368: p_assignment_action_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')
369: ) is
370: select * from (
371: select
372: 'INFORMATION_TYPE=P', information_type,