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 458: FROM pay_action_information

454: ,p_last_act_cxt_id NUMBER
455: )
456: IS
457: SELECT DECODE(action_information_category,'IN_24Q_ORG',action_information21,action_information7) deductor_type
458: FROM pay_action_information
459: WHERE action_information_category IN ('IN_24Q_ORG','IN_24QC_ORG')
460: AND action_context_id = p_last_act_cxt_id
461: AND action_context_type = 'PA'
462: AND action_information1 = g_gre_id

Line 717: FROM pay_action_information pai

713: ,p_24q_pay_action_id NUMBER
714: )
715: IS
716: SELECT SUM(NVL(pai.action_information9,0)) amount_deposited
717: FROM pay_action_information pai
718: ,pay_assignment_actions paa
719: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
720: AND paa.assignment_action_id = pai.action_context_id
721: AND pai.action_information1 = p_challan_number

Line 789: FROM pay_action_information pai

785: CURSOR check_ee
786: IS
787: SELECT pai.action_information1
788: ,MAX(pai.action_context_id)
789: FROM pay_action_information pai
790: ,pay_action_interlocks locks
791: ,pay_assignment_actions paa
792: ,pay_assignment_actions paa_24qc
793: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 865: FROM pay_action_information pai

861: IS
862: SELECT pai.source_id element_entry_id
863: ,pai.assignment_id assignment_id
864: ,pai.action_context_id last_action_context_id
865: FROM pay_action_information pai
866: ,pay_assignment_actions paa
867: WHERE pai.action_information_category LIKE 'IN_24Q%_DEDUCTEE'
868: AND pai.action_context_id = paa.assignment_action_id
869: AND(

Line 899: FROM pay_action_information pai

895: )
896: AND (
897: pai.source_id NOT IN
898: (SELECT pai.source_id
899: FROM pay_action_information pai
900: ,pay_action_interlocks locks
901: ,pay_assignment_actions paa
902: ,pay_assignment_actions masters
903: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 926: FROM pay_action_information pai

922: OR
923: pay_in_utils.get_ee_value(pai.source_id,'Challan or Voucher Number') NOT IN
924: (
925: (SELECT pai.action_information1
926: FROM pay_action_information pai
927: ,pay_action_interlocks locks
928: ,pay_assignment_actions paa
929: ,pay_assignment_actions masters
930: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 968: FROM pay_action_information pai

964: AND entry.effective_start_date BETWEEN g_qr_start_date AND g_qr_end_date
965: AND (
966: entry.element_entry_id NOT IN
967: (SELECT pai.source_id
968: FROM pay_action_information pai
969: ,pay_assignment_actions paa
970: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
971: AND pai.action_context_id = paa.assignment_action_id
972: AND paa.payroll_action_id = p_payroll_action_id

Line 977: FROM pay_action_information pai

973: )
974: OR
975: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') NOT IN
976: (SELECT pai.action_information1
977: FROM pay_action_information pai
978: ,pay_assignment_actions paa
979: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
980: AND pai.action_context_id = paa.assignment_action_id
981: AND paa.payroll_action_id = p_payroll_action_id

Line 988: FROM pay_action_information pai

984: )
985: AND (
986: entry.element_entry_id NOT IN
987: (SELECT pai.source_id
988: FROM pay_action_information pai
989: ,pay_action_interlocks locks
990: ,pay_assignment_actions paa
991: ,pay_assignment_actions paa_24qc
992: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 1015: FROM pay_action_information pai

1011: OR
1012: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') NOT IN
1013: (
1014: (SELECT pai.action_information1
1015: FROM pay_action_information pai
1016: ,pay_action_interlocks locks
1017: ,pay_assignment_actions paa
1018: ,pay_assignment_actions paa_24qc
1019: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 1074: FROM pay_action_information

1070: AND
1071: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
1072: (
1073: SELECT action_information1
1074: FROM pay_action_information
1075: WHERE action_information_category IN('IN_24QC_CHALLAN','IN_24Q_CHALLAN')
1076: AND (
1077: action_information15 = p_payroll_action_id
1078: AND action_information_category = 'IN_24QC_CHALLAN'

Line 1122: FROM pay_action_information

1118: AND
1119: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') NOT IN
1120: (
1121: SELECT action_information1
1122: FROM pay_action_information
1123: WHERE action_information_category IN('IN_24QC_CHALLAN','IN_24Q_CHALLAN')
1124: AND (
1125: action_information15 = p_payroll_action_id
1126: AND action_information_category = 'IN_24QC_CHALLAN'

Line 1172: FROM pay_action_information pai

1168: SELECT pai.source_id element_entry_id
1169: ,pai.assignment_id assignment_id
1170: ,pai.action_context_id last_action_context_id
1171: ,pep.effective_end_date
1172: FROM pay_action_information pai
1173: ,pay_assignment_actions paa
1174: ,per_people_f pep
1175: ,per_assignments_f asg
1176: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'

Line 1239: FROM pay_action_information pai_locking

1235: ,p_mode VARCHAR2
1236: )
1237: IS
1238: SELECT pai_locking.action_context_id last_action_context_id
1239: FROM pay_action_information pai_locking
1240: ,pay_action_interlocks locks
1241: ,pay_assignment_actions paa
1242: WHERE pai_locking.action_information_category = 'IN_24QC_DEDUCTEE'
1243: AND pai_locking.action_information3 = g_gre_id

Line 1268: FROM pay_action_information pai

1264: ,p_element_entry_id NUMBER
1265: )
1266: IS
1267: SELECT pai.action_context_id
1268: FROM pay_action_information pai
1269: ,per_people_f pep
1270: ,per_assignments_f asg
1271: ,pay_assignment_actions paa
1272: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 1338: FROM pay_action_information pai

1334: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date
1335: AND NOT EXISTS
1336: (
1337: SELECT 1
1338: FROM pay_action_information pai
1339: ,per_people_f pep
1340: ,per_assignments_f asg
1341: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1342: AND pai.source_id = p_element_entry_id

Line 1401: FROM pay_action_information pai

1397: IS
1398: SELECT MAX(pai.action_context_id) last_action_context_id
1399: ,pai.source_id element_entry_id
1400: ,pai.assignment_id assignment_id
1401: FROM pay_action_information pai
1402: ,pay_assignment_actions paa
1403: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1404: AND pai.action_information3 = g_gre_id
1405: AND pai.action_information2 = g_year||g_quarter

Line 1425: FROM pay_action_information pai

1421: OR
1422: (
1423: pai.source_id NOT IN(
1424: SELECT pai.source_id
1425: FROM pay_action_information pai
1426: ,pay_assignment_actions paa
1427: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1428: AND pai.action_information3 = g_gre_id
1429: AND pai.action_information2 = g_year||g_quarter

Line 1770: FROM pay_action_information

1766: RETURN VARCHAR2 IS
1767:
1768: CURSOR c_form24Q_values IS
1769: SELECT NVL(action_information2,0)
1770: FROM pay_action_information
1771: WHERE action_information_category = p_category
1772: AND action_information1 = p_component_name
1773: AND action_context_id = p_context_id
1774: AND source_id = p_source_id;

Line 1843: FROM pay_action_information pai

1839: IS
1840: SELECT pai.source_id source_id
1841: ,pai.assignment_id assignment_id
1842: ,pai.action_context_id last_action_context_id
1843: FROM pay_action_information pai
1844: ,pay_assignment_actions paa
1845: WHERE pai.action_information_category LIKE 'IN_24Q%_PERSON'
1846: AND fnd_number.canonical_to_number(pai.action_information1)
1847: BETWEEN p_start_person AND p_end_person

Line 1901: FROM pay_action_information pai

1897: )
1898: AND (
1899: pai.source_id NOT IN
1900: (SELECT pai.source_id
1901: FROM pay_action_information pai
1902: ,pay_action_interlocks locks
1903: ,pay_assignment_actions paa
1904: ,pay_assignment_actions masters
1905: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 1964: FROM pay_action_information pai

1960: GROUP BY paf.assignment_id) a
1961: WHERE (
1962: a.source_id NOT IN
1963: (SELECT pai.source_id
1964: FROM pay_action_information pai
1965: ,pay_assignment_actions paa
1966: WHERE pai.action_information_category = 'IN_24Q_PERSON'
1967: AND pai.action_context_id = paa.assignment_action_id
1968: AND paa.payroll_action_id = p_payroll_action_id

Line 1974: FROM pay_action_information pai

1970: )
1971: AND (
1972: a.source_id NOT IN
1973: (SELECT pai.source_id
1974: FROM pay_action_information pai
1975: ,pay_action_interlocks locks
1976: ,pay_assignment_actions paa
1977: ,pay_assignment_actions paa_24qc
1978: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 2001: FROM pay_action_information pai

1997: )
1998: AND (
1999: a.source_id NOT IN
2000: (SELECT pai.source_id
2001: FROM pay_action_information pai
2002: ,pay_action_interlocks locks
2003: ,pay_assignment_actions paa
2004: ,pay_assignment_actions paa_24qc
2005: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 2028: FROM pay_action_information pai

2024: )
2025: AND (
2026: a.source_id NOT IN
2027: (SELECT pai.source_id
2028: FROM pay_action_information pai
2029: ,pay_assignment_actions paa_24qc
2030: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2031: AND pai.action_information3 = g_gre_id
2032: AND pai.action_information2 = g_year||g_quarter

Line 2058: FROM pay_action_information pai

2054: pai.source_id source_id
2055: ,pai.assignment_id assignment_id
2056: ,pai.action_context_id last_action_context_id
2057: ,pep.effective_end_date
2058: FROM pay_action_information pai
2059: ,pay_assignment_actions paa
2060: ,per_people_f pep
2061: ,per_assignments_f asg
2062: WHERE pai.action_information_category = 'IN_24Q_PERSON'

Line 2196: FROM pay_action_information pai_locking

2192: ,p_source_id NUMBER
2193: )
2194: IS
2195: SELECT pai_locking.action_context_id last_action_context_id
2196: FROM pay_action_information pai_locking
2197: ,pay_action_interlocks locks
2198: ,pay_assignment_actions paa
2199: WHERE pai_locking.action_information_category = 'IN_24QC_PERSON'
2200: AND fnd_number.canonical_to_number(pai_locking.action_information1)

Line 2226: FROM pay_action_information pai

2222: ,p_source_id NUMBER
2223: )
2224: IS
2225: SELECT pai.action_context_id
2226: FROM pay_action_information pai
2227: ,per_people_f pep
2228: ,per_assignments_f asg
2229: ,pay_assignment_actions paa
2230: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 2370: FROM pay_action_information pai

2366: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date
2367: AND NOT EXISTS
2368: (
2369: SELECT 1
2370: FROM pay_action_information pai
2371: ,per_people_f pep
2372: ,per_assignments_f asg
2373: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2374: AND fnd_number.canonical_to_number(pai.action_information1)

Line 2476: FROM pay_action_information pai

2472: IS
2473: SELECT MAX(pai.action_context_id) last_action_context_id
2474: ,pai.source_id source_id
2475: ,pai.assignment_id assignment_id
2476: FROM pay_action_information pai
2477: ,pay_assignment_actions paa
2478: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2479: AND fnd_number.canonical_to_number(pai.action_information1)
2480: BETWEEN p_start_person AND p_end_person

Line 2505: FROM pay_action_information pai

2501: OR
2502: (
2503: pai.source_id NOT IN(
2504: SELECT pai.source_id
2505: FROM pay_action_information pai
2506: ,pay_assignment_actions paa
2507: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2508: AND fnd_number.canonical_to_number(pai.action_information1)
2509: BETWEEN p_start_person AND p_end_person

Line 3033: FROM pay_action_information pai

3029: CURSOR c_locking_24qc_pa_data
3030: IS
3031: SELECT DISTINCT pai.action_context_id locking_id
3032: ,pai.action_information1 gre_id
3033: FROM pay_action_information pai
3034: WHERE pai.action_context_type = 'PA'
3035: AND pai.action_information_category = 'IN_24QC_ORG'
3036: AND pai.action_information1 = p_gre_id
3037: AND pai.action_information3 = g_year||g_quarter

Line 3056: FROM pay_action_information

3052: -- This cursor fetches the GREs that were reported in Form 24Q Archival
3053: CURSOR c_chk_organization
3054: IS
3055: SELECT action_information1 gre_id
3056: FROM pay_action_information
3057: WHERE action_information_category = 'IN_24Q_ORG'
3058: AND action_context_type = 'PA'
3059: AND action_information1 = p_gre_id
3060: AND action_information3 = g_year||g_quarter

Line 3085: FROM pay_action_information pai

3081: ,p_action_context_id NUMBER
3082: )
3083: IS
3084: SELECT pai.action_context_id last_action_context_id
3085: FROM pay_action_information pai
3086: WHERE pai.action_information_category = p_act_inf_category
3087: AND pai.action_context_type = 'PA'
3088: AND pai.action_context_id = p_action_context_id
3089: AND pai.action_information1 = p_gre_id

Line 3147: FROM pay_action_information pai

3143: ,p_ddo_reg_code VARCHAR2
3144: )
3145: IS
3146: SELECT pai.action_context_id last_action_context_id
3147: FROM pay_action_information pai
3148: WHERE pai.action_information_category = p_act_inf_category
3149: AND pai.action_context_type = 'PA'
3150: AND pai.action_context_id = p_action_context_id
3151: AND pai.action_information1 = p_gre_id

Line 3604: FROM pay_action_information

3600: action_information9 interest,
3601: action_information10 other,
3602: action_information11 cheque_dd_num,
3603: source_id org_information_id
3604: FROM pay_action_information
3605: WHERE action_information2 = g_year||g_quarter
3606: AND action_information3 = p_gre_id
3607: AND action_information_category = p_act_info_category
3608: AND action_context_id IN

Line 3654: FROM pay_action_information

3650: action_information9 interest,
3651: action_information10 other,
3652: action_information11 cheque_dd_num,
3653: source_id org_information_id
3654: FROM pay_action_information
3655: WHERE action_information2 = g_year||g_quarter
3656: AND action_information3 = p_gre_id
3657: AND action_information_category = p_act_info_category
3658: AND action_context_id IN

Line 4151: FROM pay_action_information pai

4147: DECODE(action_information_category,'IN_24Q_DEDUCTEE'
4148: ,action_information9,'IN_24QC_DEDUCTEE'
4149: ,action_information16) Amount_Deposited
4150: ,action_information_id
4151: FROM pay_action_information pai
4152: WHERE pai.action_context_id = p_action_context_id
4153: AND pai.action_information_category IN ('IN_24Q_DEDUCTEE','IN_24QC_DEDUCTEE')
4154: AND pai.assignment_id = p_assignment_id
4155: AND pai.source_id = p_element_entry_id

Line 4166: FROM pay_action_information

4162: ,action_information4 pan_number
4163: ,action_information5 pan_ref_number
4164: ,action_information6 full_name
4165: ,action_information_id
4166: FROM pay_action_information
4167: WHERE action_context_id = p_action_context_id
4168: AND action_context_type = 'AAP'
4169: AND action_information_category = 'IN_24Q_PERSON'
4170: AND assignment_id = p_assignment_id

Line 4178: FROM pay_action_information

4174:
4175: CURSOR c_get_tax_rate_from_24q
4176: IS
4177: SELECT action_information13 tax_rate
4178: FROM pay_action_information
4179: WHERE action_context_id = p_action_context_id
4180: AND action_context_type = 'AAP'
4181: AND action_information_category = 'IN_24Q_DEDUCTEE'
4182: AND assignment_id = p_assignment_id

Line 4194: FROM pay_action_information

4190: ,action_information11 pan_ref_number
4191: ,action_information18 tax_rate
4192: ,action_information10 full_name
4193: ,action_information_id
4194: FROM pay_action_information
4195: WHERE action_context_id = p_action_context_id
4196: AND action_context_type = 'AAP'
4197: AND action_information_category = 'IN_24QC_DEDUCTEE'
4198: AND assignment_id = p_assignment_id

Line 4554: FROM pay_action_information pai

4550: CURSOR c_get_bal_24q(p_action_context_id NUMBER, p_24q_source_id NUMBER, p_category VARCHAR2, p_balance_name VARCHAR2)
4551: IS
4552: SELECT DISTINCT
4553: FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values(p_category,p_balance_name,pai.action_context_id,pai.source_id,1)))
4554: FROM pay_action_information pai
4555: WHERE pai.action_context_id = p_action_context_id
4556: AND pai.action_information_category = p_category
4557: AND pai.source_id = p_24q_source_id;
4558:

Line 4569: FROM pay_action_information pai

4565: ,pai.action_information6 full_name
4566: ,fnd_date.canonical_to_date(pai.action_information9) start_date
4567: ,fnd_date.canonical_to_date(pai.action_information10) end_date
4568: ,pai.source_id
4569: FROM pay_action_information pai
4570: ,pay_assignment_actions paa
4571: WHERE pai.action_information_category IN('IN_24Q_PERSON')
4572: AND pai.action_information3 = g_gre_id
4573: AND pai.action_information2 = g_year||g_quarter

Line 4593: FROM pay_action_information pai

4589: ,pai.action_information6 full_name
4590: ,fnd_date.canonical_to_date(pai.action_information8) start_date
4591: ,fnd_date.canonical_to_date(pai.action_information9) end_date
4592: ,pai.source_id
4593: FROM pay_action_information pai
4594: ,pay_assignment_actions paa
4595: ,pay_action_interlocks locks
4596: ,pay_assignment_actions paa_master
4597: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 4642: FROM pay_action_information pai

4638: p_assignment_id NUMBER
4639: )
4640: IS
4641: SELECT pai.action_context_id, pai.source_id
4642: FROM pay_action_information pai
4643: ,pay_assignment_actions paa
4644: ,pay_action_interlocks locks
4645: ,pay_assignment_actions paa_master
4646: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 4677: FROM pay_action_information pai

4673: p_assignment_id NUMBER
4674: )
4675: IS
4676: SELECT DISTINCT pai.action_context_id, pai.source_id
4677: FROM pay_action_information pai
4678: ,pay_assignment_actions paa
4679: WHERE pai.action_information_category IN('IN_24Q_PERSON')
4680: AND pai.action_information3 = g_gre_id
4681: AND pai.action_information2 = g_year||g_quarter

Line 5234: FROM pay_action_information pai

5230: ,p_source_id NUMBER
5231: )
5232: IS
5233: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information11))
5234: FROM pay_action_information pai
5235: ,pay_assignment_actions paa
5236: WHERE pai.action_information_category = 'IN_24Q_PERSON'
5237: AND pai.action_information3 = g_gre_id
5238: AND pai.action_information2 = g_year||g_quarter

Line 5259: FROM pay_action_information pai

5255: ,p_source_id NUMBER
5256: )
5257: IS
5258: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information12))
5259: FROM pay_action_information pai
5260: ,pay_assignment_actions paa
5261: ,pay_action_interlocks locks
5262: ,pay_assignment_actions paa_master
5263: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 5286: FROM pay_action_information pai

5282:
5283: CURSOR c_max_salary_number_24q
5284: IS
5285: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information11))
5286: FROM pay_action_information pai
5287: ,pay_assignment_actions paa
5288: WHERE pai.action_information_category = 'IN_24Q_PERSON'
5289: AND pai.action_information3 = g_gre_id
5290: AND pai.action_information2 = g_year||g_quarter

Line 5308: FROM pay_action_information pai

5304:
5305: CURSOR c_max_salary_number_24qc
5306: IS
5307: SELECT MAX(FND_NUMBER.CANONICAL_TO_NUMBER(action_information12))
5308: FROM pay_action_information pai
5309: ,pay_assignment_actions paa
5310: ,pay_action_interlocks locks
5311: ,pay_assignment_actions paa_master
5312: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 5410: FROM pay_action_information pai

5406: p_assignment_id NUMBER
5407: )
5408: IS
5409: SELECT DISTINCT pai.source_id,pai.action_context_id
5410: FROM pay_action_information pai
5411: ,pay_assignment_actions paa
5412: ,pay_action_interlocks locks
5413: ,pay_assignment_actions paa_master
5414: WHERE pai.action_information_category = 'IN_24QC_PERSON'

Line 5440: FROM pay_action_information pai

5436: p_assignment_id NUMBER
5437: )
5438: IS
5439: SELECT DISTINCT pai.source_id,pai.action_context_id
5440: FROM pay_action_information pai
5441: WHERE pai.action_information_category IN('IN_24Q_PERSON')
5442: AND pai.action_information3 = g_gre_id
5443: AND pai.assignment_id = p_assignment_id
5444: AND pai.action_context_id = p_action_context_id

Line 5451: FROM pay_action_information pai

5447: CURSOR c_get_bal_24q(p_action_context_id NUMBER, p_24q_source_id NUMBER, p_category VARCHAR2, p_balance_name VARCHAR2)
5448: IS
5449: SELECT DISTINCT
5450: FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values(p_category,p_balance_name,pai.action_context_id,pai.source_id,1)))
5451: FROM pay_action_information pai
5452: WHERE pai.action_context_id = p_action_context_id
5453: AND pai.action_information_category = p_category
5454: AND pai.source_id = p_24q_source_id;
5455:

Line 5462: l_action_information_category pay_action_information.action_information_category%TYPE;

5458:
5459: tab_24q_pe_data t_person_data_sal_rec;
5460: tab_liv_pe_data t_person_data_sal_rec;
5461:
5462: l_action_information_category pay_action_information.action_information_category%TYPE;
5463: l_arch_asg_action_id NUMBER;
5464: l_24qa_asg_action_id NUMBER;
5465: l_24qa_source_id NUMBER;
5466: l_prev_asg_action_id NUMBER;

Line 5615: pay_action_information_api.create_action_information

5611: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
5612: AND ((l_c5_change_only = FALSE)) AND (g_quarter IN ('Q4') AND (l_flag = 0))
5613: THEN
5614:
5615: pay_action_information_api.create_action_information
5616: (p_action_context_id => l_arch_asg_action_id
5617: ,p_action_context_type => 'AAP'
5618: ,p_action_information_category => 'IN_24QC_PERSON'
5619: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5646: pay_action_information_api.create_action_information

5642: (tab_24q_ba_data(l).balance_value <> 0)
5643: )
5644: THEN
5645:
5646: pay_action_information_api.create_action_information
5647: (p_action_context_id => l_arch_asg_action_id
5648: ,p_action_context_type => 'AAP'
5649: ,p_action_information_category => 'IN_24QC_SALARY'
5650: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5673: pay_action_information_api.create_action_information

5669: FETCH c_get_bal_24q INTO l_balance_value;
5670: CLOSE c_get_bal_24q;
5671:
5672: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0)) THEN
5673: pay_action_information_api.create_action_information
5674: (p_action_context_id => l_arch_asg_action_id
5675: ,p_action_context_type => 'AAP'
5676: ,p_action_information_category => 'IN_24QC_SALARY'
5677: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5720: pay_action_information_api.create_action_information

5716:
5717: pay_in_utils.trace('Delete Source ID : ', g_sal_data_rec_del(i).source_id );
5718: pay_in_utils.trace('l_max_pact : ', l_max_pact );
5719:
5720: pay_action_information_api.create_action_information
5721: (p_action_context_id => l_arch_asg_action_id
5722: ,p_action_context_type => 'AAP'
5723: ,p_action_information_category => 'IN_24QC_PERSON'
5724: ,p_source_id => l_max_pact

Line 5749: pay_action_information_api.create_action_information

5745: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
5746: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
5747: )
5748: THEN
5749: pay_action_information_api.create_action_information
5750: (p_action_context_id => l_arch_asg_action_id
5751: ,p_action_context_type => 'AAP'
5752: ,p_action_information_category => 'IN_24QC_VIA'
5753: ,p_source_id => l_max_pact

Line 5764: pay_action_information_api.create_action_information

5760: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
5761: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
5762: )
5763: THEN
5764: pay_action_information_api.create_action_information
5765: (p_action_context_id => l_arch_asg_action_id
5766: ,p_action_context_type => 'AAP'
5767: ,p_action_information_category => 'IN_24QC_SALARY'
5768: ,p_source_id => l_max_pact

Line 5794: pay_action_information_api.create_action_information

5790:
5791: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_prev_pay) AND (l_flag1=0))
5792: THEN
5793:
5794: pay_action_information_api.create_action_information
5795: (p_action_context_id => l_arch_asg_action_id
5796: ,p_action_context_type => 'AAP'
5797: ,p_action_information_category => 'IN_24QC_PERSON'
5798: ,p_source_id => l_max_pact

Line 5824: pay_action_information_api.create_action_information

5820: (tab_24q_ba_data(l).balance_value <> 0)
5821: )
5822: THEN
5823:
5824: pay_action_information_api.create_action_information
5825: (p_action_context_id => l_arch_asg_action_id
5826: ,p_action_context_type => 'AAP'
5827: ,p_action_information_category => 'IN_24QC_SALARY'
5828: ,p_source_id => l_max_pact

Line 5998: pay_action_information_api.create_action_information

5994: pay_in_utils.trace('Addition Assignment ID : ', g_sal_data_rec_add(i).assignment_id );
5995:
5996: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_flag1=0) AND (l_prev_c5))
5997: THEN
5998: pay_action_information_api.create_action_information
5999: (p_action_context_id => l_arch_asg_action_id
6000: ,p_action_context_type => 'AAP'
6001: ,p_action_information_category => 'IN_24QC_PERSON'
6002: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 6028: pay_action_information_api.create_action_information

6024: (tab_24q_ba_data(l).balance_value <> 0)
6025: )
6026: THEN
6027:
6028: pay_action_information_api.create_action_information
6029: (p_action_context_id => l_arch_asg_action_id
6030: ,p_action_context_type => 'AAP'
6031: ,p_action_information_category => 'IN_24QC_SALARY'
6032: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 6060: pay_action_information_api.create_action_information

6056: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
6057: AND ((l_c5_change_only=FALSE)) AND (g_quarter IN ('Q4') AND (l_flag=0))
6058: THEN
6059:
6060: pay_action_information_api.create_action_information
6061: (p_action_context_id => l_arch_asg_action_id
6062: ,p_action_context_type => 'AAP'
6063: ,p_action_information_category => 'IN_24QC_PERSON'
6064: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 6089: pay_action_information_api.create_action_information

6085: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
6086: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
6087: )
6088: THEN
6089: pay_action_information_api.create_action_information
6090: (p_action_context_id => l_arch_asg_action_id
6091: ,p_action_context_type => 'AAP'
6092: ,p_action_information_category => 'IN_24QC_VIA'
6093: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 6104: pay_action_information_api.create_action_information

6100: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
6101: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
6102: )
6103: THEN
6104: pay_action_information_api.create_action_information
6105: (p_action_context_id => l_arch_asg_action_id
6106: ,p_action_context_type => 'AAP'
6107: ,p_action_information_category => 'IN_24QC_SALARY'
6108: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 6167: pay_action_information_api.create_action_information

6163: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
6164: 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))
6165: THEN
6166:
6167: pay_action_information_api.create_action_information
6168: (p_action_context_id => l_arch_asg_action_id
6169: ,p_action_context_type => 'AAP'
6170: ,p_action_information_category => 'IN_24QC_PERSON'
6171: ,p_source_id => l_prev_max_pact

Line 6199: pay_action_information_api.create_action_information

6195:
6196: IF ((l_prev_asg_action_id IS NOT NULL) AND (l_balance_value <> 0))
6197: THEN
6198:
6199: pay_action_information_api.create_action_information
6200: (p_action_context_id => l_arch_asg_action_id
6201: ,p_action_context_type => 'AAP'
6202: ,p_action_information_category => 'IN_24QC_SALARY'
6203: ,p_source_id => l_prev_max_pact

Line 6226: pay_action_information_api.create_action_information

6222: CLOSE c_get_bal_24q;
6223:
6224: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0))
6225: THEN
6226: pay_action_information_api.create_action_information
6227: (p_action_context_id => l_arch_asg_action_id
6228: ,p_action_context_type => 'AAP'
6229: ,p_action_information_category => 'IN_24QC_SALARY'
6230: ,p_source_id => l_prev_max_pact

Line 6372: pay_action_information_api.create_action_information

6368:
6369: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_flag1=0) AND (l_future_pay=TRUE))
6370: THEN
6371:
6372: pay_action_information_api.create_action_information
6373: (p_action_context_id => l_arch_asg_action_id
6374: ,p_action_context_type => 'AAP'
6375: ,p_action_information_category => 'IN_24QC_PERSON'
6376: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6402: pay_action_information_api.create_action_information

6398: (tab_24q_ba_data(l).balance_value <> 0)
6399: )
6400: THEN
6401:
6402: pay_action_information_api.create_action_information
6403: (p_action_context_id => l_arch_asg_action_id
6404: ,p_action_context_type => 'AAP'
6405: ,p_action_information_category => 'IN_24QC_SALARY'
6406: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6422: pay_action_information_api.create_action_information

6418: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
6419: AND (l_c5_change_only=FALSE) AND (g_quarter IN ('Q4') AND (l_flag2 = 0))
6420: THEN
6421:
6422: pay_action_information_api.create_action_information
6423: (p_action_context_id => l_arch_asg_action_id
6424: ,p_action_context_type => 'AAP'
6425: ,p_action_information_category => 'IN_24QC_PERSON'
6426: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6454: pay_action_information_api.create_action_information

6450: (tab_24q_ba_data(l).balance_value <> 0)
6451: )
6452: THEN
6453:
6454: pay_action_information_api.create_action_information
6455: (p_action_context_id => l_arch_asg_action_id
6456: ,p_action_context_type => 'AAP'
6457: ,p_action_information_category => 'IN_24QC_SALARY'
6458: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6482: pay_action_information_api.create_action_information

6478: FETCH c_get_bal_24q INTO l_balance_value;
6479: CLOSE c_get_bal_24q;
6480:
6481: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0)) THEN
6482: pay_action_information_api.create_action_information
6483: (p_action_context_id => l_arch_asg_action_id
6484: ,p_action_context_type => 'AAP'
6485: ,p_action_information_category => 'IN_24QC_SALARY'
6486: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6514: pay_action_information_api.create_action_information

6510: IF (INSTR(l_action_information_category,'C4')<> 0)AND(g_correction_mode IN ('%','C4'))
6511: AND (l_c5_change_only=FALSE) AND (g_quarter IN ('Q4') AND (l_flag = 0))
6512: THEN
6513:
6514: pay_action_information_api.create_action_information
6515: (p_action_context_id => l_arch_asg_action_id
6516: ,p_action_context_type => 'AAP'
6517: ,p_action_information_category => 'IN_24QC_PERSON'
6518: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6543: pay_action_information_api.create_action_information

6539: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
6540: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
6541: )
6542: THEN
6543: pay_action_information_api.create_action_information
6544: (p_action_context_id => l_arch_asg_action_id
6545: ,p_action_context_type => 'AAP'
6546: ,p_action_information_category => 'IN_24QC_VIA'
6547: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6558: pay_action_information_api.create_action_information

6554: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
6555: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
6556: )
6557: THEN
6558: pay_action_information_api.create_action_information
6559: (p_action_context_id => l_arch_asg_action_id
6560: ,p_action_context_type => 'AAP'
6561: ,p_action_information_category => 'IN_24QC_SALARY'
6562: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6613: FROM pay_action_information pai

6609: CURSOR c_c5_correction_type_details(p_last_arc_asg_action_id NUMBER)
6610: IS
6611: SELECT pai.action_information_category
6612: ,pai.action_context_id
6613: FROM pay_action_information pai
6614: ,pay_assignment_actions paa
6615: WHERE paa.assignment_action_id = p_last_arc_asg_action_id
6616: AND pai.action_context_id = paa.payroll_action_id
6617: AND pai.action_context_type = 'PA'

Line 6625: FROM pay_action_information pai

6621: ,p_element_entry_id NUMBER
6622: )
6623: IS
6624: SELECT action_information25
6625: FROM pay_action_information pai
6626: ,pay_assignment_actions paa
6627: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
6628: AND pai.action_information3 = g_gre_id
6629: AND pai.action_information1 = p_challan_number

Line 6639: FROM pay_action_information pai

6635: ,p_element_entry_id NUMBER
6636: )
6637: IS
6638: SELECT action_information25
6639: FROM pay_action_information pai
6640: ,pay_assignment_actions paa
6641: ,pay_action_interlocks locks
6642: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
6643: AND pai.action_information3 = g_gre_id

