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

Line 265: FROM pay_action_information

261:
262: CURSOR c_chk_person_data
263: IS
264: SELECT 1
265: FROM pay_action_information
266: WHERE action_information_category = 'IN_24QC_PERSON'
267: AND action_context_type = 'AAP'
268: AND source_id = p_source_id
269: AND action_information10 = p_mode

Line 280: FROM pay_action_information

276:
277: CURSOR c_chk_ded_data
278: IS
279: SELECT 1
280: FROM pay_action_information
281: WHERE action_information_category = 'IN_24QC_DEDUCTEE'
282: AND action_context_type = 'AAP'
283: AND source_id = p_source_id
284: AND action_information15 = p_mode

Line 294: FROM pay_action_information

290:
291: CURSOR c_chk_org_data
292: IS
293: SELECT 1
294: FROM pay_action_information
295: WHERE action_information_category = 'IN_24QC_ORG'
296: AND action_context_type = 'PA'
297: AND action_context_id = g_payroll_action_id
298: AND action_information1 = g_gre_id;

Line 303: FROM pay_action_information

299:
300: CURSOR c_chk_challan_data
301: IS
302: SELECT 1
303: FROM pay_action_information
304: WHERE action_information_category = 'IN_24QC_CHALLAN'
305: AND action_context_type = 'PA'
306: AND action_context_id = g_payroll_action_id
307: AND action_information1 = p_act_information1

Line 441: FROM pay_action_information pai

437: --
438: CURSOR csr_arch_ref_no(p_payroll_action_id NUMBER)
439: IS
440: SELECT 1
441: FROM pay_action_information pai
442: ,pay_payroll_actions ppa
443: WHERE pai.action_information_category = 'IN_24QC_ORG'
444: AND pai.action_context_type = 'PA'
445: AND pai.action_information1 = g_gre_id

Line 652: FROM pay_action_information pai

648: ,p_24q_pay_action_id NUMBER
649: )
650: IS
651: SELECT SUM(NVL(pai.action_information9,0)) amount_deposited
652: FROM pay_action_information pai
653: ,pay_assignment_actions paa
654: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
655: AND paa.assignment_action_id = pai.action_context_id
656: AND pai.action_information1 = p_challan_number

Line 724: FROM pay_action_information pai

720: CURSOR check_ee
721: IS
722: SELECT pai.action_information1
723: ,MAX(pai.action_context_id)
724: FROM pay_action_information pai
725: ,pay_action_interlocks locks
726: ,pay_assignment_actions paa
727: ,pay_assignment_actions paa_24qc
728: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 800: FROM pay_action_information pai

