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

109:
110: CURSOR c_count
111: IS
112: SELECT COUNT(*)
113: FROM pay_action_information pai
114: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
115: AND action_context_type = 'AAP'
116: AND action_information3 = p_gre_org_id
117: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa

Line 191: FROM pay_action_information pai

187: , NVL(pai.action_information7,0) SUR
188: , NVL(pai.action_information8,0) EC
189: , NVL(pai.action_information9,0) INTR
190: , NVL(pai.action_information10,0) OTH
191: FROM pay_action_information pai
192: WHERE action_information_category = 'IN_24Q_CHALLAN'
193: AND action_context_type = 'PA'
194: AND action_information3 = p_gre_org_id
195: AND action_information2 = p_assess_period

Line 318: FROM pay_action_information pai

314: SELECT SUM(NVL(pai.action_information9,0)) -----total tax paid
315: ,SUM(NVL(pai.action_information6,0))
316: ,SUM(NVL(pai.action_information7,0))
317: ,SUM(NVL(pai.action_information8,0))
318: FROM pay_action_information pai
319: WHERE action_information_category ='IN_24Q_DEDUCTEE'
320: AND action_context_type = 'AAP'
321: AND action_information3 =p_gre_org_id
322: AND action_information1=p_challan_number

Line 404: FROM pay_action_information

400:
401: CURSOR c_count
402: IS
403: SELECT COUNT(*)
404: FROM pay_action_information
405: WHERE action_information_category = 'IN_24Q_VIA'
406: AND action_context_type = 'AAP'
407: AND action_context_id = p_action_context_id
408: AND source_id =p_source_id;

Line 464: FROM pay_action_information

460:
461: CURSOR c_count
462: IS
463: SELECT COUNT(*)
464: FROM pay_action_information
465: WHERE action_information_category = 'IN_24Q_PERSON'
466: AND action_context_type = 'AAP'
467: AND action_information2 = p_assess_period
468: AND action_information3 = p_gre_org_id

Line 470: FROM pay_action_information pai

466: AND action_context_type = 'AAP'
467: AND action_information2 = p_assess_period
468: AND action_information3 = p_gre_org_id
469: AND action_context_id IN (SELECT MAX(pai.action_context_id)
470: FROM pay_action_information pai
471: ,pay_assignment_actions paa
472: ,per_assignments_f asg
473: WHERE pai.action_information_category = 'IN_24Q_PERSON'
474: AND pai.action_context_type = 'AAP'

Line 540: FROM pay_action_information

536:
537: CURSOR c_count
538: IS
539: SELECT COUNT(*)
540: FROM pay_action_information
541: WHERE action_information_category = 'IN_24Q_PERSON'
542: AND action_context_type = 'AAP'
543: AND SUBSTR(action_information2,1,9) = p_assess_year
544: AND action_information3 = p_gre_org_id

Line 547: FROM pay_action_information pai

543: AND SUBSTR(action_information2,1,9) = p_assess_year
544: AND action_information3 = p_gre_org_id
545: AND assignment_id = p_assignment_id
546: AND action_context_id IN ( SELECT MAX(action_context_id)
547: FROM pay_action_information pai
548: ,pay_assignment_actions paa
549: ,per_assignments_f asg
550: WHERE action_information_category = 'IN_24Q_PERSON'
551: AND action_context_type = 'AAP'

Line 624: FROM pay_action_information

620: -- Bug 10365553: Added round() to fetch values upto 2 decimal places
621: CURSOR c_form24Q_values IS
622: SELECT round(NVL(fnd_number.canonical_to_number(action_information2),0),2)
623: ,round(NVL(fnd_number.canonical_to_number(action_information3),0),2)
624: FROM pay_action_information
625: WHERE action_information_category = p_category
626: AND action_information1 = p_component_name
627: AND action_context_id = p_context_id
628: AND source_id = p_source_id;

Line 747: FROM pay_action_information

743:
744: CURSOR csr_income_details(p_balance VARCHAR2,p_action_context_id NUMBER,p_source_id IN NUMBER)
745: IS
746: SELECT NVL(SUM(fnd_number.canonical_to_number(action_information2)),0)
747: FROM pay_action_information
748: WHERE action_information_category = 'IN_24Q_SALARY'
749: AND action_context_type = 'AAP'
750: AND action_information1 = p_balance
751: AND action_context_id = p_action_context_id

Line 757: FROM pay_action_information pai

753:
754: CURSOR csr_get_max_cont_id IS
755: SELECT MAX(pai.action_context_id) action_cont_id
756: ,source_id sour_id
757: FROM pay_action_information pai
758: ,pay_assignment_actions paa
759: ,per_assignments_f asg
760: WHERE pai.action_information_category = 'IN_24Q_PERSON'
761: AND pai.action_information3 = p_gre_org_id