Line 6655: FROM pay_action_information pai

6651:
6652: CURSOR c_max_challan_number_24qc(p_challan_number VARCHAR2)
6653: IS
6654: SELECT MAX(TO_NUMBER(action_information25))
6655: FROM pay_action_information pai
6656: ,pay_assignment_actions paa
6657: ,pay_action_interlocks locks
6658: ,pay_assignment_actions paa_master
6659: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'

Line 6681: FROM pay_action_information pai

6677:
6678: CURSOR c_max_challan_number_24q(p_challan_number VARCHAR2)
6679: IS
6680: SELECT MAX(TO_NUMBER(action_information25))
6681: FROM pay_action_information pai
6682: ,pay_assignment_actions paa
6683: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
6684: AND pai.action_information3 = g_gre_id
6685: AND pai.action_information1 = p_challan_number

Line 6711: l_action_information_category pay_action_information.action_information_category%TYPE;

6707: tab_liv_ee_data t_screen_entry_value_rec;
6708: tab_24q_pe_data t_person_data_rec;
6709: tab_liv_pe_data t_person_data_rec;
6710:
6711: l_action_information_category pay_action_information.action_information_category%TYPE;
6712: l_action_context_id NUMBER;
6713: l_deductee_detail NUMBER;
6714: l_arch_asg_action_id NUMBER;
6715: l_action_info_id NUMBER;

