APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_ACTION_INFORMATION

Line 255: FROM pay_action_information pai

251: , 'SUBMIT_DATE=P'
252: , TO_CHAR (SYSDATE,'DDMMYYYY')
253: , 'NAME_OF_UTILITY=P'
254: , pay_in_24q_er_returns.get_product_release
255: FROM pay_action_information pai
256: , pay_payroll_actions ppa
257: WHERE pai.action_information_category = 'IN_24Q_ORG'
258: AND pai.action_context_type = 'PA'
259: AND pai.action_information1 = g_gre_org_id

Line 267: FROM pay_action_information

263: AND ppa.report_type='IN_24Q_ARCHIVE'
264: AND ppa.report_qualifier = 'IN'
265: AND ppa.payroll_action_id = pai.action_context_id
266: AND pai.action_context_id = ( SELECT MAX(action_context_id)
267: FROM pay_action_information
268: WHERE action_information1 = g_gre_org_id
269: AND action_information3 = g_assess_year||g_quarter
270: AND action_context_type = 'PA'
271: AND action_information_category = 'IN_24Q_ORG')

Line 355: FROM pay_action_information pai

351: , 'PAO_REG_CODE=P'
352: , pai.action_information19
353: , 'DDO_REG_CODE=P'
354: , pai.action_information20
355: FROM pay_action_information pai
356: WHERE pai.action_information_category = 'IN_24Q_ORG'
357: AND pai.action_context_type = 'PA'
358: AND pai.action_information1 = g_gre_org_id
359: AND pai.action_information3 = g_assess_year||g_quarter

Line 407: FROM pay_action_information pai

403: , 'REMARKS=P'
404: , SUBSTR(pai.action_information13,1,14)||'^'
405: , 'CHALLAN_REC_INDEX=P'
406: , pai.action_information25 challan_count
407: FROM pay_action_information pai
408: WHERE action_information_category = 'IN_24Q_CHALLAN'
409: AND action_context_type = 'PA'
410: AND action_information3 = g_gre_org_id
411: AND action_information2 = g_assess_year||g_quarter

Line 453: FROM pay_action_information pai

449: , 'CHALLAN_REC_INDEX=P'
450: , '1' challan_count
451: FROM dual
452: WHERE NOT EXISTS ( SELECT 'EXISTS'
453: FROM pay_action_information pai
454: WHERE action_information_category = 'IN_24Q_CHALLAN'
455: AND action_context_type = 'PA'
456: AND action_information3 = g_gre_org_id
457: AND action_information2 = g_assess_year||g_quarter

Line 492: FROM pay_action_information pai

488: , 'TAX_RATE=P'
489: , NVL(pai.action_information13,'0')
490: , 'DED_REC_INDEX=P'
491: , action_information25
492: FROM pay_action_information pai
493: WHERE action_information_category ='IN_24Q_DEDUCTEE'
494: AND action_context_type = 'AAP'
495: AND action_information3 =g_gre_org_id
496: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')

Line 599: FROM pay_action_information

595: , 'L_CESS=P'
596: , pay_in_24q_er_returns.get_24Q_values('IN_24Q_SALARY','F16 Education Cess',action_context_id,source_id,1)
597: , 'L_TOT_TDS=P'
598: , pay_in_24q_er_returns.get_24Q_values('IN_24Q_SALARY','F16 TDS',action_context_id,source_id,1)
599: FROM pay_action_information
600: WHERE action_information_category = 'IN_24Q_PERSON'
601: AND action_context_type = 'AAP'
602: AND action_information2 = g_assess_year||g_quarter
603: AND action_information3 = g_gre_org_id

Line 605: FROM pay_action_information pai

601: AND action_context_type = 'AAP'
602: AND action_information2 = g_assess_year||g_quarter
603: AND action_information3 = g_gre_org_id
604: AND action_context_id IN (SELECT MAX(pai.action_context_id)
605: FROM pay_action_information pai
606: ,pay_assignment_actions paa
607: ,per_assignments_f asg
608: WHERE pai.action_information_category = 'IN_24Q_PERSON'
609: AND pai.action_context_type = 'AAP'

Line 632: FROM pay_action_information

628: ,'QUALIFY_AMOUNT=P'
629: ,pay_in_24q_er_returns.get_format_value(action_information2)
630: ,'PERIOD=P'
631: ,g_quarter
632: FROM pay_action_information
633: WHERE action_information_category = 'IN_24Q_VIA'
634: AND action_context_type = 'AAP'
635: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')
636: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')