APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_ACTION_INFORMATION

Line 28: FROM pay_action_information pai

24: CURSOR c_count
25: IS
26: SELECT DECODE(COUNT(DISTINCT action_information1),0,'1',
27: COUNT(DISTINCT action_information1))
28: FROM pay_action_information pai
29: WHERE action_information_category = 'IN_24Q_CHALLAN'
30: AND action_context_type = 'PA'
31: AND action_information3 = p_gre_org_id
32: AND action_information2 = p_assess_period

Line 91: FROM pay_action_information pai

87:
88: CURSOR c_count
89: IS
90: SELECT COUNT(*)
91: FROM pay_action_information pai
92: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
93: AND action_context_type = 'AAP'
94: AND action_information3 = p_gre_org_id
95: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa

Line 169: FROM pay_action_information pai

165: , NVL(pai.action_information7,0) SUR
166: , NVL(pai.action_information8,0) EC
167: , NVL(pai.action_information9,0) INTR
168: , NVL(pai.action_information10,0) OTH
169: FROM pay_action_information pai
170: WHERE action_information_category = 'IN_24Q_CHALLAN'
171: AND action_context_type = 'PA'
172: AND action_information3 = p_gre_org_id
173: AND action_information2 = p_assess_period

Line 290: FROM pay_action_information pai

286: SELECT SUM(NVL(pai.action_information9,0)) -----total tax paid
287: ,SUM(NVL(pai.action_information6,0))
288: ,SUM(NVL(pai.action_information7,0))
289: ,SUM(NVL(pai.action_information8,0))
290: FROM pay_action_information pai
291: WHERE action_information_category ='IN_24Q_DEDUCTEE'
292: AND action_context_type = 'AAP'
293: AND action_information3 =p_gre_org_id
294: AND action_information1=p_challan_number

Line 376: FROM pay_action_information

372:
373: CURSOR c_count
374: IS
375: SELECT COUNT(*)
376: FROM pay_action_information
377: WHERE action_information_category = 'IN_24Q_VIA'
378: AND action_context_type = 'AAP'
379: AND action_context_id = p_action_context_id
380: AND source_id =p_source_id;

Line 436: FROM pay_action_information

432:
433: CURSOR c_count
434: IS
435: SELECT COUNT(*)
436: FROM pay_action_information
437: WHERE action_information_category = 'IN_24Q_PERSON'
438: AND action_context_type = 'AAP'
439: AND action_information2 = p_assess_period
440: AND action_information3 = p_gre_org_id

Line 442: FROM pay_action_information pai

438: AND action_context_type = 'AAP'
439: AND action_information2 = p_assess_period
440: AND action_information3 = p_gre_org_id
441: AND action_context_id IN (SELECT MAX(pai.action_context_id)
442: FROM pay_action_information pai
443: ,pay_assignment_actions paa
444: ,per_assignments_f asg
445: WHERE pai.action_information_category = 'IN_24Q_PERSON'
446: AND pai.action_context_type = 'AAP'

Line 512: FROM pay_action_information

508:
509: CURSOR c_count
510: IS
511: SELECT COUNT(*)
512: FROM pay_action_information
513: WHERE action_information_category = 'IN_24Q_PERSON'
514: AND action_context_type = 'AAP'
515: AND SUBSTR(action_information2,1,9) = p_assess_year
516: AND action_information3 = p_gre_org_id

Line 519: FROM pay_action_information pai

515: AND SUBSTR(action_information2,1,9) = p_assess_year
516: AND action_information3 = p_gre_org_id
517: AND assignment_id = p_assignment_id
518: AND action_context_id IN ( SELECT MAX(action_context_id)
519: FROM pay_action_information pai
520: ,pay_assignment_actions paa
521: ,per_assignments_f asg
522: WHERE action_information_category = 'IN_24Q_PERSON'
523: AND action_context_type = 'AAP'

Line 595: FROM pay_action_information

591:
592: CURSOR c_form24Q_values IS
593: SELECT NVL(action_information2,0)
594: ,NVL(action_information3,0)
595: FROM pay_action_information
596: WHERE action_information_category = p_category
597: AND action_information1 = p_component_name
598: AND action_context_id = p_context_id
599: AND source_id = p_source_id;

Line 717: FROM pay_action_information

713:
714: CURSOR csr_income_details(p_balance VARCHAR2,p_action_context_id NUMBER,p_source_id IN NUMBER)
715: IS
716: SELECT NVL(SUM(action_information2),0)
717: FROM pay_action_information
718: WHERE action_information_category = 'IN_24Q_SALARY'
719: AND action_context_type = 'AAP'
720: AND action_information1 = p_balance
721: AND action_context_id = p_action_context_id

Line 727: FROM pay_action_information pai

723:
724: CURSOR csr_get_max_cont_id IS
725: SELECT MAX(pai.action_context_id) action_cont_id
726: ,source_id sour_id
727: FROM pay_action_information pai
728: ,pay_assignment_actions paa
729: ,per_assignments_f asg
730: WHERE pai.action_information_category = 'IN_24Q_PERSON'
731: AND pai.action_information3 = p_gre_org_id