APPS.PAY_IN_EOY_ER_RETURNS dependencies on PAY_ACTION_INFORMATION

Line 157: FROM pay_action_information pai

153: , 'MAX_ACTION_CONTEXT_ID=P'
154: , pai.action_context_id
155: , 'SUBMIT_DATE=P'
156: , TO_CHAR (SYSDATE,'DDMMYYYY')
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')

Line 169: FROM pay_action_information

165: AND ppa.report_type='IN_EOY_ARCHIVE'
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');

Line 219: FROM pay_action_information pai

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')
223: AND pai.action_information3 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

Line 363: FROM pay_action_information

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'
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')

Line 369: FROM pay_action_information

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'
372: AND action_context_type = 'AAP'
373: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')

Line 422: FROM pay_action_information

418: , 'PF_EXCESS_AMT=P'
419: , pay_in_eoy_er_returns.get_eoy_values('IN_EOY_ASG_SAL','Excess PF Amount',action_context_id,source_id,2)
420: , 'PF_EXCESS_INT=P'
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')

Line 428: FROM pay_action_information

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'
431: AND action_context_type = 'AAP'
432: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')