APPS.PAY_IN_EOY_ER_RETURNS dependencies on PAY_MAGTAPE_GENERIC

Line 150: , pay_magtape_generic.get_parameter_value('UPLOAD_TYPE_PARAM')

146:
147: /* FILE HEADER RECORD */
148: CURSOR c_f24_file_header IS
149: SELECT DISTINCT 'UPLOAD_TYPE=P'
150: , pay_magtape_generic.get_parameter_value('UPLOAD_TYPE_PARAM')
151: ,'TAN_OF_DED=P'
152: , LPAD(NVL(pai.action_information4, ' '),10,' ')
153: , 'MAX_ACTION_CONTEXT_ID=P'
154: , pai.action_context_id

Line 161: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

157: FROM pay_action_information pai
158: , pay_payroll_actions ppa
159: WHERE pai.action_information_category = 'IN_EOY_ORG'
160: AND pai.action_context_type = 'PA'
161: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
162: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
163: AND ppa.action_type='X'
164: AND ppa.action_status = 'C'
165: AND ppa.report_type='IN_EOY_ARCHIVE'

Line 162: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

158: , pay_payroll_actions ppa
159: WHERE pai.action_information_category = 'IN_EOY_ORG'
160: AND pai.action_context_type = 'PA'
161: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
162: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
163: AND ppa.action_type='X'
164: AND ppa.action_status = 'C'
165: AND ppa.report_type='IN_EOY_ARCHIVE'
166: AND ppa.report_qualifier = 'IN'

Line 170: WHERE action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

166: AND ppa.report_qualifier = 'IN'
167: AND ppa.payroll_action_id = pai.action_context_id
168: AND pai.action_context_id = ( SELECT MAX(action_context_id)
169: FROM pay_action_information
170: WHERE action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
171: AND action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
172: AND action_context_type = 'PA'
173: AND action_information_category = 'IN_EOY_ORG');
174:

Line 171: AND action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

167: AND ppa.payroll_action_id = pai.action_context_id
168: AND pai.action_context_id = ( SELECT MAX(action_context_id)
169: FROM pay_action_information
170: WHERE action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
171: AND action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
172: AND action_context_type = 'PA'
173: AND action_information_category = 'IN_EOY_ORG');
174:
175: /*BATCH HEADER RECORD*/

Line 178: , pay_in_eoy_er_returns.challan_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))

174:
175: /*BATCH HEADER RECORD*/
176: CURSOR c_f24_batch_header IS
177: SELECT 'TOT_CHALLAN_REC=P'
178: , pay_in_eoy_er_returns.challan_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
179: , 'TOT_DEDUCTEE_REC=P'
180: , pay_in_eoy_er_returns.deductee_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
181: , 'TOT_PERQ_REC=P'
182: , pay_in_eoy_er_returns.perq_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))

Line 180: , pay_in_eoy_er_returns.deductee_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))

176: CURSOR c_f24_batch_header IS
177: SELECT 'TOT_CHALLAN_REC=P'
178: , pay_in_eoy_er_returns.challan_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
179: , 'TOT_DEDUCTEE_REC=P'
180: , pay_in_eoy_er_returns.deductee_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
181: , 'TOT_PERQ_REC=P'
182: , pay_in_eoy_er_returns.perq_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
183: , 'TAN_OF_DED=P'
184: , LPAD(NVL(pai.action_information4,' '),10, ' ')

Line 182: , pay_in_eoy_er_returns.perq_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))

178: , pay_in_eoy_er_returns.challan_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
179: , 'TOT_DEDUCTEE_REC=P'
180: , pay_in_eoy_er_returns.deductee_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
181: , 'TOT_PERQ_REC=P'
182: , pay_in_eoy_er_returns.perq_rec_count(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
183: , 'TAN_OF_DED=P'
184: , LPAD(NVL(pai.action_information4,' '),10, ' ')
185: , 'PAN_OF_TAN=P'
186: , LPAD(NVL(pai.action_information2,' '),10,' ')

Line 188: , SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),8,2)

184: , LPAD(NVL(pai.action_information4,' '),10, ' ')
185: , 'PAN_OF_TAN=P'
186: , LPAD(NVL(pai.action_information2,' '),10,' ')
187: , 'ASSESS_YEAR=P'
188: , SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),8,2)
189: , 'FIN_YEAR=P'
190: , SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)-1||LPAD (SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),8,2)-1,2,'0')
191: , 'LEGAL_NAME=P'
192: , NVL(pai.action_information8,' ')

Line 190: , SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)-1||LPAD (SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),8,2)-1,2,'0')

