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 718: ,pay_assignment_actions paa

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

Line 791: ,pay_assignment_actions paa

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

Line 792: ,pay_assignment_actions paa_24qc

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'
794: AND locks.locking_action_id = pai.action_context_id
795: AND locks.locked_action_id = paa.assignment_action_id
796: AND paa.payroll_action_id = g_24q_payroll_act_id

Line 866: ,pay_assignment_actions paa

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

Line 901: ,pay_assignment_actions paa

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

Line 902: ,pay_assignment_actions masters

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'
904: AND pai.action_information15 = 'D'
905: AND locks.locking_action_id = pai.action_context_id
906: AND locks.locked_action_id = paa.assignment_action_id

Line 928: ,pay_assignment_actions paa

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

Line 929: ,pay_assignment_actions masters

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'
931: AND pai.action_information15 = 'A'
932: AND locks.locking_action_id = pai.action_context_id
933: AND locks.locked_action_id = paa.assignment_action_id

Line 969: ,pay_assignment_actions paa

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

Line 978: ,pay_assignment_actions paa

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

Line 990: ,pay_assignment_actions paa

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

Line 991: ,pay_assignment_actions paa_24qc

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'
993: AND locks.locking_action_id = pai.action_context_id
994: AND locks.locked_action_id = paa.assignment_action_id
995: AND paa.payroll_action_id = p_payroll_action_id

Line 1017: ,pay_assignment_actions paa

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

Line 1018: ,pay_assignment_actions paa_24qc

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'
1020: AND locks.locking_action_id = pai.action_context_id
1021: AND locks.locked_action_id = paa.assignment_action_id
1022: AND paa.payroll_action_id = p_payroll_action_id

Line 1173: ,pay_assignment_actions paa

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

Line 1241: ,pay_assignment_actions paa

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

Line 1271: ,pay_assignment_actions paa

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'
1273: AND paa.assignment_action_id = pai.action_context_id
1274: AND pai.source_id = p_element_entry_id
1275: AND paa.payroll_action_id IN

Line 1402: ,pay_assignment_actions paa

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

Line 1426: ,pay_assignment_actions paa

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

Line 1844: ,pay_assignment_actions paa

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

Line 1871: FROM pay_assignment_actions paa