Line 6723: l_category pay_action_information.action_information_category%TYPE;

6719: s NUMBER;
6720: l_dummy NUMBER := -1;
6721: l_flag NUMBER := -1;
6722: l_c5_change BOOLEAN;
6723: l_category pay_action_information.action_information_category%TYPE;
6724: l_procedure VARCHAR2(250);
6725: l_message VARCHAR2(250);
6726: BEGIN
6727: g_debug := hr_utility.debug_enabled;

Line 6796: pay_action_information_api.create_action_information

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

Line 6840: pay_action_information_api.create_action_information

6836: ,INSTR(l_action_information_category,'G')
6837: );
6838: l_category := l_category || 'C3';
6839:
6840: pay_action_information_api.create_action_information
6841: (p_action_context_id => l_arch_asg_action_id
6842: ,p_action_context_type => 'AAP'
6843: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6844: ,p_source_id => g_ee_data_rec_del(i).element_entry_id

Line 6934: pay_action_information_api.create_action_information

6930: FETCH c_max_challan_number_24qc INTO j;
6931: CLOSE c_max_challan_number_24qc;
6932: pay_in_utils.set_location(g_debug,'Number found is ' || j, 2);
6933:
6934: pay_action_information_api.create_action_information
6935: (p_action_context_id => l_arch_asg_action_id
6936: ,p_action_context_type => 'AAP'
6937: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6938: ,p_source_id => g_ee_data_rec_add(i).element_entry_id

Line 7074: pay_action_information_api.create_action_information

7070: ,INSTR(l_action_information_category,'G')
7071: );
7072: l_category := l_category || 'C5';
7073:
7074: pay_action_information_api.create_action_information
7075: (p_action_context_id => l_arch_asg_action_id
7076: ,p_action_context_type => 'AAP'
7077: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
7078: ,p_source_id => g_ee_data_rec_upd(i).element_entry_id

Line 7119: pay_action_information_api.create_action_information

7115: ,INSTR(l_action_information_category,'G')
7116: );
7117: l_category := l_category || 'C3';
7118:
7119: pay_action_information_api.create_action_information
7120: (p_action_context_id => l_arch_asg_action_id
7121: ,p_action_context_type => 'AAP'
7122: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
7123: ,p_source_id => g_ee_data_rec_upd(i).element_entry_id

Line 7190: FROM pay_action_information

7186: ,action_information14
7187: ,action_information17
7188: ,action_information25
7189: ,action_information_id
7190: FROM pay_action_information
7191: WHERE action_context_type = 'PA'
7192: AND action_information_category = 'IN_24QC_CHALLAN'
7193: AND action_information15 = p_24qa_pay_act_id
7194: AND NVL(action_information4,'BOOK')||' - '||action_information1||' - '||to_char(fnd_date.canonical_to_date(action_information5),'DD-Mon-RRRR') = p_transfer_voucher_number

Line 7217: FROM pay_action_information pai

7213: + NVL(action_information8,0)
7214: + NVL(action_information9,0)
7215: + NVL(action_information10,0)
7216: ,action_information25
7217: FROM pay_action_information pai
7218: WHERE pai.action_context_type = 'PA'
7219: AND pai.action_information_category = 'IN_24Q_CHALLAN'
7220: AND pai.action_context_id = p_24qa_pay_act_id
7221: AND NVL(action_information4,'BOOK')||' - '||action_information1||' - '||to_char(fnd_date.canonical_to_date(action_information5),'DD-Mon-RRRR') = p_transfer_voucher_number

Line 7360: pay_action_information_api.create_action_information

7356: pay_in_utils.set_location(g_debug,'l_challan_deductee_no '|| l_challan_deductee_no ,3);
7357: pay_in_utils.set_location(g_debug,'l_action_information_id '|| l_action_information_id ,3);
7358: END IF;
7359: -- Now Archive these details
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 => g_challan_data_noc(i).org_information_id

Line 7483: FROM pay_action_information

7479: pay_in_utils.set_location(g_debug,'Fetching Challan Data ', 1);
7480: BEGIN
7481: SELECT MAX(TO_NUMBER(action_information25))
7482: INTO j
7483: FROM pay_action_information
7484: WHERE action_information_category = 'IN_24Q_CHALLAN'
7485: AND action_information3 = g_gre_id
7486: AND action_information2 = g_year||g_quarter
7487: AND action_context_id = p_24qa_pay_act_id

Line 7502: FROM pay_action_information

7498:
7499: pay_in_utils.set_location(g_debug,'Addition:Value of j is : '|| j ,1);
7500: SELECT MAX(TO_NUMBER(action_information25))
7501: INTO k
7502: FROM pay_action_information
7503: WHERE action_information_category = 'IN_24QC_CHALLAN'
7504: AND action_information3 = g_gre_id
7505: AND action_information2 = g_year||g_quarter
7506: AND action_information15 = p_24qa_pay_act_id

Line 7556: pay_action_information_api.create_action_information

7552: CLOSE c_challan_live_data;
7553: pay_in_utils.set_location(g_debug,'Fetched Live Data ' ,1);
7554:
7555: pay_in_utils.set_location(g_debug,'Archiving Data ' ,1);
7556: pay_action_information_api.create_action_information
7557: (p_action_context_id => p_24qc_pay_act_id
7558: ,p_action_context_type => 'PA'
7559: ,p_action_information_category => 'IN_24QC_CHALLAN'
7560: ,p_source_id => g_challan_data_add(i).org_information_id

Line 7607: FROM pay_action_information

7603: k := -1;
7604: BEGIN
7605: SELECT DISTINCT action_information25
7606: INTO j
7607: FROM pay_action_information
7608: WHERE action_information_category = 'IN_24Q_CHALLAN'
7609: AND action_information3 = g_gre_id
7610: AND action_information2 = g_year||g_quarter
7611: AND action_context_id = p_24qa_pay_act_id

Line 7635: FROM pay_action_information

7631:
7632: BEGIN
7633: SELECT DISTINCT action_information25
7634: INTO k
7635: FROM pay_action_information
7636: WHERE action_information_category = 'IN_24QC_CHALLAN'
7637: AND action_information3 = g_gre_id
7638: AND action_information2 = g_year||g_quarter
7639: AND action_context_id = p_24qa_pay_act_id

Line 7684: pay_action_information_api.create_action_information

7680: + NVL(g_challan_data_upd(i).education_cess,0)
7681: + NVL(g_challan_data_upd(i).interest,0)
7682: + NVL(g_challan_data_upd(i).other,0);
7683:
7684: pay_action_information_api.create_action_information
7685: (p_action_context_id => p_24qc_pay_act_id
7686: ,p_action_context_type => 'PA'
7687: ,p_action_information_category => 'IN_24QC_CHALLAN'
7688: ,p_source_id => l_org_information_id

Line 7761: FROM pay_action_information

7757: SELECT action_information2
7758: ,action_information5
7759: ,action_information7
7760: ,DECODE(action_information_category,'IN_24Q_ORG',action_information21,action_information7)
7761: FROM pay_action_information
7762: WHERE action_context_id = p_action_context_id
7763: AND action_information_category LIKE 'IN_24Q%ORG'
7764: AND action_context_type = 'PA';
7765:

Line 7810: pay_action_information_api.create_action_information

7806: pay_in_utils.set_location(g_debug,'Deductor Type is : ' || l_deductor_type,9);
7807:
7808: pay_in_utils.set_location(g_debug,'Archiving Data ', 9);
7809:
7810: pay_action_information_api.create_action_information
7811: (p_action_context_id => p_payroll_action_id
7812: ,p_action_context_type => 'PA'
7813: ,p_action_information_category => 'IN_24QC_ORG'
7814: ,p_source_id => l_action_context_id

Line 7885: FROM pay_action_information

7881: ,action_information7 emplr_type
7882: ,DECODE(action_information_category,'IN_24Q_ORG',action_information21,action_information7) emplr_type_24Q
7883: ,1 BUI
7884: ,action_context_id
7885: FROM pay_action_information
7886: WHERE action_information_category IN ('IN_24Q_ORG','IN_24QC_ORG')
7887: AND action_context_id = p_last_act_cxt_id
7888: AND action_context_type = 'PA'
7889: AND action_information1 = g_gre_id

Line 7897: FROM pay_action_information

7893:
7894: CURSOR c_24qa_nil_challan_indicator(p_tan_number VARCHAR2)
7895: IS
7896: SELECT action_information26
7897: FROM pay_action_information
7898: WHERE action_information_category = 'IN_24Q_ORG'
7899: AND action_context_id = p_24qa_pay_act_id
7900: AND action_context_type = 'PA'
7901: AND action_information1 = g_gre_id

Line 7992: pay_action_information_api.create_action_information

7988: ELSE
7989: l_new_nil_challan := 'Y';
7990: END IF;
7991:
7992: pay_action_information_api.create_action_information
7993: (p_action_context_id => p_24qc_pay_act_id
7994: ,p_action_context_type => 'PA'
7995: ,p_action_information_category => 'IN_24QC_ORG'
7996: ,p_source_id => p_24qa_pay_act_id

Line 8075: pay_action_information_api.create_action_information

8071:
8072: pay_in_utils.set_location(g_debug,'Archiving Data ',7);
8073: pay_in_utils.set_location(g_debug,'Address Change is '|| g_24qc_empr_change , 2);
8074:
8075: pay_action_information_api.create_action_information
8076: (p_action_context_id => p_24qc_pay_act_id
8077: ,p_action_context_type => 'PA'
8078: ,p_action_information_category => 'IN_24QC_ORG'
8079: ,p_source_id => p_24qa_pay_act_id

Line 8140: FROM pay_action_information

8136: IS
8137: CURSOR c_24q_per_check
8138: IS
8139: SELECT 1
8140: FROM pay_action_information
8141: WHERE action_information_category = 'IN_24Q_PERSON'
8142: AND action_context_id = p_assignment_act_id
8143: AND action_information3 = g_gre_id;
8144:

Line 8148: FROM pay_action_information

8144:
8145: CURSOR c_24qc_ded_check
8146: IS
8147: SELECT 1
8148: FROM pay_action_information
8149: WHERE action_information_category = 'IN_24QC_DEDUCTEE'
8150: AND action_context_id = p_assignment_act_id
8151: AND action_information3 = g_gre_id;
8152:

Line 8421: FROM pay_action_information pai

8417: IS
8418: CURSOR c_select_deductee
8419: IS
8420: SELECT DISTINCT pai.action_information1 challan
8421: FROM pay_action_information pai
8422: ,pay_assignment_actions paa
8423: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
8424: AND paa.assignment_action_id = pai.action_context_id
8425: AND paa.payroll_action_id = p_payroll_action_id

Line 8432: FROM pay_action_information pai

8428:
8429: CURSOR c_challan_sequence(p_challan_number VARCHAR2)
8430: IS
8431: SELECT pai.action_information25 challan_seq
8432: FROM pay_action_information pai
8433: WHERE pai.action_information_category IN ('IN_24QC_CHALLAN','IN_24Q_CHALLAN')
8434: AND pai.action_information1 = p_challan_number
8435: AND pai.action_context_id IN
8436: (

Line 8454: FROM pay_action_information

8450: SELECT action_information2 tan_number
8451: ,action_information5 legal_name
8452: ,action_information7 emplr_type
8453: ,DECODE(action_information_category,'IN_24Q_ORG',action_information21,action_information7) emplr_type_24Q
8454: FROM pay_action_information
8455: WHERE action_information_category IN ('IN_24Q_ORG','IN_24QC_ORG')
8456: AND action_context_id = p_last_act_cxt_id
8457: AND action_context_type = 'PA'
8458: AND action_information1 = g_gre_id

Line 8514: pay_action_information_api.create_action_information

8510: l_flag_number := -1;
8511: l_flag_number := check_archival_status(NULL,'IN_24QC_CHALLAN',g_challan_data_upd(i).transfer_voucher_number,NULL);
8512: IF((g_challan_data_upd(i).transfer_voucher_number = c_rec.challan)AND(l_flag_number = 0))
8513: THEN
8514: pay_action_information_api.create_action_information
8515: (p_action_context_id => p_payroll_action_id
8516: ,p_action_context_type => 'PA'
8517: ,p_action_information_category => 'IN_24QC_CHALLAN'
8518: ,p_source_id => g_challan_data_upd(i).org_information_id

Line 8547: pay_action_information_api.create_action_information

8543: l_flag_number := -1;
8544: l_flag_number := check_archival_status(NULL,'IN_24QC_CHALLAN',g_challan_data_noc(i).transfer_voucher_number,NULL);
8545: IF((g_challan_data_noc(i).transfer_voucher_number = c_rec.challan)AND(l_flag_number =0))
8546: THEN
8547: pay_action_information_api.create_action_information
8548: (p_action_context_id => p_payroll_action_id
8549: ,p_action_context_type => 'PA'
8550: ,p_action_information_category => 'IN_24QC_CHALLAN'
8551: ,p_source_id => g_challan_data_noc(i).org_information_id

Line 8625: pay_action_information_api.create_action_information

8621: pay_in_utils.set_location(g_debug,'p_payroll_action_id is '|| p_payroll_action_id, 10);
8622: l_action_info_id := NULL;
8623: l_ovn := NULL;
8624:
8625: pay_action_information_api.create_action_information
8626: (p_action_context_id => p_payroll_action_id
8627: ,p_action_context_type => 'PA'
8628: ,p_action_information_category => 'IN_24QC_ORG'
8629: ,p_action_information1 => g_gre_id

Line 8735: FROM pay_action_information

8731:
8732: CURSOR c_source_id(p_pay_act_id_last_24Q NUMBER)
8733: IS
8734: SELECT source_id
8735: FROM pay_action_information
8736: WHERE action_context_id = p_pay_act_id_last_24Q
8737: AND action_information_category = 'IN_24QC_ORG'
8738: AND action_context_type = 'PA'
8739: AND action_information3 = g_year||g_quarter;

Line 8744: FROM pay_action_information pai

8740:
8741: CURSOR c_act_category(p_pay_act_id_last_24Q NUMBER)
8742: IS
8743: SELECT DECODE(pai.action_information_category,'IN_24Q_ORG',1,2)
8744: FROM pay_action_information pai
8745: WHERE pai.action_information_category IN ('IN_24QC_ORG','IN_24Q_ORG')
8746: AND pai.action_context_id = p_pay_act_id_last_24Q
8747: AND pai.action_context_type = 'PA'
8748: AND pai.action_information3 = g_year||g_quarter

Line 9687: FROM pay_action_information

9683: SELECT DECODE(action_information15, 1, 'C1')
9684: ,action_information_id
9685: ,object_version_number
9686: ,action_information29
9687: FROM pay_action_information
9688: WHERE action_information1 = g_gre_id
9689: AND action_information3 = g_year||g_quarter
9690: AND action_context_type = 'PA'
9691: AND action_information_category = 'IN_24QC_ORG'

Line 9700: FROM pay_action_information

9696: SELECT action_information1 challan
9697: ,DECODE(action_information18, 'U', 'C2', 'A', 'C9', 'NC', null) correction_type
9698: ,action_information_id
9699: ,object_version_number
9700: FROM pay_action_information
9701: WHERE action_information3 = g_gre_id
9702: AND action_information2 = g_year||g_quarter
9703: AND action_context_type = 'PA'
9704: AND action_information_category = 'IN_24QC_CHALLAN'

Line 9711: FROM pay_action_information pai

9707: CURSOR cur_deductee_recs(p_payroll_action_id NUMBER
9708: ,p_challan_number VARCHAR2)
9709: IS
9710: SELECT 'C3' correction_type
9711: FROM pay_action_information pai
9712: WHERE pai.action_context_id IN (SELECT assignment_action_id
9713: FROM pay_assignment_actions
9714: WHERE payroll_action_id = p_payroll_action_id
9715: AND assignment_id = pai.assignment_id

Line 9736: FROM pay_action_information pai

9732: CURSOR cur_c5_deductee_recs(p_payroll_action_id NUMBER
9733: ,p_challan_number VARCHAR2)
9734: IS
9735: SELECT 'C5' correction_type
9736: FROM pay_action_information pai
9737: WHERE pai.action_context_id IN ( SELECT assignment_action_id
9738: FROM pay_assignment_actions
9739: WHERE payroll_action_id = p_payroll_action_id
9740: AND assignment_id = pai.assignment_id

Line 9754: FROM pay_action_information pai

9750: CURSOR cur_c5_salary_recs(p_payroll_action_id NUMBER
9751: ,p_person_id NUMBER)
9752: IS
9753: SELECT 'C5' correction_type
9754: FROM pay_action_information pai
9755: WHERE pai.action_context_id IN ( SELECT assignment_action_id
9756: FROM pay_assignment_actions
9757: WHERE payroll_action_id = p_payroll_action_id
9758: AND assignment_id = pai.assignment_id

Line 9771: FROM pay_action_information pai

9767: CURSOR cur_c4_salary_recs(p_payroll_action_id NUMBER
9768: ,p_person_id NUMBER)
9769: IS
9770: SELECT 'C4' correction_type
9771: FROM pay_action_information pai
9772: WHERE pai.action_context_id IN ( SELECT assignment_action_id
9773: FROM pay_assignment_actions
9774: WHERE payroll_action_id = p_payroll_action_id
9775: AND assignment_id = pai.assignment_id

Line 9787: FROM pay_action_information

9783:
9784: CURSOR cur_salary_update_recs
9785: IS
9786: SELECT DISTINCT action_information3 gre_id
9787: FROM pay_action_information
9788: WHERE action_information_category = 'IN_24QC_PERSON'
9789: AND action_context_type = 'AAP'
9790: AND action_information10 = 'A'
9791: AND action_information11 = 'C4'

Line 9804: FROM pay_action_information

9800: SELECT DISTINCT action_information1 person_id
9801: , source_id
9802: , action_information_id
9803: , object_version_number
9804: FROM pay_action_information
9805: WHERE action_information_category = 'IN_24QC_PERSON'
9806: AND action_context_type = 'AAP'
9807: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9808: AND action_information10 = 'A'

Line 9820: FROM pay_action_information

9816:
9817: CURSOR cur_min_salary_record( p_gre_id VARCHAR2)
9818: IS
9819: SELECT MIN(fnd_number.canonical_to_number(action_information12)) min_salary_rec
9820: FROM pay_action_information
9821: WHERE action_information_category = 'IN_24QC_PERSON'
9822: AND action_context_type = 'AAP'
9823: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9824: AND action_information10 = 'A'

Line 9834: FROM pay_action_information pai

9830:
9831: CURSOR cur_salary_recs(p_payroll_action_id NUMBER)
9832: IS
9833: SELECT DISTINCT action_information1 person_id
9834: FROM pay_action_information pai
9835: WHERE action_information_category = 'IN_24QC_PERSON'
9836: AND action_context_type = 'AAP'
9837: AND action_context_id IN (SELECT assignment_action_id
9838: FROM pay_assignment_actions

Line 9849: FROM pay_action_information pai

9845: ,p_24q_pay_action_id NUMBER
9846: )
9847: IS
9848: SELECT SUM(NVL(pai.action_information9,0)) amount_deposited
9849: FROM pay_action_information pai
9850: ,pay_assignment_actions paa
9851: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
9852: AND paa.assignment_action_id = pai.action_context_id
9853: AND pai.action_information1 = p_challan_number

Line 9927: pay_action_information_api.update_action_information

9923: END IF;
9924: END IF;
9925:
9926: pay_in_utils.set_location(g_debug,'Updating API called for Challan ', 3);
9927: pay_action_information_api.update_action_information
9928: (p_validate => FALSE
9929: ,p_action_information_id => t_challan_nos(l_index).action_information_id
9930: ,p_object_version_number => t_challan_nos(l_index).object_version_number
9931: ,p_action_information29 => t_challan_nos(l_index).correction_type

Line 9954: pay_action_information_api.update_action_information

9950: pay_in_utils.set_location(g_debug,'c_salary_rec.gre_id...',c_salary_rec.gre_id);
9951:
9952: FOR cur_rec IN cur_person_update_recs(c_salary_rec.gre_id)
9953: LOOP
9954: pay_action_information_api.update_action_information
9955: (p_validate => FALSE
9956: ,p_action_information_id => cur_rec.action_information_id
9957: ,p_object_version_number => cur_rec.object_version_number
9958: ,p_action_information12 => l_index

Line 10030: pay_action_information_api.update_action_information

10026: END IF;
10027:
10028:
10029: pay_in_utils.set_location(g_debug,'Updating API called for Org ', 3);
10030: pay_action_information_api.update_action_information
10031: (p_validate => FALSE
10032: ,p_action_information_id => l_action_info_id
10033: ,p_object_version_number => l_ovn
10034: ,p_action_information29 => org_correction_type