186: , LPAD(NVL(pai.action_information2,' '),10,' ')
187: , 'ASSESS_YEAR=P'
188: , SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),8,2)
189: , 'FIN_YEAR=P'
190: , SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)-1||LPAD (SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),8,2)-1,2,'0')
191: , 'LEGAL_NAME=P'
192: , NVL(pai.action_information8,' ')
193: , 'EMPLOYER_CLASS=P'
194: , pay_in_eoy_er_returns.get_emplr_class(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'))

Line 194: , pay_in_eoy_er_returns.get_emplr_class(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'))

190: , SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)-1||LPAD (SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),8,2)-1,2,'0')
191: , 'LEGAL_NAME=P'
192: , NVL(pai.action_information8,' ')
193: , 'EMPLOYER_CLASS=P'
194: , pay_in_eoy_er_returns.get_emplr_class(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'))
195: , 'EMPLOYER_ADD1=P'
196: , SUBSTR(pay_in_eoy_er_returns.get_location_details(pai.action_information7),1,75)
197: , 'EMPLOYER_ADD2=P'
198: , SUBSTR(pay_in_eoy_er_returns.get_location_details(pai.action_information7),76)

Line 200: , pay_magtape_generic.get_parameter_value('EMP_ADD_CHG')

196: , SUBSTR(pay_in_eoy_er_returns.get_location_details(pai.action_information7),1,75)
197: , 'EMPLOYER_ADD2=P'
198: , SUBSTR(pay_in_eoy_er_returns.get_location_details(pai.action_information7),76)
199: , 'EMP_ADD_CHG=P'
200: , pay_magtape_generic.get_parameter_value('EMP_ADD_CHG')
201: , 'REP_NAME=P'
202: , NVL(pai.action_information11,' ')
203: , 'REP_DESIG=P'
204: , NVL(pai.action_information13,' ')

Line 210: , pay_magtape_generic.get_parameter_value('REP_ADD_CHG')

206: , SUBSTR(pay_in_eoy_er_returns.get_location_details(pai.action_information16),1,75)
207: , 'REP_ADD2=P'
208: , SUBSTR(pay_in_eoy_er_returns.get_location_details(pai.action_information16),76)
209: , 'REP_ADD_CHG=P'
210: , pay_magtape_generic.get_parameter_value('REP_ADD_CHG')
211: , 'GROSS_TDS_CHALLAN=P'
212: , pay_in_eoy_er_returns.gross_tot_tds_challan(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
213: , 'GROSS_TDS_DED=P'
214: , pay_in_eoy_er_returns.gross_tot_tds_deductee(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))

Line 212: , pay_in_eoy_er_returns.gross_tot_tds_challan(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))

208: , SUBSTR(pay_in_eoy_er_returns.get_location_details(pai.action_information16),76)
209: , 'REP_ADD_CHG=P'
210: , pay_magtape_generic.get_parameter_value('REP_ADD_CHG')
211: , 'GROSS_TDS_CHALLAN=P'
212: , pay_in_eoy_er_returns.gross_tot_tds_challan(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
213: , 'GROSS_TDS_DED=P'
214: , pay_in_eoy_er_returns.gross_tot_tds_deductee(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
215: , 'TAN_ACK_NUM=P'
216: , NVL(pai.action_information5,'00000000000000')

Line 214: , pay_in_eoy_er_returns.gross_tot_tds_deductee(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))

210: , pay_magtape_generic.get_parameter_value('REP_ADD_CHG')
211: , 'GROSS_TDS_CHALLAN=P'
212: , pay_in_eoy_er_returns.gross_tot_tds_challan(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
213: , 'GROSS_TDS_DED=P'
214: , pay_in_eoy_er_returns.gross_tot_tds_deductee(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
215: , 'TAN_ACK_NUM=P'
216: , NVL(pai.action_information5,'00000000000000')
217: , 'PRN=P'
218: , pay_magtape_generic.get_parameter_value('PRN')

Line 218: , pay_magtape_generic.get_parameter_value('PRN')

214: , pay_in_eoy_er_returns.gross_tot_tds_deductee(pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM'),pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'))
215: , 'TAN_ACK_NUM=P'
216: , NVL(pai.action_information5,'00000000000000')
217: , 'PRN=P'
218: , pay_magtape_generic.get_parameter_value('PRN')
219: FROM pay_action_information pai
220: WHERE pai.action_information_category = 'IN_EOY_ORG'
221: AND pai.action_context_type = 'PA'
222: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

Line 222: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

218: , pay_magtape_generic.get_parameter_value('PRN')
219: FROM pay_action_information pai
220: WHERE pai.action_information_category = 'IN_EOY_ORG'
221: AND pai.action_context_type = 'PA'
222: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
223: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
224: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
225: AND ROWNUM = 1;
226:

Line 223: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

219: FROM pay_action_information pai
220: WHERE pai.action_information_category = 'IN_EOY_ORG'
221: AND pai.action_context_type = 'PA'
222: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
223: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
224: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
225: AND ROWNUM = 1;
226:
227:

Line 224: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

220: WHERE pai.action_information_category = 'IN_EOY_ORG'
221: AND pai.action_context_type = 'PA'
222: AND pai.action_information1 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
223: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
224: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
225: AND ROWNUM = 1;
226:
227:
228: /* CHALLAN DETAIL RECORD */

Line 255: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

251: FROM hr_organization_information ch_b
252: , hr_organization_information it_ch
253: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
254: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
255: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
256: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))
257: AND it_ch.organization_id = ch_b.organization_id
258: AND TO_NUMBER(it_ch.org_information5) = ch_b.org_information_id
259: UNION

