APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_ACTION_INFORMATION

Line 242: FROM pay_action_information pai

238: , 'MAX_ACTION_CONTEXT_ID=P'
239: , pai.action_context_id
240: , 'SUBMIT_DATE=P'
241: , TO_CHAR (SYSDATE,'DDMMYYYY')
242: FROM pay_action_information pai
243: , pay_payroll_actions ppa
244: WHERE pai.action_information_category = 'IN_24Q_ORG'
245: AND pai.action_context_type = 'PA'
246: AND pai.action_information1 = g_gre_org_id

Line 254: FROM pay_action_information

250: AND ppa.report_type='IN_24Q_ARCHIVE'
251: AND ppa.report_qualifier = 'IN'
252: AND ppa.payroll_action_id = pai.action_context_id
253: AND pai.action_context_id = ( SELECT MAX(action_context_id)
254: FROM pay_action_information
255: WHERE action_information1 = g_gre_org_id
256: AND action_information3 = g_assess_year||g_quarter
257: AND action_context_type = 'PA'
258: AND action_information_category = 'IN_24Q_ORG')

Line 326: FROM pay_action_information pai

322: , 'GROSS_TOT_TOTAL=P'
323: , pay_in_24q_er_returns.total_gross_tot_income(g_gre_org_id,(g_assess_year||g_quarter))
324: , 'SAL_DET=P'
325: , pay_magtape_generic.get_parameter_value('SAL_DETAILS')
326: FROM pay_action_information pai
327: WHERE pai.action_information_category = 'IN_24Q_ORG'
328: AND pai.action_context_type = 'PA'
329: AND pai.action_information1 = g_gre_org_id
330: AND pai.action_information3 = g_assess_year||g_quarter

Line 377: FROM pay_action_information pai

373: , 'REMARKS=P'
374: , SUBSTR(pai.action_information13,1,14)||'^'
375: , 'CHALLAN_REC_INDEX=P'
376: , pai.action_information25
377: FROM pay_action_information pai
378: WHERE action_information_category = 'IN_24Q_CHALLAN'
379: AND action_context_type = 'PA'
380: AND action_information3 = g_gre_org_id
381: AND action_information2 = g_assess_year||g_quarter

Line 423: FROM pay_action_information pai

419: , 'CHALLAN_REC_INDEX=P'
420: , '1'
421: FROM dual
422: WHERE NOT EXISTS ( SELECT 'EXISTS'
423: FROM pay_action_information pai
424: WHERE action_information_category = 'IN_24Q_CHALLAN'
425: AND action_context_type = 'PA'
426: AND action_information3 = g_gre_org_id
427: AND action_information2 = g_assess_year||g_quarter

Line 461: FROM pay_action_information pai

457: , 'TAX_RATE=P'
458: , NVL(pai.action_information13,'0')
459: , 'DED_REC_INDEX=P'
460: , action_information25
461: FROM pay_action_information pai
462: WHERE action_information_category ='IN_24Q_DEDUCTEE'
463: AND action_context_type = 'AAP'
464: AND action_information3 =g_gre_org_id
465: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')

Line 568: FROM pay_action_information

564: , 'L_CESS=P'
565: , pay_in_24q_er_returns.get_24Q_values('IN_24Q_SALARY','F16 Education Cess',action_context_id,source_id,1)
566: , 'L_TOT_TDS=P'
567: , pay_in_24q_er_returns.get_24Q_values('IN_24Q_SALARY','F16 TDS',action_context_id,source_id,1)
568: FROM pay_action_information
569: WHERE action_information_category = 'IN_24Q_PERSON'
570: AND action_context_type = 'AAP'
571: AND action_information2 = g_assess_year||g_quarter
572: AND action_information3 = g_gre_org_id

Line 574: FROM pay_action_information pai

570: AND action_context_type = 'AAP'
571: AND action_information2 = g_assess_year||g_quarter
572: AND action_information3 = g_gre_org_id
573: AND action_context_id IN (SELECT MAX(pai.action_context_id)
574: FROM pay_action_information pai
575: ,pay_assignment_actions paa
576: ,per_assignments_f asg
577: WHERE pai.action_information_category = 'IN_24Q_PERSON'
578: AND pai.action_context_type = 'AAP'

Line 601: FROM pay_action_information

597: ,'QUALIFY_AMOUNT=P'
598: ,pay_in_24q_er_returns.get_format_value(action_information2)
599: ,'PERIOD=P'
600: ,g_quarter
601: FROM pay_action_information
602: WHERE action_information_category = 'IN_24Q_VIA'
603: AND action_context_type = 'AAP'
604: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')
605: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')