1867: pai.source_id NOT IN
1868: (
1869: SELECT
1870: paa.assignment_action_id run_asg_action_id
1871: FROM pay_assignment_actions paa
1872: ,pay_payroll_actions ppa
1873: ,per_assignments_f paf
1874: WHERE paf.assignment_id = paa.assignment_id
1875: AND paa.assignment_id = pai.assignment_id

Line 1886: pay_assignment_actions paa1,

1882: AND paa.source_action_id IS NULL
1883: AND (1 = DECODE(ppa.action_type,'I',1,0)
1884: OR EXISTS (SELECT ''
1885: FROM pay_action_interlocks intk,
1886: pay_assignment_actions paa1,
1887: pay_payroll_actions ppa1
1888: WHERE intk.locked_action_id = paa.assignment_Action_id
1889: AND intk.locking_action_id = paa1.assignment_action_id
1890: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 1903: ,pay_assignment_actions paa

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

Line 1904: ,pay_assignment_actions masters

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

Line 1935: FROM pay_assignment_actions paa

1931: (SELECT
1932: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
1933: ,paf.assignment_id assignment_id
1934: ,NULL last_action_context_id
1935: FROM pay_assignment_actions paa
1936: ,pay_payroll_actions ppa
1937: ,per_assignments_f paf
1938: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
1939: AND paf.assignment_id = paa.assignment_id

Line 1950: pay_assignment_actions paa1,

1946: AND paa.source_action_id IS NULL
1947: AND (1 = DECODE(ppa.action_type,'I',1,0)
1948: OR EXISTS (SELECT ''
1949: FROM pay_action_interlocks intk,
1950: pay_assignment_actions paa1,
1951: pay_payroll_actions ppa1
1952: WHERE intk.locked_action_id = paa.assignment_Action_id
1953: AND intk.locking_action_id = paa1.assignment_action_id
1954: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 1965: ,pay_assignment_actions paa

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

Line 1976: ,pay_assignment_actions paa

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

Line 1977: ,pay_assignment_actions paa_24qc

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'
1979: AND locks.locking_action_id = pai.action_context_id
1980: AND locks.locked_action_id = paa.assignment_action_id
1981: AND paa.payroll_action_id = p_payroll_action_id

Line 2003: ,pay_assignment_actions paa

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

Line 2004: ,pay_assignment_actions paa_24qc

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'
2006: AND locks.locking_action_id = pai.action_context_id
2007: AND locks.locked_action_id = paa.assignment_action_id
2008: AND paa.payroll_action_id = p_payroll_action_id

Line 2029: ,pay_assignment_actions paa_24qc

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

Line 2059: ,pay_assignment_actions paa

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

Line 2076: FROM pay_assignment_actions paa

2072: AND pai.source_id IN
2073: (
2074: SELECT
2075: paa.assignment_action_id run_asg_action_id
2076: FROM pay_assignment_actions paa
2077: ,pay_payroll_actions ppa
2078: ,per_assignments_f paf
2079: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2080: AND paf.assignment_id = paa.assignment_id

Line 2092: pay_assignment_actions paa1,

2088: AND paa.source_action_id IS NULL
2089: AND (1 = DECODE(ppa.action_type,'I',1,0)
2090: OR EXISTS (SELECT ''
2091: FROM pay_action_interlocks intk,
2092: pay_assignment_actions paa1,
2093: pay_payroll_actions ppa1
2094: WHERE intk.locked_action_id = paa.assignment_Action_id
2095: AND intk.locking_action_id = paa1.assignment_action_id
2096: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 2198: ,pay_assignment_actions paa

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

Line 2229: ,pay_assignment_actions paa

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

Line 2256: FROM pay_assignment_actions paa

2252: AND pai.source_id IN
2253: (
2254: SELECT
2255: paa.assignment_action_id run_asg_action_id
2256: FROM pay_assignment_actions paa
2257: ,pay_payroll_actions ppa
2258: ,per_assignments_f paf
2259: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2260: AND paf.assignment_id = paa.assignment_id

Line 2272: pay_assignment_actions paa1,

2268: AND paa.source_action_id IS NULL
2269: AND (1 = DECODE(ppa.action_type,'I',1,0)
2270: OR EXISTS (SELECT ''
2271: FROM pay_action_interlocks intk,
2272: pay_assignment_actions paa1,
2273: pay_payroll_actions ppa1
2274: WHERE intk.locked_action_id = paa.assignment_Action_id
2275: AND intk.locking_action_id = paa1.assignment_action_id
2276: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 2477: ,pay_assignment_actions paa

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

Line 2506: ,pay_assignment_actions paa

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

Line 2533: FROM pay_assignment_actions paa

2529: (SELECT
2530: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
2531: ,paf.assignment_id assignment_id
2532: ,NULL last_action_context_id
2533: FROM pay_assignment_actions paa
2534: ,pay_payroll_actions ppa
2535: ,per_assignments_f paf
2536: WHERE paf.person_id BETWEEN p_start_person AND p_end_person
2537: AND paf.assignment_id = paa.assignment_id

Line 2548: pay_assignment_actions paa1,

2544: AND paa.source_action_id IS NULL
2545: AND (1 = DECODE(ppa.action_type,'I',1,0)
2546: OR EXISTS (SELECT ''
2547: FROM pay_action_interlocks intk,
2548: pay_assignment_actions paa1,
2549: pay_payroll_actions ppa1
2550: WHERE intk.locked_action_id = paa.assignment_Action_id
2551: AND intk.locking_action_id = paa1.assignment_action_id
2552: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 4570: ,pay_assignment_actions paa

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

Line 4594: ,pay_assignment_actions paa

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

Line 4596: ,pay_assignment_actions paa_master

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'
4598: AND pai.assignment_id = p_assignment_id
4599: AND pai.action_information3 = g_gre_id
4600: AND pai.action_information2 = g_year||g_quarter

Line 4643: ,pay_assignment_actions paa

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

Line 4645: ,pay_assignment_actions paa_master

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'
4647: AND pai.assignment_id = p_assignment_id
4648: AND pai.action_information3 = g_gre_id
4649: AND pai.action_information2 = g_year||g_quarter

Line 4678: ,pay_assignment_actions paa

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

Line 4698: ,pay_assignment_actions paa

4694: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
4695: ,scl.segment1
4696: FROM per_assignments_f asg
4697: ,hr_soft_coding_keyflex scl
4698: ,pay_assignment_actions paa
4699: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
4700: AND paa.assignment_action_id = p_action_context_id
4701: AND asg.assignment_id = paa.assignment_id
4702: AND paa.assignment_id = p_assignment_id

Line 4717: FROM pay_assignment_actions paa

4713: ,p_assignment_id NUMBER
4714: )
4715: IS
4716: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
4717: FROM pay_assignment_actions paa
4718: ,pay_payroll_actions ppa
4719: ,per_assignments_f paf
4720: WHERE paf.assignment_id = paa.assignment_id
4721: AND paf.assignment_id = p_assignment_id

Line 4732: pay_assignment_actions paa1,

4728: AND paa.source_action_id IS NULL
4729: AND (1 = DECODE(ppa.action_type,'I',1,0)
4730: OR EXISTS (SELECT ''
4731: FROM pay_action_interlocks intk,
4732: pay_assignment_actions paa1,
4733: pay_payroll_actions ppa1
4734: WHERE intk.locked_action_id = paa.assignment_Action_id
4735: AND intk.locking_action_id = paa1.assignment_action_id
4736: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 4750: FROM pay_assignment_actions paa

4746: IS
4747: SELECT paa.assignment_id
4748: ,paa.payroll_action_id
4749: ,paf.person_id
4750: FROM pay_assignment_actions paa
4751: ,per_all_assignments_f paf
4752: WHERE paa.assignment_action_id = p_action_context_id
4753: AND paa.assignment_id = paf.assignment_id
4754: AND ROWNUM =1;

Line 5235: ,pay_assignment_actions paa

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

Line 5260: ,pay_assignment_actions paa

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

Line 5262: ,pay_assignment_actions paa_master

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'
5264: AND pai.action_information3 = g_gre_id
5265: AND pai.action_information2 = g_year||g_quarter
5266: AND pai.action_information1 = p_person_id

Line 5287: ,pay_assignment_actions paa

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

Line 5309: ,pay_assignment_actions paa

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

Line 5311: ,pay_assignment_actions paa_master

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'
5313: AND pai.action_information3 = g_gre_id
5314: AND pai.action_information2 = g_year||g_quarter
5315: AND locks.locking_action_id = pai.action_context_id

Line 5336: FROM pay_assignment_actions

5332: p_assignment_id NUMBER
5333: )
5334: IS
5335: SELECT assignment_action_id
5336: FROM pay_assignment_actions
5337: WHERE payroll_action_id = p_payroll_action_id
5338: AND assignment_id = p_assignment_id;
5339:
5340: CURSOR c_max_pact(p_assignment_id NUMBER)

Line 5345: FROM pay_assignment_actions paa

5341: IS
5342: SELECT
5343: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5344: ,paf.assignment_id assignment_id
5345: FROM pay_assignment_actions paa
5346: ,pay_payroll_actions ppa
5347: ,per_assignments_f paf
5348: WHERE paf.assignment_id = paa.assignment_id
5349: AND paf.assignment_id =p_assignment_id

Line 5360: pay_assignment_actions paa1,

5356: AND paa.source_action_id IS NULL
5357: AND (1 = DECODE(ppa.action_type,'I',1,0)
5358: OR EXISTS (SELECT ''
5359: FROM pay_action_interlocks intk,
5360: pay_assignment_actions paa1,
5361: pay_payroll_actions ppa1
5362: WHERE intk.locked_action_id = paa.assignment_Action_id
5363: AND intk.locking_action_id = paa1.assignment_action_id
5364: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 5377: FROM pay_assignment_actions paa

5373: IS
5374: SELECT
5375: FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) source_id
5376: ,paf.assignment_id assignment_id
5377: FROM pay_assignment_actions paa
5378: ,pay_payroll_actions ppa
5379: ,per_assignments_f paf
5380: WHERE paf.assignment_id = paa.assignment_id
5381: AND paf.assignment_id =p_assignment_id

Line 5393: pay_assignment_actions paa1,

5389: AND paa.source_action_id IS NULL
5390: AND (1 = DECODE(ppa.action_type,'I',1,0)
5391: OR EXISTS (SELECT ''
5392: FROM pay_action_interlocks intk,
5393: pay_assignment_actions paa1,
5394: pay_payroll_actions ppa1
5395: WHERE intk.locked_action_id = paa.assignment_Action_id
5396: AND intk.locking_action_id = paa1.assignment_action_id
5397: AND paa1.payroll_action_id =ppa1.payroll_action_id

Line 5411: ,pay_assignment_actions paa

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

Line 5413: ,pay_assignment_actions paa_master

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'
5415: AND pai.assignment_id = p_assignment_id
5416: AND pai.action_information3 = g_gre_id
5417: AND pai.action_information2 = g_year||g_quarter

Line 6614: ,pay_assignment_actions paa

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

Line 6626: ,pay_assignment_actions paa

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

Line 6640: ,pay_assignment_actions paa

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

Line 6656: ,pay_assignment_actions paa

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

Line 6658: ,pay_assignment_actions paa_master

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'
6660: AND pai.action_information3 = g_gre_id
6661: AND pai.action_information2 = g_year||g_quarter
6662: AND pai.action_information1 = p_challan_number

Line 6682: ,pay_assignment_actions paa

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

Line 6702: FROM pay_assignment_actions

6698:
6699: CURSOR c_asg_act_id(p_assignment_id NUMBER)
6700: IS
6701: SELECT assignment_action_id
6702: FROM pay_assignment_actions
6703: WHERE payroll_action_id = p_payroll_action_id
6704: AND assignment_id = p_assignment_id;
6705:
6706: tab_24q_ee_data t_screen_entry_value_rec;

Line 8218: FROM pay_assignment_actions

8214: CURSOR c_assignment_action_id(p_payroll_action_id NUMBER)
8215: IS
8216: SELECT assignment_action_id
8217: ,assignment_id
8218: FROM pay_assignment_actions
8219: WHERE payroll_action_id = p_payroll_action_id;
8220:
8221: CURSOR c_chk_asg_action(p_assignment_id NUMBER
8222: ,p_payroll_action_id NUMBER

Line 8226: FROM pay_assignment_actions paa

8222: ,p_payroll_action_id NUMBER
8223: )
8224: IS
8225: SELECT assignment_action_id
8226: FROM pay_assignment_actions paa
8227: ,pay_action_interlocks pai
8228: WHERE paa.assignment_id = p_assignment_id
8229: AND paa.assignment_action_id = pai.locking_action_id
8230: AND paa.payroll_action_id = p_payroll_action_id;

Line 8273: SELECT pay_assignment_actions_s.NEXTVAL

8269: FETCH c_chk_asg_action INTO l_action_id;
8270: CLOSE c_chk_asg_action;
8271: IF (l_action_id IS NULL)
8272: THEN
8273: SELECT pay_assignment_actions_s.NEXTVAL
8274: INTO l_action_id
8275: FROM dual;
8276:
8277: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);

Line 8309: SELECT pay_assignment_actions_s.NEXTVAL

8305: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
8306:
8307: IF (l_action_id IS NULL)
8308: THEN
8309: SELECT pay_assignment_actions_s.NEXTVAL
8310: INTO l_action_id
8311: FROM dual;
8312:
8313: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 8361: SELECT pay_assignment_actions_s.NEXTVAL

8357: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
8358:
8359: IF (l_action_id IS NULL)
8360: THEN
8361: SELECT pay_assignment_actions_s.NEXTVAL
8362: INTO l_action_id
8363: FROM dual;
8364:
8365: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 8422: ,pay_assignment_actions paa

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

Line 8709: FROM pay_assignment_actions

8705: ,p_payroll_act_id NUMBER
8706: )
8707: IS
8708: SELECT assignment_action_id
8709: FROM pay_assignment_actions
8710: WHERE payroll_action_id = p_payroll_act_id
8711: AND assignment_id = p_assignment_id;
8712:
8713: CURSOR c_max_24qc_locking_24q(p_24qc_arc_asg_act_id NUMBER)

Line 8896: SELECT pay_assignment_actions_s.NEXTVAL

8892: pay_in_utils.trace('l_dummy in g_count_sal_delete ',l_dummy);
8893:
8894: IF (l_dummy IS NULL)
8895: THEN
8896: SELECT pay_assignment_actions_s.NEXTVAL
8897: INTO l_action_id
8898: FROM dual;
8899:
8900: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9045: SELECT pay_assignment_actions_s.NEXTVAL

9041: pay_in_utils.trace('l_dummy in g_count_sal_addition ',l_dummy);
9042:
9043: IF (l_dummy IS NULL)
9044: THEN
9045: SELECT pay_assignment_actions_s.NEXTVAL
9046: INTO l_action_id
9047: FROM dual;
9048:
9049: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9196: SELECT pay_assignment_actions_s.NEXTVAL

9192: pay_in_utils.trace('l_dummy in g_count_sal_update ',l_dummy);
9193:
9194: IF (l_dummy IS NULL)
9195: THEN
9196: SELECT pay_assignment_actions_s.NEXTVAL
9197: INTO l_action_id
9198: FROM dual;
9199:
9200: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

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

9339: IF (g_action)
9340: THEN
9341: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,110);
9342:
9343: pay_in_utils.set_location(g_debug,'Inserting assignment action id in pay_assignment_actions ',40);
9344: pay_in_utils.set_location(g_debug,'Inserting Asg Action ID for Deleted Element Entries ' ,50);
9345:
9346: pay_in_utils.set_location(g_debug,'Value of g_count_ee_delete is '|| g_count_ee_delete, 51);
9347: IF ((g_count_ee_delete > 1)AND (g_correction_mode <> 'Y'))

Line 9359: SELECT pay_assignment_actions_s.NEXTVAL

9355: CLOSE c_chk_asg_action;
9356:
9357: IF (l_dummy IS NULL)
9358: THEN
9359: SELECT pay_assignment_actions_s.NEXTVAL
9360: INTO l_action_id
9361: FROM dual;
9362:
9363: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9435: SELECT pay_assignment_actions_s.NEXTVAL

9431:
9432: pay_in_utils.set_location(g_debug,'Value of l_dummy is '|| l_dummy, 61);
9433: IF (l_dummy IS NULL)
9434: THEN
9435: SELECT pay_assignment_actions_s.NEXTVAL
9436: INTO l_action_id
9437: FROM dual;
9438:
9439: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9515: SELECT pay_assignment_actions_s.NEXTVAL

9511:
9512: pay_in_utils.set_location(g_debug,'Value of dummy is ' || l_dummy ,3);
9513: IF (l_dummy IS NULL)
9514: THEN
9515: SELECT pay_assignment_actions_s.NEXTVAL
9516: INTO l_action_id
9517: FROM dual;
9518:
9519: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9713: FROM pay_assignment_actions

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
9716: )
9717: AND action_context_type = 'AAP'

Line 9738: FROM pay_assignment_actions

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
9741: )
9742: AND action_context_type = 'AAP'

Line 9756: FROM pay_assignment_actions

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
9759: )
9760: AND action_context_type = 'AAP'

Line 9773: FROM pay_assignment_actions

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
9776: )
9777: AND action_context_type = 'AAP'

Line 9793: FROM pay_assignment_actions

9789: AND action_context_type = 'AAP'
9790: AND action_information10 = 'A'
9791: AND action_information11 = 'C4'
9792: AND action_context_id IN (SELECT assignment_action_id
9793: FROM pay_assignment_actions
9794: WHERE payroll_action_id = p_payroll_action_id)
9795: ORDER BY action_information3;
9796:
9797:

Line 9811: FROM pay_assignment_actions

9807: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9808: AND action_information10 = 'A'
9809: AND action_information11 = 'C4'
9810: AND action_context_id IN (SELECT assignment_action_id
9811: FROM pay_assignment_actions
9812: WHERE payroll_action_id = p_payroll_action_id)
9813: ORDER BY LENGTH(action_information1)
9814: ,action_information1
9815: ,source_id;

Line 9827: FROM pay_assignment_actions

9823: AND action_information3 = fnd_number.canonical_to_number(p_gre_id)
9824: AND action_information10 = 'A'
9825: AND action_information11 = 'C4'
9826: AND action_context_id IN (SELECT assignment_action_id
9827: FROM pay_assignment_actions
9828: WHERE payroll_action_id = p_payroll_action_id);
9829:
9830:
9831: CURSOR cur_salary_recs(p_payroll_action_id NUMBER)

Line 9838: FROM pay_assignment_actions

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
9839: WHERE payroll_action_id = p_payroll_action_id
9840: AND assignment_id = pai.assignment_id)
9841: AND action_information3 = g_gre_id
9842: AND action_information2 = g_year||g_quarter;

Line 9850: ,pay_assignment_actions paa

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