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 99: FROM pay_action_information pai

95:
96: CURSOR c_count
97: IS
98: SELECT COUNT(DISTINCT action_information1)
99: FROM pay_action_information pai
100: WHERE action_information_category = 'IN_24QC_CHALLAN'
101: AND action_context_type = 'PA'
102: AND action_information3 = p_gre_org_id
103: AND action_information2 = p_assess_period

Line 278: FROM pay_action_information pai

274: , NVL(pai.action_information7,0) SUR
275: , NVL(pai.action_information8,0) EC
276: , NVL(pai.action_information9,0) INTR
277: , NVL(pai.action_information10,0) OTH
278: FROM pay_action_information pai
279: WHERE action_information_category = 'IN_24QC_CHALLAN'
280: AND action_context_type = 'PA'
281: AND action_information3 = p_gre_org_id
282: AND action_information2 = p_assess_period

Line 358: FROM pay_action_information pai

354:
355: CURSOR c_nil_challan
356: IS
357: SELECT action_information25
358: FROM pay_action_information pai
359: WHERE action_information_category = 'IN_24QC_ORG'
360: AND action_context_type = 'PA'
361: AND pai.action_information1 = p_gre_org_id
362: AND pai.action_information3 = p_assess_period

Line 425: FROM pay_action_information pai

421:
422: CURSOR c_count
423: IS
424: SELECT COUNT(DISTINCT source_id)
425: FROM pay_action_information pai
426: WHERE action_information_category = 'IN_24QC_DEDUCTEE'
427: AND action_context_type = 'AAP'
428: AND action_information3 = p_gre_org_id
429: AND EXISTS (SELECT 1

Line 525: FROM pay_action_information

521: ,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
522: ,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
523: ,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8
524: ,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23
525: FROM pay_action_information
526: WHERE action_information_category ='IN_24QC_DEDUCTEE'
527: AND action_context_type = 'AAP'
528: AND action_information3 = p_gre_org_id
529: AND action_information1 = p_challan_number

Line 615: FROM pay_action_information

611:
612: CURSOR csr_arch_action_id
613: IS
614: SELECT MAX(action_context_id)
615: FROM pay_action_information
616: WHERE action_information1 = p_gre_org_id
617: AND action_information3 = p_period
618: AND action_context_type = 'PA'
619: AND action_information_category = 'IN_24QC_ORG';

Line 736: FROM pay_action_information

732:
733: CURSOR csr_income_details(p_balance VARCHAR2,p_action_context_id NUMBER,p_source_id IN NUMBER)
734: IS
735: SELECT NVL(SUM(action_information2),0)
736: FROM pay_action_information
737: WHERE action_information_category = 'IN_24QC_SALARY'
738: AND action_context_type = 'AAP'
739: AND action_information1 = p_balance
740: AND action_context_id = p_action_context_id

Line 746: FROM pay_action_information pai

742:
743: CURSOR csr_get_max_cont_id IS
744: SELECT MAX(pai.action_context_id) action_cont_id
745: ,source_id sour_id
746: FROM pay_action_information pai
747: ,pay_assignment_actions paa
748: ,per_assignments_f asg
749: WHERE paa.payroll_action_id = p_max_action_id
750: AND pai.action_context_id = paa.assignment_action_id

Line 843: FROM pay_action_information

839:
840: CURSOR c_count
841: IS
842: SELECT COUNT(*)
843: FROM pay_action_information
844: WHERE action_information_category = 'IN_24QC_PERSON'
845: AND action_context_type = 'AAP'
846: AND action_information2 = p_assess_period
847: AND action_information3 = p_gre_org_id

Line 850: FROM pay_action_information pai

846: AND action_information2 = p_assess_period
847: AND action_information3 = p_gre_org_id
848: AND action_information11 = p_correction_type
849: AND action_context_id IN (SELECT MAX(pai.action_context_id)
850: FROM pay_action_information pai
851: ,pay_assignment_actions paa
852: ,per_assignments_f asg
853: WHERE paa.payroll_action_id = p_max_action_id
854: AND pai.action_context_id = paa.assignment_action_id

Line 940: FROM pay_action_information

936:
937: CURSOR c_count
938: IS
939: SELECT COUNT(*)
940: FROM pay_action_information
941: WHERE action_information_category = 'IN_24QC_VIA'
942: AND action_context_type = 'AAP'
943: AND action_context_id = p_action_context_id
944: AND source_id =p_source_id;