796: IS
797: SELECT pai.source_id element_entry_id
798: ,pai.assignment_id assignment_id
799: ,pai.action_context_id last_action_context_id
800: FROM pay_action_information pai
801: ,pay_assignment_actions paa
802: WHERE pai.action_information_category LIKE 'IN_24Q%_DEDUCTEE'
803: AND pai.action_context_id = paa.assignment_action_id
804: AND(

Line 834: FROM pay_action_information pai

830: )
831: AND (
832: pai.source_id NOT IN
833: (SELECT pai.source_id
834: FROM pay_action_information pai
835: ,pay_action_interlocks locks
836: ,pay_assignment_actions paa
837: ,pay_assignment_actions masters
838: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 861: FROM pay_action_information pai

857: OR
858: pay_in_utils.get_ee_value(pai.source_id,'Challan or Voucher Number') NOT IN
859: (
860: (SELECT pai.action_information1
861: FROM pay_action_information pai
862: ,pay_action_interlocks locks
863: ,pay_assignment_actions paa
864: ,pay_assignment_actions masters
865: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 903: FROM pay_action_information pai

899: AND entry.effective_start_date BETWEEN g_qr_start_date AND g_qr_end_date
900: AND (
901: entry.element_entry_id NOT IN
902: (SELECT pai.source_id
903: FROM pay_action_information pai
904: ,pay_assignment_actions paa
905: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
906: AND pai.action_context_id = paa.assignment_action_id
907: AND paa.payroll_action_id = p_payroll_action_id

Line 912: FROM pay_action_information pai

908: )
909: OR
910: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') NOT IN
911: (SELECT pai.action_information1
912: FROM pay_action_information pai
913: ,pay_assignment_actions paa
914: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
915: AND pai.action_context_id = paa.assignment_action_id
916: AND paa.payroll_action_id = p_payroll_action_id

Line 923: FROM pay_action_information pai

919: )
920: AND (
921: entry.element_entry_id NOT IN
922: (SELECT pai.source_id
923: FROM pay_action_information pai
924: ,pay_action_interlocks locks
925: ,pay_assignment_actions paa
926: ,pay_assignment_actions paa_24qc
927: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 950: FROM pay_action_information pai

946: OR
947: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') NOT IN
948: (
949: (SELECT pai.action_information1
950: FROM pay_action_information pai
951: ,pay_action_interlocks locks
952: ,pay_assignment_actions paa
953: ,pay_assignment_actions paa_24qc
954: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 995: FROM pay_action_information

991: AND
992: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
993: (
994: SELECT action_information1
995: FROM pay_action_information
996: WHERE action_information_category IN('IN_24QC_CHALLAN','IN_24Q_CHALLAN')
997: AND (
998: action_information15 = p_payroll_action_id
999: AND action_information_category = 'IN_24QC_CHALLAN'

Line 1028: FROM pay_action_information

1024: AND
1025: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') NOT IN
1026: (
1027: SELECT action_information1
1028: FROM pay_action_information
1029: WHERE action_information_category IN('IN_24QC_CHALLAN','IN_24Q_CHALLAN')
1030: AND (
1031: action_information15 = p_payroll_action_id
1032: AND action_information_category = 'IN_24QC_CHALLAN'

Line 1065: FROM pay_action_information pai

1061: SELECT pai.source_id element_entry_id
1062: ,pai.assignment_id assignment_id
1063: ,pai.action_context_id last_action_context_id
1064: ,pep.effective_end_date
1065: FROM pay_action_information pai
1066: ,pay_assignment_actions paa
1067: ,per_people_f pep
1068: ,per_assignments_f asg
1069: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'

Line 1132: FROM pay_action_information pai_locking

1128: ,p_mode VARCHAR2
1129: )
1130: IS
1131: SELECT pai_locking.action_context_id last_action_context_id
1132: FROM pay_action_information pai_locking
1133: ,pay_action_interlocks locks
1134: ,pay_assignment_actions paa
1135: WHERE pai_locking.action_information_category = 'IN_24QC_DEDUCTEE'
1136: AND pai_locking.action_information3 = g_gre_id

Line 1161: FROM pay_action_information pai

1157: ,p_element_entry_id NUMBER
1158: )
1159: IS
1160: SELECT pai.action_context_id
1161: FROM pay_action_information pai
1162: ,per_people_f pep
1163: ,per_assignments_f asg
1164: ,pay_assignment_actions paa
1165: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 1231: FROM pay_action_information pai

1227: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date
1228: AND NOT EXISTS
1229: (
1230: SELECT 1
1231: FROM pay_action_information pai
1232: ,per_people_f pep
1233: ,per_assignments_f asg
1234: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1235: AND pai.source_id = p_element_entry_id

Line 1294: FROM pay_action_information pai

1290: IS
1291: SELECT MAX(pai.action_context_id) last_action_context_id
1292: ,pai.source_id element_entry_id
1293: ,pai.assignment_id assignment_id
1294: FROM pay_action_information pai
1295: ,pay_assignment_actions paa
1296: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1297: AND pai.action_information3 = g_gre_id
1298: AND pai.action_information2 = g_year||g_quarter

Line 1318: FROM pay_action_information pai

1314: OR
1315: (
1316: pai.source_id NOT IN(
1317: SELECT pai.source_id
1318: FROM pay_action_information pai
1319: ,pay_assignment_actions paa
1320: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1321: AND pai.action_information3 = g_gre_id
1322: AND pai.action_information2 = g_year||g_quarter

Line 1663: FROM pay_action_information

1659: RETURN VARCHAR2 IS
1660:
1661: CURSOR c_form24Q_values IS
1662: SELECT NVL(action_information2,0)
1663: FROM pay_action_information
1664: WHERE action_information_category = p_category
1665: AND action_information1 = p_component_name
1666: AND action_context_id = p_context_id
1667: AND source_id = p_source_id;

Line 1736: FROM pay_action_information pai

1732: IS
1733: SELECT pai.source_id source_id
1734: ,pai.assignment_id assignment_id
1735: ,pai.action_context_id last_action_context_id
1736: FROM pay_action_information pai
1737: ,pay_assignment_actions paa
1738: WHERE pai.action_information_category LIKE 'IN_24Q%_PERSON'
1739: AND fnd_number.canonical_to_number(pai.action_information1)
1740: BETWEEN p_start_person AND p_end_person

Line 1794: FROM pay_action_information pai

1790: )
1791: AND (
1792: pai.source_id NOT IN
1793: (SELECT pai.source_id
1794: FROM pay_action_information pai
1795: ,pay_action_interlocks locks
1796: ,pay_assignment_actions paa
1797: ,pay_assignment_actions masters
1798: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 1857: FROM pay_action_information pai

1853: GROUP BY paf.assignment_id) a
1854: WHERE (
1855: a.source_id NOT IN
1856: (SELECT pai.source_id
1857: FROM pay_action_information pai
1858: ,pay_assignment_actions paa
1859: WHERE pai.action_information_category = 'IN_24Q_PERSON'
1860: AND pai.action_context_id = paa.assignment_action_id
1861: AND paa.payroll_action_id = p_payroll_action_id

Line 1867: FROM pay_action_information pai

1863: )
1864: AND (
1865: a.source_id NOT IN
1866: (SELECT pai.source_id
1867: FROM pay_action_information pai
1868: ,pay_action_interlocks locks
1869: ,pay_assignment_actions paa
1870: ,pay_assignment_actions paa_24qc
1871: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 1894: FROM pay_action_information pai

1890: )
1891: AND (
1892: a.source_id NOT IN
1893: (SELECT pai.source_id
1894: FROM pay_action_information pai
1895: ,pay_action_interlocks locks
1896: ,pay_assignment_actions paa
1897: ,pay_assignment_actions paa_24qc
1898: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 1921: FROM pay_action_information pai

1917: )
1918: AND (
1919: a.source_id NOT IN
1920: (SELECT pai.source_id
1921: FROM pay_action_information pai
1922: ,pay_assignment_actions paa_24qc
1923: WHERE pai.action_information_category = 'IN_24QC_PERSON'
1924: AND pai.action_information3 = g_gre_id
1925: AND pai.action_information2 = g_year||g_quarter

Line 1951: FROM pay_action_information pai

1947: pai.source_id source_id
1948: ,pai.assignment_id assignment_id
1949: ,pai.action_context_id last_action_context_id
1950: ,pep.effective_end_date
1951: FROM pay_action_information pai
1952: ,pay_assignment_actions paa
1953: ,per_people_f pep
1954: ,per_assignments_f asg
1955: WHERE pai.action_information_category = 'IN_24Q_PERSON'

Line 2089: FROM pay_action_information pai_locking

2085: ,p_source_id NUMBER
2086: )
2087: IS
2088: SELECT pai_locking.action_context_id last_action_context_id
2089: FROM pay_action_information pai_locking
2090: ,pay_action_interlocks locks
2091: ,pay_assignment_actions paa
2092: WHERE pai_locking.action_information_category = 'IN_24QC_PERSON'
2093: AND fnd_number.canonical_to_number(pai_locking.action_information1)

Line 2119: FROM pay_action_information pai

2115: ,p_source_id NUMBER
2116: )
2117: IS
2118: SELECT pai.action_context_id
2119: FROM pay_action_information pai
2120: ,per_people_f pep
2121: ,per_assignments_f asg
2122: ,pay_assignment_actions paa
2123: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 2263: FROM pay_action_information pai

2259: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date
2260: AND NOT EXISTS
2261: (
2262: SELECT 1
2263: FROM pay_action_information pai
2264: ,per_people_f pep
2265: ,per_assignments_f asg
2266: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2267: AND fnd_number.canonical_to_number(pai.action_information1)

Line 2369: FROM pay_action_information pai

2365: IS
2366: SELECT MAX(pai.action_context_id) last_action_context_id
2367: ,pai.source_id source_id
2368: ,pai.assignment_id assignment_id
2369: FROM pay_action_information pai
2370: ,pay_assignment_actions paa
2371: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2372: AND fnd_number.canonical_to_number(pai.action_information1)
2373: BETWEEN p_start_person AND p_end_person

Line 2398: FROM pay_action_information pai

2394: OR
2395: (
2396: pai.source_id NOT IN(
2397: SELECT pai.source_id
2398: FROM pay_action_information pai
2399: ,pay_assignment_actions paa
2400: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2401: AND fnd_number.canonical_to_number(pai.action_information1)
2402: BETWEEN p_start_person AND p_end_person

Line 2895: FROM pay_action_information pai

2891: CURSOR c_locking_24qc_pa_data
2892: IS
2893: SELECT DISTINCT pai.action_context_id locking_id
2894: ,pai.action_information1 gre_id
2895: FROM pay_action_information pai
2896: WHERE pai.action_context_type = 'PA'
2897: AND pai.action_information_category = 'IN_24QC_ORG'
2898: AND pai.action_information1 = p_gre_id
2899: AND pai.action_information3 = g_year||g_quarter

Line 2918: FROM pay_action_information

2914: -- This cursor fetches the GREs that were reported in Form 24Q Archival
2915: CURSOR c_chk_organization
2916: IS
2917: SELECT action_information1 gre_id
2918: FROM pay_action_information
2919: WHERE action_information_category = 'IN_24Q_ORG'
2920: AND action_context_type = 'PA'
2921: AND action_information1 = p_gre_id
2922: AND action_information3 = g_year||g_quarter

Line 2948: FROM pay_action_information pai

2944: ,p_action_context_id NUMBER
2945: )
2946: IS
2947: SELECT pai.action_context_id last_action_context_id
2948: FROM pay_action_information pai
2949: WHERE pai.action_information_category = p_act_inf_category
2950: AND pai.action_context_type = 'PA'
2951: AND pai.action_context_id = p_action_context_id
2952: AND pai.action_information1 = p_gre_id

Line 3287: FROM pay_action_information

3283: action_information9 interest,
3284: action_information10 other,
3285: action_information11 cheque_dd_num,
3286: source_id org_information_id
3287: FROM pay_action_information
3288: WHERE action_information2 = g_year||g_quarter
3289: AND action_information3 = p_gre_id
3290: AND action_information_category = p_act_info_category
3291: AND action_context_id IN

Line 3337: FROM pay_action_information

3333: action_information9 interest,
3334: action_information10 other,
3335: action_information11 cheque_dd_num,
3336: source_id org_information_id
3337: FROM pay_action_information
3338: WHERE action_information2 = g_year||g_quarter
3339: AND action_information3 = p_gre_id
3340: AND action_information_category = p_act_info_category
3341: AND action_context_id IN

Line 3827: FROM pay_action_information pai

3823: DECODE(action_information_category,'IN_24Q_DEDUCTEE'
3824: ,action_information9,'IN_24QC_DEDUCTEE'
3825: ,action_information16) Amount_Deposited
3826: ,action_information_id
3827: FROM pay_action_information pai
3828: WHERE pai.action_context_id = p_action_context_id
3829: AND pai.action_information_category IN ('IN_24Q_DEDUCTEE','IN_24QC_DEDUCTEE')
3830: AND pai.assignment_id = p_assignment_id
3831: AND pai.source_id = p_element_entry_id

Line 3842: FROM pay_action_information

3838: ,action_information4 pan_number
3839: ,action_information5 pan_ref_number
3840: ,action_information6 full_name
3841: ,action_information_id
3842: FROM pay_action_information
3843: WHERE action_context_id = p_action_context_id
3844: AND action_context_type = 'AAP'
3845: AND action_information_category = 'IN_24Q_PERSON'
3846: AND assignment_id = p_assignment_id

Line 3854: FROM pay_action_information

3850:
3851: CURSOR c_get_tax_rate_from_24q
3852: IS
3853: SELECT action_information13 tax_rate
3854: FROM pay_action_information
3855: WHERE action_context_id = p_action_context_id
3856: AND action_context_type = 'AAP'
3857: AND action_information_category = 'IN_24Q_DEDUCTEE'
3858: AND assignment_id = p_assignment_id

Line 3870: FROM pay_action_information

3866: ,action_information11 pan_ref_number
3867: ,action_information18 tax_rate
3868: ,action_information10 full_name
3869: ,action_information_id
3870: FROM pay_action_information
3871: WHERE action_context_id = p_action_context_id
3872: AND action_context_type = 'AAP'
3873: AND action_information_category = 'IN_24QC_DEDUCTEE'
3874: AND assignment_id = p_assignment_id

Line 4230: FROM pay_action_information pai

4226: CURSOR c_get_bal_24q(p_action_context_id NUMBER, p_24q_source_id NUMBER, p_category VARCHAR2, p_balance_name VARCHAR2)
4227: IS
4228: SELECT DISTINCT
4229: FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values(p_category,p_balance_name,pai.action_context_id,pai.source_id,1)))
4230: FROM pay_action_information pai
4231: WHERE pai.action_context_id = p_action_context_id
4232: AND pai.action_information_category = p_category
4233: AND pai.source_id = p_24q_source_id;
4234:

Line 4245: FROM pay_action_information pai

4241: ,pai.action_information6 full_name
4242: ,fnd_date.canonical_to_date(pai.action_information9) start_date
4243: ,fnd_date.canonical_to_date(pai.action_information10) end_date
4244: ,pai.source_id
4245: FROM pay_action_information pai
4246: ,pay_assignment_actions paa
4247: WHERE pai.action_information_category IN('IN_24Q_PERSON')
4248: AND pai.action_information3 = g_gre_id
4249: AND pai.action_information2 = g_year||g_quarter

Line 4269: FROM pay_action_information pai

4265: ,pai.action_information6 full_name
4266: ,fnd_date.canonical_to_date(pai.action_information8) start_date
4267: ,fnd_date.canonical_to_date(pai.action_information9) end_date
4268: ,pai.source_id
4269: FROM pay_action_information pai
4270: ,pay_assignment_actions paa
4271: ,pay_action_interlocks locks
4272: ,pay_assignment_actions paa_master
4273: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 4318: FROM pay_action_information pai

4314: p_assignment_id NUMBER
4315: )
4316: IS
4317: SELECT pai.action_context_id, pai.source_id
4318: FROM pay_action_information pai
4319: ,pay_assignment_actions paa
4320: ,pay_action_interlocks locks
4321: ,pay_assignment_actions paa_master
4322: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 4353: FROM pay_action_information pai

4349: p_assignment_id NUMBER
4350: )
4351: IS
4352: SELECT DISTINCT pai.action_context_id, pai.source_id
4353: FROM pay_action_information pai
4354: ,pay_assignment_actions paa
4355: WHERE pai.action_information_category IN('IN_24Q_PERSON')
4356: AND pai.action_information3 = g_gre_id
4357: AND pai.action_information2 = g_year||g_quarter

Line 4910: FROM pay_action_information pai

4906: ,p_source_id NUMBER
4907: )
4908: IS
4909: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information11))
4910: FROM pay_action_information pai
4911: ,pay_assignment_actions paa
4912: WHERE pai.action_information_category = 'IN_24Q_PERSON'
4913: AND pai.action_information3 = g_gre_id
4914: AND pai.action_information2 = g_year||g_quarter

Line 4935: FROM pay_action_information pai

4931: ,p_source_id NUMBER
4932: )
4933: IS
4934: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information12))
4935: FROM pay_action_information pai
4936: ,pay_assignment_actions paa
4937: ,pay_action_interlocks locks
4938: ,pay_assignment_actions paa_master
4939: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 4962: FROM pay_action_information pai

4958:
4959: CURSOR c_max_salary_number_24q
4960: IS
4961: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information11))
4962: FROM pay_action_information pai
4963: ,pay_assignment_actions paa
4964: WHERE pai.action_information_category = 'IN_24Q_PERSON'
4965: AND pai.action_information3 = g_gre_id
4966: AND pai.action_information2 = g_year||g_quarter

Line 4984: FROM pay_action_information pai

4980:
4981: CURSOR c_max_salary_number_24qc
4982: IS
4983: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information12))
4984: FROM pay_action_information pai
4985: ,pay_assignment_actions paa
4986: ,pay_action_interlocks locks
4987: ,pay_assignment_actions paa_master
4988: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 5086: FROM pay_action_information pai

5082: p_assignment_id NUMBER
5083: )
5084: IS
5085: SELECT DISTINCT pai.source_id,pai.action_context_id
5086: FROM pay_action_information pai
5087: ,pay_assignment_actions paa
5088: ,pay_action_interlocks locks
5089: ,pay_assignment_actions paa_master
5090: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 5116: FROM pay_action_information pai

5112: p_assignment_id NUMBER
5113: )
5114: IS
5115: SELECT DISTINCT pai.source_id,pai.action_context_id
5116: FROM pay_action_information pai
5117: WHERE pai.action_information_category IN('IN_24Q_PERSON')
5118: AND pai.action_information3 = g_gre_id
5119: AND pai.assignment_id = p_assignment_id
5120: AND pai.action_context_id = p_action_context_id

Line 5127: FROM pay_action_information pai

5123: CURSOR c_get_bal_24q(p_action_context_id NUMBER, p_24q_source_id NUMBER, p_category VARCHAR2, p_balance_name VARCHAR2)
5124: IS
5125: SELECT DISTINCT
5126: FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values(p_category,p_balance_name,pai.action_context_id,pai.source_id,1)))
5127: FROM pay_action_information pai
5128: WHERE pai.action_context_id = p_action_context_id
5129: AND pai.action_information_category = p_category
5130: AND pai.source_id = p_24q_source_id;
5131:

Line 5138: l_action_information_category pay_action_information.action_information_category%TYPE;

5134:
5135: tab_24q_pe_data t_person_data_sal_rec;
5136: tab_liv_pe_data t_person_data_sal_rec;
5137:
5138: l_action_information_category pay_action_information.action_information_category%TYPE;
5139: l_arch_asg_action_id NUMBER;
5140: l_24qa_asg_action_id NUMBER;
5141: l_24qa_source_id NUMBER;
5142: l_prev_asg_action_id NUMBER;

Line 5291: pay_action_information_api.create_action_information

5287: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
5288: AND ((l_c5_change_only = FALSE)) AND (g_quarter IN ('Q4') AND (l_flag = 0))
5289: THEN
5290:
5291: pay_action_information_api.create_action_information
5292: (p_action_context_id => l_arch_asg_action_id
5293: ,p_action_context_type => 'AAP'
5294: ,p_action_information_category => 'IN_24QC_PERSON'
5295: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5322: pay_action_information_api.create_action_information

5318: (tab_24q_ba_data(l).balance_value <> 0)
5319: )
5320: THEN
5321:
5322: pay_action_information_api.create_action_information
5323: (p_action_context_id => l_arch_asg_action_id
5324: ,p_action_context_type => 'AAP'
5325: ,p_action_information_category => 'IN_24QC_SALARY'
5326: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5349: pay_action_information_api.create_action_information

5345: FETCH c_get_bal_24q INTO l_balance_value;
5346: CLOSE c_get_bal_24q;
5347:
5348: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0)) THEN
5349: pay_action_information_api.create_action_information
5350: (p_action_context_id => l_arch_asg_action_id
5351: ,p_action_context_type => 'AAP'
5352: ,p_action_information_category => 'IN_24QC_SALARY'
5353: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5396: pay_action_information_api.create_action_information

5392:
5393: pay_in_utils.trace('Delete Source ID : ', g_sal_data_rec_del(i).source_id );
5394: pay_in_utils.trace('l_max_pact : ', l_max_pact );
5395:
5396: pay_action_information_api.create_action_information
5397: (p_action_context_id => l_arch_asg_action_id
5398: ,p_action_context_type => 'AAP'
5399: ,p_action_information_category => 'IN_24QC_PERSON'
5400: ,p_source_id => l_max_pact

Line 5425: pay_action_information_api.create_action_information

5421: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
5422: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
5423: )
5424: THEN
5425: pay_action_information_api.create_action_information
5426: (p_action_context_id => l_arch_asg_action_id
5427: ,p_action_context_type => 'AAP'
5428: ,p_action_information_category => 'IN_24QC_VIA'
5429: ,p_source_id => l_max_pact

Line 5440: pay_action_information_api.create_action_information

5436: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
5437: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
5438: )
5439: THEN
5440: pay_action_information_api.create_action_information
5441: (p_action_context_id => l_arch_asg_action_id
5442: ,p_action_context_type => 'AAP'
5443: ,p_action_information_category => 'IN_24QC_SALARY'
5444: ,p_source_id => l_max_pact

Line 5470: pay_action_information_api.create_action_information

5466:
5467: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_prev_pay) AND (l_flag1=0))
5468: THEN
5469:
5470: pay_action_information_api.create_action_information
5471: (p_action_context_id => l_arch_asg_action_id
5472: ,p_action_context_type => 'AAP'
5473: ,p_action_information_category => 'IN_24QC_PERSON'
5474: ,p_source_id => l_max_pact

Line 5500: pay_action_information_api.create_action_information

5496: (tab_24q_ba_data(l).balance_value <> 0)
5497: )
5498: THEN
5499:
5500: pay_action_information_api.create_action_information
5501: (p_action_context_id => l_arch_asg_action_id
5502: ,p_action_context_type => 'AAP'
5503: ,p_action_information_category => 'IN_24QC_SALARY'
5504: ,p_source_id => l_max_pact

Line 5674: pay_action_information_api.create_action_information

5670: pay_in_utils.trace('Addition Assignment ID : ', g_sal_data_rec_add(i).assignment_id );
5671:
5672: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_flag1=0) AND (l_prev_c5))
5673: THEN
5674: pay_action_information_api.create_action_information
5675: (p_action_context_id => l_arch_asg_action_id
5676: ,p_action_context_type => 'AAP'
5677: ,p_action_information_category => 'IN_24QC_PERSON'
5678: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5704: pay_action_information_api.create_action_information

5700: (tab_24q_ba_data(l).balance_value <> 0)
5701: )
5702: THEN
5703:
5704: pay_action_information_api.create_action_information
5705: (p_action_context_id => l_arch_asg_action_id
5706: ,p_action_context_type => 'AAP'
5707: ,p_action_information_category => 'IN_24QC_SALARY'
5708: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5736: pay_action_information_api.create_action_information

5732: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
5733: AND ((l_c5_change_only=FALSE)) AND (g_quarter IN ('Q4') AND (l_flag=0))
5734: THEN
5735:
5736: pay_action_information_api.create_action_information
5737: (p_action_context_id => l_arch_asg_action_id
5738: ,p_action_context_type => 'AAP'
5739: ,p_action_information_category => 'IN_24QC_PERSON'
5740: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5765: pay_action_information_api.create_action_information

5761: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
5762: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
5763: )
5764: THEN
5765: pay_action_information_api.create_action_information
5766: (p_action_context_id => l_arch_asg_action_id
5767: ,p_action_context_type => 'AAP'
5768: ,p_action_information_category => 'IN_24QC_VIA'
5769: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5780: pay_action_information_api.create_action_information

5776: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
5777: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
5778: )
5779: THEN
5780: pay_action_information_api.create_action_information
5781: (p_action_context_id => l_arch_asg_action_id
5782: ,p_action_context_type => 'AAP'
5783: ,p_action_information_category => 'IN_24QC_SALARY'
5784: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5843: pay_action_information_api.create_action_information

5839: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
5840: AND ((l_c5_change_only=FALSE)) AND (l_future_pay=TRUE) AND ((j>0) OR (j IS NULL)) AND (g_quarter IN ('Q4') AND (l_flag2=0))
5841: THEN
5842:
5843: pay_action_information_api.create_action_information
5844: (p_action_context_id => l_arch_asg_action_id
5845: ,p_action_context_type => 'AAP'
5846: ,p_action_information_category => 'IN_24QC_PERSON'
5847: ,p_source_id => l_prev_max_pact

Line 5875: pay_action_information_api.create_action_information

5871:
5872: IF ((l_prev_asg_action_id IS NOT NULL) AND (l_balance_value <> 0))
5873: THEN
5874:
5875: pay_action_information_api.create_action_information
5876: (p_action_context_id => l_arch_asg_action_id
5877: ,p_action_context_type => 'AAP'
5878: ,p_action_information_category => 'IN_24QC_SALARY'
5879: ,p_source_id => l_prev_max_pact

Line 5902: pay_action_information_api.create_action_information

5898: CLOSE c_get_bal_24q;
5899:
5900: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0))
5901: THEN
5902: pay_action_information_api.create_action_information
5903: (p_action_context_id => l_arch_asg_action_id
5904: ,p_action_context_type => 'AAP'
5905: ,p_action_information_category => 'IN_24QC_SALARY'
5906: ,p_source_id => l_prev_max_pact

Line 6048: pay_action_information_api.create_action_information

6044:
6045: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_flag1=0) AND (l_future_pay=TRUE))
6046: THEN
6047:
6048: pay_action_information_api.create_action_information
6049: (p_action_context_id => l_arch_asg_action_id
6050: ,p_action_context_type => 'AAP'
6051: ,p_action_information_category => 'IN_24QC_PERSON'
6052: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6078: pay_action_information_api.create_action_information

6074: (tab_24q_ba_data(l).balance_value <> 0)
6075: )
6076: THEN
6077:
6078: pay_action_information_api.create_action_information
6079: (p_action_context_id => l_arch_asg_action_id
6080: ,p_action_context_type => 'AAP'
6081: ,p_action_information_category => 'IN_24QC_SALARY'
6082: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6098: pay_action_information_api.create_action_information

6094: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
6095: AND (l_c5_change_only=FALSE) AND (g_quarter IN ('Q4') AND (l_flag2 = 0))
6096: THEN
6097:
6098: pay_action_information_api.create_action_information
6099: (p_action_context_id => l_arch_asg_action_id
6100: ,p_action_context_type => 'AAP'
6101: ,p_action_information_category => 'IN_24QC_PERSON'
6102: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6130: pay_action_information_api.create_action_information

6126: (tab_24q_ba_data(l).balance_value <> 0)
6127: )
6128: THEN
6129:
6130: pay_action_information_api.create_action_information
6131: (p_action_context_id => l_arch_asg_action_id
6132: ,p_action_context_type => 'AAP'
6133: ,p_action_information_category => 'IN_24QC_SALARY'
6134: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6158: pay_action_information_api.create_action_information

6154: FETCH c_get_bal_24q INTO l_balance_value;
6155: CLOSE c_get_bal_24q;
6156:
6157: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0)) THEN
6158: pay_action_information_api.create_action_information
6159: (p_action_context_id => l_arch_asg_action_id
6160: ,p_action_context_type => 'AAP'
6161: ,p_action_information_category => 'IN_24QC_SALARY'
6162: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6190: pay_action_information_api.create_action_information

6186: IF (INSTR(l_action_information_category,'C4')<> 0)AND(g_correction_mode IN ('%','C4'))
6187: AND (l_c5_change_only=FALSE) AND (g_quarter IN ('Q4') AND (l_flag = 0))
6188: THEN
6189:
6190: pay_action_information_api.create_action_information
6191: (p_action_context_id => l_arch_asg_action_id
6192: ,p_action_context_type => 'AAP'
6193: ,p_action_information_category => 'IN_24QC_PERSON'
6194: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6219: pay_action_information_api.create_action_information

6215: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
6216: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
6217: )
6218: THEN
6219: pay_action_information_api.create_action_information
6220: (p_action_context_id => l_arch_asg_action_id
6221: ,p_action_context_type => 'AAP'
6222: ,p_action_information_category => 'IN_24QC_VIA'
6223: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6234: pay_action_information_api.create_action_information

6230: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
6231: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
6232: )
6233: THEN
6234: pay_action_information_api.create_action_information
6235: (p_action_context_id => l_arch_asg_action_id
6236: ,p_action_context_type => 'AAP'
6237: ,p_action_information_category => 'IN_24QC_SALARY'
6238: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6289: FROM pay_action_information pai

6285: CURSOR c_c5_correction_type_details(p_last_arc_asg_action_id NUMBER)
6286: IS
6287: SELECT pai.action_information_category
6288: ,pai.action_context_id
6289: FROM pay_action_information pai
6290: ,pay_assignment_actions paa
6291: WHERE paa.assignment_action_id = p_last_arc_asg_action_id
6292: AND pai.action_context_id = paa.payroll_action_id
6293: AND pai.action_context_type = 'PA'

Line 6301: FROM pay_action_information pai

6297: ,p_element_entry_id NUMBER
6298: )
6299: IS
6300: SELECT action_information25
6301: FROM pay_action_information pai
6302: ,pay_assignment_actions paa
6303: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
6304: AND pai.action_information3 = g_gre_id
6305: AND pai.action_information1 = p_challan_number

Line 6315: FROM pay_action_information pai

6311: ,p_element_entry_id NUMBER
6312: )
6313: IS
6314: SELECT action_information25
6315: FROM pay_action_information pai
6316: ,pay_assignment_actions paa
6317: ,pay_action_interlocks locks
6318: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
6319: AND pai.action_information3 = g_gre_id

Line 6331: FROM pay_action_information pai

6327:
6328: CURSOR c_max_challan_number_24qc(p_challan_number VARCHAR2)
6329: IS
6330: SELECT MAX(TO_NUMBER(action_information25))
6331: FROM pay_action_information pai
6332: ,pay_assignment_actions paa
6333: ,pay_action_interlocks locks
6334: ,pay_assignment_actions paa_master
6335: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 6357: FROM pay_action_information pai

6353:
6354: CURSOR c_max_challan_number_24q(p_challan_number VARCHAR2)
6355: IS
6356: SELECT MAX(TO_NUMBER(action_information25))
6357: FROM pay_action_information pai
6358: ,pay_assignment_actions paa
6359: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
6360: AND pai.action_information3 = g_gre_id
6361: AND pai.action_information1 = p_challan_number

Line 6387: l_action_information_category pay_action_information.action_information_category%TYPE;

6383: tab_liv_ee_data t_screen_entry_value_rec;
6384: tab_24q_pe_data t_person_data_rec;
6385: tab_liv_pe_data t_person_data_rec;
6386:
6387: l_action_information_category pay_action_information.action_information_category%TYPE;
6388: l_action_context_id NUMBER;
6389: l_deductee_detail NUMBER;
6390: l_arch_asg_action_id NUMBER;
6391: l_action_info_id NUMBER;

Line 6399: l_category pay_action_information.action_information_category%TYPE;

6395: s NUMBER;
6396: l_dummy NUMBER := -1;
6397: l_flag NUMBER := -1;
6398: l_c5_change BOOLEAN;
6399: l_category pay_action_information.action_information_category%TYPE;
6400: l_procedure VARCHAR2(250);
6401: l_message VARCHAR2(250);
6402: BEGIN
6403: g_debug := hr_utility.debug_enabled;

Line 6472: pay_action_information_api.create_action_information

6468: ,INSTR(l_action_information_category,'G')
6469: );
6470: l_category := l_category || 'C5';
6471:
6472: pay_action_information_api.create_action_information
6473: (p_action_context_id => l_arch_asg_action_id
6474: ,p_action_context_type => 'AAP'
6475: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6476: ,p_source_id => g_ee_data_rec_del(i).element_entry_id

Line 6516: pay_action_information_api.create_action_information

6512: ,INSTR(l_action_information_category,'G')
6513: );
6514: l_category := l_category || 'C3';
6515:
6516: pay_action_information_api.create_action_information
6517: (p_action_context_id => l_arch_asg_action_id
6518: ,p_action_context_type => 'AAP'
6519: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6520: ,p_source_id => g_ee_data_rec_del(i).element_entry_id

Line 6610: pay_action_information_api.create_action_information

6606: FETCH c_max_challan_number_24qc INTO j;
6607: CLOSE c_max_challan_number_24qc;
6608: pay_in_utils.set_location(g_debug,'Number found is ' || j, 2);
6609:
6610: pay_action_information_api.create_action_information
6611: (p_action_context_id => l_arch_asg_action_id
6612: ,p_action_context_type => 'AAP'
6613: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6614: ,p_source_id => g_ee_data_rec_add(i).element_entry_id

Line 6750: pay_action_information_api.create_action_information

6746: ,INSTR(l_action_information_category,'G')
6747: );
6748: l_category := l_category || 'C5';
6749:
6750: pay_action_information_api.create_action_information
6751: (p_action_context_id => l_arch_asg_action_id
6752: ,p_action_context_type => 'AAP'
6753: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6754: ,p_source_id => g_ee_data_rec_upd(i).element_entry_id

Line 6795: pay_action_information_api.create_action_information

6791: ,INSTR(l_action_information_category,'G')
6792: );
6793: l_category := l_category || 'C3';
6794:
6795: pay_action_information_api.create_action_information
6796: (p_action_context_id => l_arch_asg_action_id
6797: ,p_action_context_type => 'AAP'
6798: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6799: ,p_source_id => g_ee_data_rec_upd(i).element_entry_id

Line 6866: FROM pay_action_information

6862: ,action_information14
6863: ,action_information17
6864: ,action_information25
6865: ,action_information_id
6866: FROM pay_action_information
6867: WHERE action_context_type = 'PA'
6868: AND action_information_category = 'IN_24QC_CHALLAN'
6869: AND action_information15 = p_24qa_pay_act_id
6870: AND action_information1 = p_transfer_voucher_number

Line 6893: FROM pay_action_information pai

6889: + NVL(action_information8,0)
6890: + NVL(action_information9,0)
6891: + NVL(action_information10,0)
6892: ,action_information25
6893: FROM pay_action_information pai
6894: WHERE pai.action_context_type = 'PA'
6895: AND pai.action_information_category = 'IN_24Q_CHALLAN'
6896: AND pai.action_context_id = p_24qa_pay_act_id
6897: AND pai.action_information1 = p_transfer_voucher_number

Line 7036: pay_action_information_api.create_action_information

7032: pay_in_utils.set_location(g_debug,'l_challan_deductee_no '|| l_challan_deductee_no ,3);
7033: pay_in_utils.set_location(g_debug,'l_action_information_id '|| l_action_information_id ,3);
7034: END IF;
7035: -- Now Archive these details
7036: pay_action_information_api.create_action_information
7037: (p_action_context_id => p_24qc_pay_act_id
7038: ,p_action_context_type => 'PA'
7039: ,p_action_information_category => 'IN_24QC_CHALLAN'
7040: ,p_source_id => g_challan_data_noc(i).org_information_id

Line 7159: FROM pay_action_information

7155: pay_in_utils.set_location(g_debug,'Fetching Challan Data ', 1);
7156: BEGIN
7157: SELECT MAX(TO_NUMBER(action_information25))
7158: INTO j
7159: FROM pay_action_information
7160: WHERE action_information_category = 'IN_24Q_CHALLAN'
7161: AND action_information3 = g_gre_id
7162: AND action_information2 = g_year||g_quarter
7163: AND action_context_id = p_24qa_pay_act_id

Line 7178: FROM pay_action_information

7174:
7175: pay_in_utils.set_location(g_debug,'Addition:Value of j is : '|| j ,1);
7176: SELECT MAX(TO_NUMBER(action_information25))
7177: INTO k
7178: FROM pay_action_information
7179: WHERE action_information_category = 'IN_24QC_CHALLAN'
7180: AND action_information3 = g_gre_id
7181: AND action_information2 = g_year||g_quarter
7182: AND action_information15 = p_24qa_pay_act_id

Line 7232: pay_action_information_api.create_action_information

7228: CLOSE c_challan_live_data;
7229: pay_in_utils.set_location(g_debug,'Fetched Live Data ' ,1);
7230:
7231: pay_in_utils.set_location(g_debug,'Archiving Data ' ,1);
7232: pay_action_information_api.create_action_information
7233: (p_action_context_id => p_24qc_pay_act_id
7234: ,p_action_context_type => 'PA'
7235: ,p_action_information_category => 'IN_24QC_CHALLAN'
7236: ,p_source_id => g_challan_data_add(i).org_information_id

Line 7283: FROM pay_action_information

7279: k := -1;
7280: BEGIN
7281: SELECT DISTINCT action_information25
7282: INTO j
7283: FROM pay_action_information
7284: WHERE action_information_category = 'IN_24Q_CHALLAN'
7285: AND action_information3 = g_gre_id
7286: AND action_information2 = g_year||g_quarter
7287: AND action_context_id = p_24qa_pay_act_id

Line 7311: FROM pay_action_information

7307:
7308: BEGIN
7309: SELECT DISTINCT action_information25
7310: INTO k
7311: FROM pay_action_information
7312: WHERE action_information_category = 'IN_24QC_CHALLAN'
7313: AND action_information3 = g_gre_id
7314: AND action_information2 = g_year||g_quarter
7315: AND action_context_id = p_24qa_pay_act_id

Line 7360: pay_action_information_api.create_action_information

7356: + NVL(g_challan_data_upd(i).education_cess,0)
7357: + NVL(g_challan_data_upd(i).interest,0)
7358: + NVL(g_challan_data_upd(i).other,0);
7359:
7360: pay_action_information_api.create_action_information
7361: (p_action_context_id => p_24qc_pay_act_id
7362: ,p_action_context_type => 'PA'
7363: ,p_action_information_category => 'IN_24QC_CHALLAN'
7364: ,p_source_id => l_org_information_id

Line 7436: FROM pay_action_information

7432: IS
7433: SELECT action_information2
7434: ,action_information5
7435: ,action_information7
7436: FROM pay_action_information
7437: WHERE action_context_id = p_action_context_id
7438: AND action_information_category LIKE 'IN_24Q%ORG'
7439: AND action_context_type = 'PA';
7440:

Line 7476: pay_action_information_api.create_action_information

7472: pay_in_utils.set_location(g_debug,'Deductor Type is : ' || l_deductor_type,9);
7473:
7474: pay_in_utils.set_location(g_debug,'Archiving Data ', 9);
7475:
7476: pay_action_information_api.create_action_information
7477: (p_action_context_id => p_payroll_action_id
7478: ,p_action_context_type => 'PA'
7479: ,p_action_information_category => 'IN_24QC_ORG'
7480: ,p_source_id => l_action_context_id

Line 7543: FROM pay_action_information

7539: SELECT action_information5 legal_name
7540: ,action_information7 deductor_type
7541: ,1 BUI
7542: ,action_context_id
7543: FROM pay_action_information
7544: WHERE action_information_category IN ('IN_24Q_ORG','IN_24QC_ORG')
7545: AND action_context_id = p_last_act_cxt_id
7546: AND action_context_type = 'PA'
7547: AND action_information1 = g_gre_id

Line 7555: FROM pay_action_information

7551:
7552: CURSOR c_24qa_nil_challan_indicator(p_tan_number VARCHAR2)
7553: IS
7554: SELECT action_information26
7555: FROM pay_action_information
7556: WHERE action_information_category = 'IN_24Q_ORG'
7557: AND action_context_id = p_24qa_pay_act_id
7558: AND action_context_type = 'PA'
7559: AND action_information1 = g_gre_id

Line 7634: pay_action_information_api.create_action_information

7630: ELSE
7631: l_new_nil_challan := 'Y';
7632: END IF;
7633:
7634: pay_action_information_api.create_action_information
7635: (p_action_context_id => p_24qc_pay_act_id
7636: ,p_action_context_type => 'PA'
7637: ,p_action_information_category => 'IN_24QC_ORG'
7638: ,p_source_id => p_24qa_pay_act_id

Line 7703: pay_action_information_api.create_action_information

7699:
7700: pay_in_utils.set_location(g_debug,'Archiving Data ',7);
7701: pay_in_utils.set_location(g_debug,'Address Change is '|| g_24qc_empr_change , 2);
7702:
7703: pay_action_information_api.create_action_information
7704: (p_action_context_id => p_24qc_pay_act_id
7705: ,p_action_context_type => 'PA'
7706: ,p_action_information_category => 'IN_24QC_ORG'
7707: ,p_source_id => p_24qa_pay_act_id

Line 7761: FROM pay_action_information

7757: IS
7758: CURSOR c_24q_per_check
7759: IS
7760: SELECT 1
7761: FROM pay_action_information
7762: WHERE action_information_category = 'IN_24Q_PERSON'
7763: AND action_context_id = p_assignment_act_id
7764: AND action_information3 = g_gre_id;
7765:

Line 7769: FROM pay_action_information

7765:
7766: CURSOR c_24qc_ded_check
7767: IS
7768: SELECT 1
7769: FROM pay_action_information
7770: WHERE action_information_category = 'IN_24QC_DEDUCTEE'
7771: AND action_context_id = p_assignment_act_id
7772: AND action_information3 = g_gre_id;
7773:

Line 8042: FROM pay_action_information pai

8038: IS
8039: CURSOR c_select_deductee
8040: IS
8041: SELECT DISTINCT pai.action_information1 challan
8042: FROM pay_action_information pai
8043: ,pay_assignment_actions paa
8044: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
8045: AND paa.assignment_action_id = pai.action_context_id
8046: AND paa.payroll_action_id = p_payroll_action_id

Line 8053: FROM pay_action_information pai

8049:
8050: CURSOR c_challan_sequence(p_challan_number VARCHAR2)
8051: IS
8052: SELECT pai.action_information25 challan_seq
8053: FROM pay_action_information pai
8054: WHERE pai.action_information_category IN ('IN_24QC_CHALLAN','IN_24Q_CHALLAN')
8055: AND pai.action_information1 = p_challan_number
8056: AND pai.action_context_id IN
8057: (

Line 8074: FROM pay_action_information

8070: IS
8071: SELECT action_information2 tan_number
8072: ,action_information5 legal_name
8073: ,action_information7 deductor_type
8074: FROM pay_action_information
8075: WHERE action_information_category IN ('IN_24Q_ORG','IN_24QC_ORG')
8076: AND action_context_id = p_last_act_cxt_id
8077: AND action_context_type = 'PA'
8078: AND action_information1 = g_gre_id

Line 8125: pay_action_information_api.create_action_information

8121: l_flag_number := -1;
8122: l_flag_number := check_archival_status(NULL,'IN_24QC_CHALLAN',g_challan_data_upd(i).transfer_voucher_number,NULL);
8123: IF((g_challan_data_upd(i).transfer_voucher_number = c_rec.challan)AND(l_flag_number = 0))
8124: THEN
8125: pay_action_information_api.create_action_information
8126: (p_action_context_id => p_payroll_action_id
8127: ,p_action_context_type => 'PA'
8128: ,p_action_information_category => 'IN_24QC_CHALLAN'
8129: ,p_source_id => g_challan_data_upd(i).org_information_id

Line 8158: pay_action_information_api.create_action_information

8154: l_flag_number := -1;
8155: l_flag_number := check_archival_status(NULL,'IN_24QC_CHALLAN',g_challan_data_noc(i).transfer_voucher_number,NULL);
8156: IF((g_challan_data_noc(i).transfer_voucher_number = c_rec.challan)AND(l_flag_number =0))
8157: THEN
8158: pay_action_information_api.create_action_information
8159: (p_action_context_id => p_payroll_action_id
8160: ,p_action_context_type => 'PA'
8161: ,p_action_information_category => 'IN_24QC_CHALLAN'
8162: ,p_source_id => g_challan_data_noc(i).org_information_id

Line 8223: pay_action_information_api.create_action_information

8219: pay_in_utils.set_location(g_debug,'p_payroll_action_id is '|| p_payroll_action_id, 10);
8220: l_action_info_id := NULL;
8221: l_ovn := NULL;
8222:
8223: pay_action_information_api.create_action_information
8224: (p_action_context_id => p_payroll_action_id
8225: ,p_action_context_type => 'PA'
8226: ,p_action_information_category => 'IN_24QC_ORG'
8227: ,p_action_information1 => g_gre_id

Line 8333: FROM pay_action_information

8329:
8330: CURSOR c_source_id(p_pay_act_id_last_24Q NUMBER)
8331: IS
8332: SELECT source_id
8333: FROM pay_action_information
8334: WHERE action_context_id = p_pay_act_id_last_24Q
8335: AND action_information_category = 'IN_24QC_ORG'
8336: AND action_context_type = 'PA'
8337: AND action_information3 = g_year||g_quarter;

Line 8342: FROM pay_action_information pai

8338:
8339: CURSOR c_act_category(p_pay_act_id_last_24Q NUMBER)
8340: IS
8341: SELECT DECODE(pai.action_information_category,'IN_24Q_ORG',1,2)
8342: FROM pay_action_information pai
8343: WHERE pai.action_information_category IN ('IN_24QC_ORG','IN_24Q_ORG')
8344: AND pai.action_context_id = p_pay_act_id_last_24Q
8345: AND pai.action_context_type = 'PA'
8346: AND pai.action_information3 = g_year||g_quarter

Line 9285: FROM pay_action_information

9281: SELECT DECODE(action_information15, 1, 'C1')
9282: ,action_information_id
9283: ,object_version_number
9284: ,action_information29
9285: FROM pay_action_information
9286: WHERE action_information1 = g_gre_id
9287: AND action_information3 = g_year||g_quarter
9288: AND action_context_type = 'PA'
9289: AND action_information_category = 'IN_24QC_ORG'

Line 9298: FROM pay_action_information

9294: SELECT action_information1 challan
9295: ,DECODE(action_information18, 'U', 'C2', 'A', 'C9', 'NC', null) correction_type
9296: ,action_information_id
9297: ,object_version_number
9298: FROM pay_action_information
9299: WHERE action_information3 = g_gre_id
9300: AND action_information2 = g_year||g_quarter
9301: AND action_context_type = 'PA'
9302: AND action_information_category = 'IN_24QC_CHALLAN'

Line 9309: FROM pay_action_information pai

9305: CURSOR cur_deductee_recs(p_payroll_action_id NUMBER
9306: ,p_challan_number VARCHAR2)
9307: IS
9308: SELECT 'C3' correction_type
9309: FROM pay_action_information pai
9310: WHERE pai.action_context_id IN (SELECT assignment_action_id
9311: FROM pay_assignment_actions
9312: WHERE payroll_action_id = p_payroll_action_id
9313: AND assignment_id = pai.assignment_id

Line 9334: FROM pay_action_information pai

9330: CURSOR cur_c5_deductee_recs(p_payroll_action_id NUMBER
9331: ,p_challan_number VARCHAR2)
9332: IS
9333: SELECT 'C5' correction_type
9334: FROM pay_action_information pai
9335: WHERE pai.action_context_id IN ( SELECT assignment_action_id
9336: FROM pay_assignment_actions
9337: WHERE payroll_action_id = p_payroll_action_id
9338: AND assignment_id = pai.assignment_id

Line 9352: FROM pay_action_information pai

9348: CURSOR cur_c5_salary_recs(p_payroll_action_id NUMBER
9349: ,p_person_id NUMBER)
9350: IS
9351: SELECT 'C5' correction_type
9352: FROM pay_action_information pai
9353: WHERE pai.action_context_id IN ( SELECT assignment_action_id
9354: FROM pay_assignment_actions
9355: WHERE payroll_action_id = p_payroll_action_id
9356: AND assignment_id = pai.assignment_id

Line 9369: FROM pay_action_information pai

9365: CURSOR cur_c4_salary_recs(p_payroll_action_id NUMBER
9366: ,p_person_id NUMBER)
9367: IS
9368: SELECT 'C4' correction_type
9369: FROM pay_action_information pai
9370: WHERE pai.action_context_id IN ( SELECT assignment_action_id
9371: FROM pay_assignment_actions
9372: WHERE payroll_action_id = p_payroll_action_id
9373: AND assignment_id = pai.assignment_id

Line 9385: FROM pay_action_information

9381:
9382: CURSOR cur_salary_update_recs
9383: IS
9384: SELECT DISTINCT action_information3 gre_id
9385: FROM pay_action_information
9386: WHERE action_information_category = 'IN_24QC_PERSON'
9387: AND action_context_type = 'AAP'
9388: AND action_information10 = 'A'
9389: AND action_information11 = 'C4'

Line 9402: FROM pay_action_information

9398: SELECT DISTINCT action_information1 person_id
9399: , source_id
9400: , action_information_id
9401: , object_version_number
9402: FROM pay_action_information
9403: WHERE action_information_category = 'IN_24QC_PERSON'
9404: AND action_context_type = 'AAP'
9405: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9406: AND action_information10 = 'A'

Line 9418: FROM pay_action_information

9414:
9415: CURSOR cur_min_salary_record( p_gre_id VARCHAR2)
9416: IS
9417: SELECT MIN(fnd_number.canonical_to_number(action_information12)) min_salary_rec
9418: FROM pay_action_information
9419: WHERE action_information_category = 'IN_24QC_PERSON'
9420: AND action_context_type = 'AAP'
9421: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9422: AND action_information10 = 'A'

Line 9432: FROM pay_action_information pai

9428:
9429: CURSOR cur_salary_recs(p_payroll_action_id NUMBER)
9430: IS
9431: SELECT DISTINCT action_information1 person_id
9432: FROM pay_action_information pai
9433: WHERE action_information_category = 'IN_24QC_PERSON'
9434: AND action_context_type = 'AAP'
9435: AND action_context_id IN (SELECT assignment_action_id
9436: FROM pay_assignment_actions

Line 9447: FROM pay_action_information pai

9443: ,p_24q_pay_action_id NUMBER
9444: )
9445: IS
9446: SELECT SUM(NVL(pai.action_information9,0)) amount_deposited
9447: FROM pay_action_information pai
9448: ,pay_assignment_actions paa
9449: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
9450: AND paa.assignment_action_id = pai.action_context_id
9451: AND pai.action_information1 = p_challan_number

Line 9525: pay_action_information_api.update_action_information

9521: END IF;
9522: END IF;
9523:
9524: pay_in_utils.set_location(g_debug,'Updating API called for Challan ', 3);
9525: pay_action_information_api.update_action_information
9526: (p_validate => FALSE
9527: ,p_action_information_id => t_challan_nos(l_index).action_information_id
9528: ,p_object_version_number => t_challan_nos(l_index).object_version_number
9529: ,p_action_information29 => t_challan_nos(l_index).correction_type

Line 9552: pay_action_information_api.update_action_information

9548: pay_in_utils.set_location(g_debug,'c_salary_rec.gre_id...',c_salary_rec.gre_id);
9549:
9550: FOR cur_rec IN cur_person_update_recs(c_salary_rec.gre_id)
9551: LOOP
9552: pay_action_information_api.update_action_information
9553: (p_validate => FALSE
9554: ,p_action_information_id => cur_rec.action_information_id
9555: ,p_object_version_number => cur_rec.object_version_number
9556: ,p_action_information12 => l_index

Line 9628: pay_action_information_api.update_action_information

9624: END IF;
9625:
9626:
9627: pay_in_utils.set_location(g_debug,'Updating API called for Org ', 3);
9628: pay_action_information_api.update_action_information
9629: (p_validate => FALSE
9630: ,p_action_information_id => l_action_info_id
9631: ,p_object_version_number => l_ovn
9632: ,p_action_information29 => org_correction_type