Line 256: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))

252: , hr_organization_information it_ch
253: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
254: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
255: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
256: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))
257: AND it_ch.organization_id = ch_b.organization_id
258: AND TO_NUMBER(it_ch.org_information5) = ch_b.org_information_id
259: UNION
260: SELECT 'TDS_DEP=P'

Line 288: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

284: FROM hr_organization_information ch_b
285: ,hr_organization_information it_ch
286: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
287: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
288: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
289: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))
290: AND it_ch.organization_id = ch_b.organization_id
291: AND TO_NUMBER(it_ch.org_information5) = ch_b.org_information_id
292: )

Line 289: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))

285: ,hr_organization_information it_ch
286: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
287: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
288: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
289: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))
290: AND it_ch.organization_id = ch_b.organization_id
291: AND TO_NUMBER(it_ch.org_information5) = ch_b.org_information_id
292: )
293: ORDER BY 21;

Line 360: , pay_in_eoy_er_returns.get_tde_remarks(action_information13,pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),action_information18)

356: , pay_in_eoy_er_returns.get_eoy_values('IN_EOY_ALLOW','Taxable Allowances',action_context_id,source_id,2)
357: , 'TAXABLE_PERQ=P'
358: , pay_in_eoy_er_returns.get_eoy_values('IN_EOY_PERQ','Taxable Perquisites',action_context_id,source_id,2)
359: , 'REMARKS=P'
360: , pay_in_eoy_er_returns.get_tde_remarks(action_information13,pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),action_information18)
361: , 'TAXABLE_HRA=P'
362: , pay_in_eoy_er_returns.get_eoy_values('IN_EOY_ALLOW','House Rent Allowance',action_context_id,source_id,5)
363: FROM pay_action_information
364: WHERE action_information_category = 'IN_EOY_PERSON'

Line 366: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

362: , pay_in_eoy_er_returns.get_eoy_values('IN_EOY_ALLOW','House Rent Allowance',action_context_id,source_id,5)
363: FROM pay_action_information
364: WHERE action_information_category = 'IN_EOY_PERSON'
365: AND action_context_type = 'AAP'
366: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
367: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
368: AND action_context_id IN ( SELECT MAX(action_context_id)
369: FROM pay_action_information
370: ,pay_assignment_actions

Line 367: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

363: FROM pay_action_information
364: WHERE action_information_category = 'IN_EOY_PERSON'
365: AND action_context_type = 'AAP'
366: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
367: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
368: AND action_context_id IN ( SELECT MAX(action_context_id)
369: FROM pay_action_information
370: ,pay_assignment_actions
371: WHERE action_information_category = 'IN_EOY_PERSON'

Line 373: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

369: FROM pay_action_information
370: ,pay_assignment_actions
371: WHERE action_information_category = 'IN_EOY_PERSON'
372: AND action_context_type = 'AAP'
373: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
374: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
375: AND source_id = assignment_action_id
376: GROUP BY action_information1,action_information17 )
377: ORDER BY LENGTH(action_information1),action_information1,source_id;

Line 374: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

370: ,pay_assignment_actions
371: WHERE action_information_category = 'IN_EOY_PERSON'
372: AND action_context_type = 'AAP'
373: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
374: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
375: AND source_id = assignment_action_id
376: GROUP BY action_information1,action_information17 )
377: ORDER BY LENGTH(action_information1),action_information1,source_id;
378:

Line 425: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

421: , pay_in_eoy_er_returns.get_eoy_values('IN_EOY_ASG_SAL','Excess Interest Amount',action_context_id,source_id,2)
422: FROM pay_action_information
423: WHERE action_information_category = 'IN_EOY_PERSON'
424: AND action_context_type = 'AAP'
425: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
426: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
427: AND action_context_id IN ( SELECT MAX(action_context_id)
428: FROM pay_action_information
429: ,pay_assignment_actions

Line 426: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

422: FROM pay_action_information
423: WHERE action_information_category = 'IN_EOY_PERSON'
424: AND action_context_type = 'AAP'
425: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
426: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
427: AND action_context_id IN ( SELECT MAX(action_context_id)
428: FROM pay_action_information
429: ,pay_assignment_actions
430: WHERE action_information_category = 'IN_EOY_PERSON'

Line 432: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

428: FROM pay_action_information
429: ,pay_assignment_actions
430: WHERE action_information_category = 'IN_EOY_PERSON'
431: AND action_context_type = 'AAP'
432: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
433: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
434: AND source_id = assignment_action_id
435: GROUP BY action_information1,action_information17 )
436: ORDER BY LENGTH(action_information1),action_information1,source_id;

Line 433: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

429: ,pay_assignment_actions
430: WHERE action_information_category = 'IN_EOY_PERSON'
431: AND action_context_type = 'AAP'
432: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
433: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
434: AND source_id = assignment_action_id
435: GROUP BY action_information1,action_information17 )
436: ORDER BY LENGTH(action_information1),action_information1,source_id;
437: