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_IN_24QC_ER_RETURNS dependencies on PAY_ACTION_INFORMATION

Line 238: FROM pay_action_information pai

234: , 'CHECK_C4=P'
235: , NVL(pai.action_information29,'N')
236: ,'TOTAL_BATCH_NO=P'
237: , DECODE(LENGTH(pai.action_information29), 1, 1, 2, 1, 5, 2, 8, 3, 11, 4, 14, 5, 17,6,1)
238: FROM pay_action_information pai
239: , pay_payroll_actions ppa
240: WHERE pai.action_information_category = 'IN_24QC_ORG'
241: AND pai.action_context_type = 'PA'
242: AND pai.action_information1 = g_gre_org_id

Line 338: FROM pay_action_information pai

334: , pay_in_24qc_er_returns.total_gross_tot_income(g_gre_org_id
335: , g_assess_year||g_quarter
336: , hll.lookup_code
337: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
338: FROM pay_action_information pai
339: ,hr_leg_lookups hll
340: WHERE pai.action_information_category = 'IN_24QC_ORG'
341: AND pai.action_context_type = 'PA'
342: AND pai.action_information1 = g_gre_org_id

Line 400: FROM pay_action_information pai

396: , 'CHALLAN_UPD_IND=P'
397: , DECODE(pai.action_information18, 'U', '1', '0')
398: , 'CHALLAN_REC_INDEX=P'
399: , pai.action_information25
400: FROM pay_action_information pai
401: WHERE action_information_category = 'IN_24QC_CHALLAN'
402: AND action_context_type = 'PA'
403: AND action_information3 = g_gre_org_id
404: AND action_information2 = g_assess_year||g_quarter

Line 449: FROM pay_action_information pai

445: , 'DED_REC_INDEX=P'
446: , pai.action_information25
447: , 'UPD_MODE=P'
448: , pai.action_information15
449: FROM pay_action_information pai
450: WHERE action_information_category ='IN_24QC_DEDUCTEE'
451: AND action_context_type = 'AAP'
452: AND action_information3 = g_gre_org_id
453: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')

Line 543: FROM pay_action_information

539: , 'F16_PERQ_VALUE=P'
540: , pay_in_24q_er_returns.get_24Q_values('IN_24QC_SALARY','F16 Value of Perquisites',action_context_id,source_id,1)
541: , 'PERIOD=P'
542: , g_quarter
543: FROM pay_action_information
544: WHERE action_information_category = 'IN_24QC_PERSON'
545: AND action_context_type = 'AAP'
546: AND action_information2 = g_assess_year||g_quarter
547: AND action_information3 = g_gre_org_id

Line 550: FROM pay_action_information pai

546: AND action_information2 = g_assess_year||g_quarter
547: AND action_information3 = g_gre_org_id
548: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
549: AND action_context_id IN (SELECT MAX(pai.action_context_id)
550: FROM pay_action_information pai
551: ,pay_assignment_actions paa
552: ,per_assignments_f asg
553: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
554: AND pai.action_context_id = paa.assignment_action_id

Line 577: FROM pay_action_information

573: ,'VIA_SECTION_ID=P'
574: ,action_information1
575: ,'QUALIFY_AMOUNT=P'
576: ,pay_in_24q_er_returns.get_format_value(action_information2)
577: FROM pay_action_information
578: WHERE action_information_category = 'IN_24QC_VIA'
579: AND action_context_type = 'AAP'
580: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')
581: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')