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_ASSIGNMENT_ACTIONS

Line 272: FROM pay_assignment_actions

268: AND source_id = p_source_id
269: AND action_information10 = p_mode
270: AND action_context_id IN
271: (SELECT assignment_action_id
272: FROM pay_assignment_actions
273: WHERE payroll_action_id = g_payroll_action_id
274: );
275:
276:

Line 287: FROM pay_assignment_actions

283: AND source_id = p_source_id
284: AND action_information15 = p_mode
285: AND action_context_id IN
286: (SELECT assignment_action_id
287: FROM pay_assignment_actions
288: WHERE payroll_action_id = g_payroll_action_id
289: );
290:
291: CURSOR c_chk_org_data

Line 653: ,pay_assignment_actions paa

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
657: AND paa.payroll_action_id = p_24q_pay_action_id;

Line 726: ,pay_assignment_actions paa

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'
729: AND locks.locking_action_id = pai.action_context_id
730: AND locks.locked_action_id = paa.assignment_action_id

Line 727: ,pay_assignment_actions paa_24qc

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'
729: AND locks.locking_action_id = pai.action_context_id
730: AND locks.locked_action_id = paa.assignment_action_id
731: AND paa.payroll_action_id = g_24q_payroll_act_id

Line 801: ,pay_assignment_actions paa

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(
805: paa.payroll_action_id IN (

Line 836: ,pay_assignment_actions paa

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'
839: AND pai.action_information15 = 'D'
840: AND locks.locking_action_id = pai.action_context_id

Line 837: ,pay_assignment_actions masters

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'
839: AND pai.action_information15 = 'D'
840: AND locks.locking_action_id = pai.action_context_id
841: AND locks.locked_action_id = paa.assignment_action_id

Line 863: ,pay_assignment_actions paa

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'
866: AND pai.action_information15 = 'A'
867: AND locks.locking_action_id = pai.action_context_id

Line 864: ,pay_assignment_actions masters

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'
866: AND pai.action_information15 = 'A'
867: AND locks.locking_action_id = pai.action_context_id
868: AND locks.locked_action_id = paa.assignment_action_id

Line 904: ,pay_assignment_actions paa

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
908: )

Line 913: ,pay_assignment_actions paa

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
917: AND pai.source_id = entry.element_entry_id

Line 925: ,pay_assignment_actions paa

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'
928: AND locks.locking_action_id = pai.action_context_id
929: AND locks.locked_action_id = paa.assignment_action_id

Line 926: ,pay_assignment_actions paa_24qc

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'
928: AND locks.locking_action_id = pai.action_context_id
929: AND locks.locked_action_id = paa.assignment_action_id
930: AND paa.payroll_action_id = p_payroll_action_id

Line 952: ,pay_assignment_actions paa

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'
955: AND locks.locking_action_id = pai.action_context_id
956: AND locks.locked_action_id = paa.assignment_action_id

Line 953: ,pay_assignment_actions paa_24qc

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'
955: AND locks.locking_action_id = pai.action_context_id
956: AND locks.locked_action_id = paa.assignment_action_id
957: AND paa.payroll_action_id = p_payroll_action_id

Line 1066: ,pay_assignment_actions paa

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'
1070: AND pai.action_context_id = paa.assignment_action_id

Line 1134: ,pay_assignment_actions paa

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
1137: AND pai_locking.action_information15 = p_mode
1138: AND pai_locking.action_context_id = paa.assignment_action_id

Line 1164: ,pay_assignment_actions paa

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'
1166: AND paa.assignment_action_id = pai.action_context_id
1167: AND pai.source_id = p_element_entry_id
1168: AND paa.payroll_action_id IN

Line 1295: ,pay_assignment_actions paa

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
1299: AND pai.action_information15 = p_mode

Line 1319: ,pay_assignment_actions paa

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
1323: AND pai.action_information15 = 'D'

Line 1737: ,pay_assignment_actions paa

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
1741: AND pai.action_context_id = paa.assignment_action_id

Line 1764: FROM pay_assignment_actions paa

1760: pai.source_id NOT IN
1761: (
1762: SELECT
1763: paa.assignment_action_id run_asg_action_id
1764: FROM pay_assignment_actions paa
1765: ,pay_payroll_actions ppa
1766: ,per_assignments_f paf
1767: WHERE paf.assignment_id = paa.assignment_id
1768: AND paa.assignment_id = pai.assignment_id

Line 1779: pay_assignment_actions paa1,

1775: AND paa.source_action_id IS NULL
1776: AND (1 = DECODE(ppa.action_type,'I',1,0)
1777: OR EXISTS (SELECT ''
1778: FROM pay_action_interlocks intk,
1779: pay_assignment_actions paa1,
1780: pay_payroll_actions ppa1
1781: WHERE intk.locked_action_id = paa.assignment_Action_id
1782: AND intk.locking_action_id = paa1.assignment_action_id
1783: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 1796: ,pay_assignment_actions paa

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'
1799: AND pai.action_information10 IN ('D')
1800: AND locks.locking_action_id = pai.action_context_id

Line 1797: ,pay_assignment_actions masters

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'
1799: AND pai.action_information10 IN ('D')
1800: AND locks.locking_action_id = pai.action_context_id
1801: AND locks.locked_action_id = paa.assignment_action_id

Line 1828: FROM pay_assignment_actions paa

1824: (SELECT
1825: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
1826: ,paf.assignment_id assignment_id
1827: ,NULL last_action_context_id
1828: FROM pay_assignment_actions paa
1829: ,pay_payroll_actions ppa
1830: ,per_assignments_f paf
1831: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1832: AND paf.assignment_id = paa.assignment_id

Line 1843: pay_assignment_actions paa1,

1839: AND paa.source_action_id IS NULL
1840: AND (1 = DECODE(ppa.action_type,'I',1,0)
1841: OR EXISTS (SELECT ''
1842: FROM pay_action_interlocks intk,
1843: pay_assignment_actions paa1,
1844: pay_payroll_actions ppa1
1845: WHERE intk.locked_action_id = paa.assignment_Action_id
1846: AND intk.locking_action_id = paa1.assignment_action_id
1847: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 1858: ,pay_assignment_actions paa

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
1862: )

Line 1869: ,pay_assignment_actions paa

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'
1872: AND locks.locking_action_id = pai.action_context_id
1873: AND locks.locked_action_id = paa.assignment_action_id

Line 1870: ,pay_assignment_actions paa_24qc

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'
1872: AND locks.locking_action_id = pai.action_context_id
1873: AND locks.locked_action_id = paa.assignment_action_id
1874: AND paa.payroll_action_id = p_payroll_action_id

Line 1896: ,pay_assignment_actions paa

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'
1899: AND locks.locking_action_id = pai.action_context_id
1900: AND locks.locked_action_id = paa.assignment_action_id

Line 1897: ,pay_assignment_actions paa_24qc

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'
1899: AND locks.locking_action_id = pai.action_context_id
1900: AND locks.locked_action_id = paa.assignment_action_id
1901: AND paa.payroll_action_id = p_payroll_action_id

Line 1922: ,pay_assignment_actions paa_24qc

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
1926: AND paa_24qc.assignment_id = pai.assignment_id

Line 1952: ,pay_assignment_actions paa

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'
1956: AND fnd_number.canonical_to_number(pai.action_information1)

Line 1969: FROM pay_assignment_actions paa

1965: AND pai.source_id IN
1966: (
1967: SELECT
1968: paa.assignment_action_id run_asg_action_id
1969: FROM pay_assignment_actions paa
1970: ,pay_payroll_actions ppa
1971: ,per_assignments_f paf
1972: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1973: AND paf.assignment_id = paa.assignment_id

Line 1985: pay_assignment_actions paa1,

1981: AND paa.source_action_id IS NULL
1982: AND (1 = DECODE(ppa.action_type,'I',1,0)
1983: OR EXISTS (SELECT ''
1984: FROM pay_action_interlocks intk,
1985: pay_assignment_actions paa1,
1986: pay_payroll_actions ppa1
1987: WHERE intk.locked_action_id = paa.assignment_Action_id
1988: AND intk.locking_action_id = paa1.assignment_action_id
1989: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 2091: ,pay_assignment_actions paa

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)
2094: BETWEEN p_start_person AND p_end_person
2095: AND pai_locking.action_information3 = g_gre_id

Line 2122: ,pay_assignment_actions paa

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'
2124: AND fnd_number.canonical_to_number(pai.action_information1)
2125: BETWEEN p_start_person AND p_end_person
2126: AND paa.assignment_action_id = pai.action_context_id

Line 2149: FROM pay_assignment_actions paa

2145: AND pai.source_id IN
2146: (
2147: SELECT
2148: paa.assignment_action_id run_asg_action_id
2149: FROM pay_assignment_actions paa
2150: ,pay_payroll_actions ppa
2151: ,per_assignments_f paf
2152: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2153: AND paf.assignment_id = paa.assignment_id

Line 2165: pay_assignment_actions paa1,

2161: AND paa.source_action_id IS NULL
2162: AND (1 = DECODE(ppa.action_type,'I',1,0)
2163: OR EXISTS (SELECT ''
2164: FROM pay_action_interlocks intk,
2165: pay_assignment_actions paa1,
2166: pay_payroll_actions ppa1
2167: WHERE intk.locked_action_id = paa.assignment_Action_id
2168: AND intk.locking_action_id = paa1.assignment_action_id
2169: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 2370: ,pay_assignment_actions paa

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
2374: AND pai.action_information3 = g_gre_id

Line 2399: ,pay_assignment_actions paa

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
2403: AND pai.action_information3 = g_gre_id

Line 2426: FROM pay_assignment_actions paa

2422: (SELECT
2423: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
2424: ,paf.assignment_id assignment_id
2425: ,NULL last_action_context_id
2426: FROM pay_assignment_actions paa
2427: ,pay_payroll_actions ppa
2428: ,per_assignments_f paf
2429: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2430: AND paf.assignment_id = paa.assignment_id

Line 2441: pay_assignment_actions paa1,

2437: AND paa.source_action_id IS NULL
2438: AND (1 = DECODE(ppa.action_type,'I',1,0)
2439: OR EXISTS (SELECT ''
2440: FROM pay_action_interlocks intk,
2441: pay_assignment_actions paa1,
2442: pay_payroll_actions ppa1
2443: WHERE intk.locked_action_id = paa.assignment_Action_id
2444: AND intk.locking_action_id = paa1.assignment_action_id
2445: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 4246: ,pay_assignment_actions paa

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
4250: AND pai.assignment_id = p_assignment_id

Line 4270: ,pay_assignment_actions paa

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'
4274: AND pai.assignment_id = p_assignment_id

Line 4272: ,pay_assignment_actions paa_master

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'
4274: AND pai.assignment_id = p_assignment_id
4275: AND pai.action_information3 = g_gre_id
4276: AND pai.action_information2 = g_year||g_quarter

Line 4319: ,pay_assignment_actions paa

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'
4323: AND pai.assignment_id = p_assignment_id

Line 4321: ,pay_assignment_actions paa_master

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'
4323: AND pai.assignment_id = p_assignment_id
4324: AND pai.action_information3 = g_gre_id
4325: AND pai.action_information2 = g_year||g_quarter

Line 4354: ,pay_assignment_actions paa

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
4358: AND pai.assignment_id = p_assignment_id

Line 4374: ,pay_assignment_actions paa

4370: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
4371: ,scl.segment1
4372: FROM per_assignments_f asg
4373: ,hr_soft_coding_keyflex scl
4374: ,pay_assignment_actions paa
4375: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
4376: AND paa.assignment_action_id = p_action_context_id
4377: AND asg.assignment_id = paa.assignment_id
4378: AND paa.assignment_id = p_assignment_id

Line 4393: FROM pay_assignment_actions paa

4389: ,p_assignment_id NUMBER
4390: )
4391: IS
4392: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
4393: FROM pay_assignment_actions paa
4394: ,pay_payroll_actions ppa
4395: ,per_assignments_f paf
4396: WHERE paf.assignment_id = paa.assignment_id
4397: AND paf.assignment_id = p_assignment_id

Line 4408: pay_assignment_actions paa1,

4404: AND paa.source_action_id IS NULL
4405: AND (1 = DECODE(ppa.action_type,'I',1,0)
4406: OR EXISTS (SELECT ''
4407: FROM pay_action_interlocks intk,
4408: pay_assignment_actions paa1,
4409: pay_payroll_actions ppa1
4410: WHERE intk.locked_action_id = paa.assignment_Action_id
4411: AND intk.locking_action_id = paa1.assignment_action_id
4412: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 4426: FROM pay_assignment_actions paa

4422: IS
4423: SELECT paa.assignment_id
4424: ,paa.payroll_action_id
4425: ,paf.person_id
4426: FROM pay_assignment_actions paa
4427: ,per_all_assignments_f paf
4428: WHERE paa.assignment_action_id = p_action_context_id
4429: AND paa.assignment_id = paf.assignment_id
4430: AND ROWNUM =1;

Line 4911: ,pay_assignment_actions paa

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
4915: AND pai.action_information1 = p_person_id

Line 4936: ,pay_assignment_actions paa

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'
4940: AND pai.action_information3 = g_gre_id

Line 4938: ,pay_assignment_actions paa_master

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'
4940: AND pai.action_information3 = g_gre_id
4941: AND pai.action_information2 = g_year||g_quarter
4942: AND pai.action_information1 = p_person_id

Line 4963: ,pay_assignment_actions paa

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
4967: AND pai.action_context_id = paa.assignment_action_id

Line 4985: ,pay_assignment_actions paa

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'
4989: AND pai.action_information3 = g_gre_id

Line 4987: ,pay_assignment_actions paa_master

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'
4989: AND pai.action_information3 = g_gre_id
4990: AND pai.action_information2 = g_year||g_quarter
4991: AND locks.locking_action_id = pai.action_context_id

Line 5012: FROM pay_assignment_actions

5008: p_assignment_id NUMBER
5009: )
5010: IS
5011: SELECT assignment_action_id
5012: FROM pay_assignment_actions
5013: WHERE payroll_action_id = p_payroll_action_id
5014: AND assignment_id = p_assignment_id;
5015:
5016: CURSOR c_max_pact(p_assignment_id NUMBER)

Line 5021: FROM pay_assignment_actions paa

5017: IS
5018: SELECT
5019: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5020: ,paf.assignment_id assignment_id
5021: FROM pay_assignment_actions paa
5022: ,pay_payroll_actions ppa
5023: ,per_assignments_f paf
5024: WHERE paf.assignment_id = paa.assignment_id
5025: AND paf.assignment_id =p_assignment_id

Line 5036: pay_assignment_actions paa1,

5032: AND paa.source_action_id IS NULL
5033: AND (1 = DECODE(ppa.action_type,'I',1,0)
5034: OR EXISTS (SELECT ''
5035: FROM pay_action_interlocks intk,
5036: pay_assignment_actions paa1,
5037: pay_payroll_actions ppa1
5038: WHERE intk.locked_action_id = paa.assignment_Action_id
5039: AND intk.locking_action_id = paa1.assignment_action_id
5040: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 5053: FROM pay_assignment_actions paa

5049: IS
5050: SELECT
5051: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5052: ,paf.assignment_id assignment_id
5053: FROM pay_assignment_actions paa
5054: ,pay_payroll_actions ppa
5055: ,per_assignments_f paf
5056: WHERE paf.assignment_id = paa.assignment_id
5057: AND paf.assignment_id =p_assignment_id

Line 5069: pay_assignment_actions paa1,

5065: AND paa.source_action_id IS NULL
5066: AND (1 = DECODE(ppa.action_type,'I',1,0)
5067: OR EXISTS (SELECT ''
5068: FROM pay_action_interlocks intk,
5069: pay_assignment_actions paa1,
5070: pay_payroll_actions ppa1
5071: WHERE intk.locked_action_id = paa.assignment_Action_id
5072: AND intk.locking_action_id = paa1.assignment_action_id
5073: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 5087: ,pay_assignment_actions paa

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'
5091: AND pai.assignment_id = p_assignment_id

Line 5089: ,pay_assignment_actions paa_master

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'
5091: AND pai.assignment_id = p_assignment_id
5092: AND pai.action_information3 = g_gre_id
5093: AND pai.action_information2 = g_year||g_quarter

Line 6290: ,pay_assignment_actions paa

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'
6294: ORDER BY pai.action_context_id DESC;

Line 6302: ,pay_assignment_actions paa

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
6306: AND pai.action_context_id = paa.assignment_action_id

Line 6316: ,pay_assignment_actions paa

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
6320: AND pai.action_information2 = g_year||g_quarter

Line 6332: ,pay_assignment_actions paa

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'
6336: AND pai.action_information3 = g_gre_id

Line 6334: ,pay_assignment_actions paa_master

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'
6336: AND pai.action_information3 = g_gre_id
6337: AND pai.action_information2 = g_year||g_quarter
6338: AND pai.action_information1 = p_challan_number

Line 6358: ,pay_assignment_actions paa

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
6362: AND pai.action_context_id = paa.assignment_action_id

Line 6378: FROM pay_assignment_actions

6374:
6375: CURSOR c_asg_act_id(p_assignment_id NUMBER)
6376: IS
6377: SELECT assignment_action_id
6378: FROM pay_assignment_actions
6379: WHERE payroll_action_id = p_payroll_action_id
6380: AND assignment_id = p_assignment_id;
6381:
6382: tab_24q_ee_data t_screen_entry_value_rec;

Line 7839: FROM pay_assignment_actions

7835: CURSOR c_assignment_action_id(p_payroll_action_id NUMBER)
7836: IS
7837: SELECT assignment_action_id
7838: ,assignment_id
7839: FROM pay_assignment_actions
7840: WHERE payroll_action_id = p_payroll_action_id;
7841:
7842: CURSOR c_chk_asg_action(p_assignment_id NUMBER
7843: ,p_payroll_action_id NUMBER

Line 7847: FROM pay_assignment_actions paa

7843: ,p_payroll_action_id NUMBER
7844: )
7845: IS
7846: SELECT assignment_action_id
7847: FROM pay_assignment_actions paa
7848: ,pay_action_interlocks pai
7849: WHERE paa.assignment_id = p_assignment_id
7850: AND paa.assignment_action_id = pai.locking_action_id
7851: AND paa.payroll_action_id = p_payroll_action_id;

Line 7894: SELECT pay_assignment_actions_s.NEXTVAL

7890: FETCH c_chk_asg_action INTO l_action_id;
7891: CLOSE c_chk_asg_action;
7892: IF (l_action_id IS NULL)
7893: THEN
7894: SELECT pay_assignment_actions_s.NEXTVAL
7895: INTO l_action_id
7896: FROM dual;
7897:
7898: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);

Line 7930: SELECT pay_assignment_actions_s.NEXTVAL

7926: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
7927:
7928: IF (l_action_id IS NULL)
7929: THEN
7930: SELECT pay_assignment_actions_s.NEXTVAL
7931: INTO l_action_id
7932: FROM dual;
7933:
7934: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 7982: SELECT pay_assignment_actions_s.NEXTVAL

7978: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
7979:
7980: IF (l_action_id IS NULL)
7981: THEN
7982: SELECT pay_assignment_actions_s.NEXTVAL
7983: INTO l_action_id
7984: FROM dual;
7985:
7986: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 8043: ,pay_assignment_actions paa

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
8047: AND pai.action_information19 IS NOT NULL

Line 8307: FROM pay_assignment_actions

8303: ,p_payroll_act_id NUMBER
8304: )
8305: IS
8306: SELECT assignment_action_id
8307: FROM pay_assignment_actions
8308: WHERE payroll_action_id = p_payroll_act_id
8309: AND assignment_id = p_assignment_id;
8310:
8311: CURSOR c_max_24qc_locking_24q(p_24qc_arc_asg_act_id NUMBER)

Line 8494: SELECT pay_assignment_actions_s.NEXTVAL

8490: pay_in_utils.trace('l_dummy in g_count_sal_delete ',l_dummy);
8491:
8492: IF (l_dummy IS NULL)
8493: THEN
8494: SELECT pay_assignment_actions_s.NEXTVAL
8495: INTO l_action_id
8496: FROM dual;
8497:
8498: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 8643: SELECT pay_assignment_actions_s.NEXTVAL

8639: pay_in_utils.trace('l_dummy in g_count_sal_addition ',l_dummy);
8640:
8641: IF (l_dummy IS NULL)
8642: THEN
8643: SELECT pay_assignment_actions_s.NEXTVAL
8644: INTO l_action_id
8645: FROM dual;
8646:
8647: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 8794: SELECT pay_assignment_actions_s.NEXTVAL

8790: pay_in_utils.trace('l_dummy in g_count_sal_update ',l_dummy);
8791:
8792: IF (l_dummy IS NULL)
8793: THEN
8794: SELECT pay_assignment_actions_s.NEXTVAL
8795: INTO l_action_id
8796: FROM dual;
8797:
8798: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 8941: pay_in_utils.set_location(g_debug,'Inserting assignment action id in pay_assignment_actions ',40);

8937: IF (g_action)
8938: THEN
8939: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,110);
8940:
8941: pay_in_utils.set_location(g_debug,'Inserting assignment action id in pay_assignment_actions ',40);
8942: pay_in_utils.set_location(g_debug,'Inserting Asg Action ID for Deleted Element Entries ' ,50);
8943:
8944: pay_in_utils.set_location(g_debug,'Value of g_count_ee_delete is '|| g_count_ee_delete, 51);
8945: IF ((g_count_ee_delete > 1)AND (g_correction_mode <> 'Y'))

Line 8957: SELECT pay_assignment_actions_s.NEXTVAL

8953: CLOSE c_chk_asg_action;
8954:
8955: IF (l_dummy IS NULL)
8956: THEN
8957: SELECT pay_assignment_actions_s.NEXTVAL
8958: INTO l_action_id
8959: FROM dual;
8960:
8961: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9033: SELECT pay_assignment_actions_s.NEXTVAL

9029:
9030: pay_in_utils.set_location(g_debug,'Value of l_dummy is '|| l_dummy, 61);
9031: IF (l_dummy IS NULL)
9032: THEN
9033: SELECT pay_assignment_actions_s.NEXTVAL
9034: INTO l_action_id
9035: FROM dual;
9036:
9037: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9113: SELECT pay_assignment_actions_s.NEXTVAL

9109:
9110: pay_in_utils.set_location(g_debug,'Value of dummy is ' || l_dummy ,3);
9111: IF (l_dummy IS NULL)
9112: THEN
9113: SELECT pay_assignment_actions_s.NEXTVAL
9114: INTO l_action_id
9115: FROM dual;
9116:
9117: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9311: FROM pay_assignment_actions

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
9314: )
9315: AND action_context_type = 'AAP'

Line 9336: FROM pay_assignment_actions

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
9339: )
9340: AND action_context_type = 'AAP'

Line 9354: FROM pay_assignment_actions

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
9357: )
9358: AND action_context_type = 'AAP'

Line 9371: FROM pay_assignment_actions

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
9374: )
9375: AND action_context_type = 'AAP'

Line 9391: FROM pay_assignment_actions

9387: AND action_context_type = 'AAP'
9388: AND action_information10 = 'A'
9389: AND action_information11 = 'C4'
9390: AND action_context_id IN (SELECT assignment_action_id
9391: FROM pay_assignment_actions
9392: WHERE payroll_action_id = p_payroll_action_id)
9393: ORDER BY action_information3;
9394:
9395:

Line 9409: FROM pay_assignment_actions

9405: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9406: AND action_information10 = 'A'
9407: AND action_information11 = 'C4'
9408: AND action_context_id IN (SELECT assignment_action_id
9409: FROM pay_assignment_actions
9410: WHERE payroll_action_id = p_payroll_action_id)
9411: ORDER BY LENGTH(action_information1)
9412: ,action_information1
9413: ,source_id;

Line 9425: FROM pay_assignment_actions

9421: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9422: AND action_information10 = 'A'
9423: AND action_information11 = 'C4'
9424: AND action_context_id IN (SELECT assignment_action_id
9425: FROM pay_assignment_actions
9426: WHERE payroll_action_id = p_payroll_action_id);
9427:
9428:
9429: CURSOR cur_salary_recs(p_payroll_action_id NUMBER)

Line 9436: FROM pay_assignment_actions

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
9437: WHERE payroll_action_id = p_payroll_action_id
9438: AND assignment_id = pai.assignment_id)
9439: AND action_information3 = g_gre_id
9440: AND action_information2 = g_year||g_quarter;

Line 9448: ,pay_assignment_actions paa

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
9452: AND paa.payroll_action_id = p_24q_pay_action_id;