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_INTERLOCKS

Line 790: ,pay_action_interlocks locks

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

Line 900: ,pay_action_interlocks locks

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

Line 927: ,pay_action_interlocks locks

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

Line 989: ,pay_action_interlocks locks

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

Line 1016: ,pay_action_interlocks locks

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

Line 1240: ,pay_action_interlocks locks

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

Line 1885: FROM pay_action_interlocks intk,

1881: AND ppa.effective_date between g_start_date and g_end_date
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

Line 1902: ,pay_action_interlocks locks

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'
1906: AND pai.action_information10 IN ('D')

Line 1949: FROM pay_action_interlocks intk,

1945: AND ppa.effective_date between g_start_date and g_end_date
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

Line 1975: ,pay_action_interlocks locks

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

Line 2002: ,pay_action_interlocks locks

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

Line 2091: FROM pay_action_interlocks intk,

2087: AND ppa.effective_date between g_start_date and g_end_date
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

Line 2197: ,pay_action_interlocks locks

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)
2201: BETWEEN p_start_person AND p_end_person

Line 2271: FROM pay_action_interlocks intk,

2267: AND ppa.effective_date between g_start_date and g_end_date
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

Line 2547: FROM pay_action_interlocks intk,

2543: AND ppa.effective_date between g_start_date and g_end_date
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

Line 4595: ,pay_action_interlocks locks

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

Line 4644: ,pay_action_interlocks locks

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

Line 4731: FROM pay_action_interlocks intk,

4727: AND ppa.effective_date between p_start_date and p_end_date
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

Line 5261: ,pay_action_interlocks locks

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

Line 5310: ,pay_action_interlocks locks

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

Line 5359: FROM pay_action_interlocks intk,

5355: AND ppa.effective_date between g_start_date and g_end_date
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

Line 5392: FROM pay_action_interlocks intk,

5388: AND ppa.effective_date between g_start_date and g_end_date
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

Line 5412: ,pay_action_interlocks locks

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

Line 6641: ,pay_action_interlocks locks

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
6645: AND pai.action_information1 = p_challan_number

Line 6657: ,pay_action_interlocks locks

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

Line 8227: ,pay_action_interlocks pai

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;
8231:

Line 8237: FROM pay_action_interlocks pai

8233: ,p_locked_act_id NUMBER
8234: )
8235: IS
8236: SELECT 1
8237: FROM pay_action_interlocks pai
8238: WHERE pai.locking_action_id = p_locking_act_id
8239: AND pai.locked_action_id = p_locked_act_id;
8240:
8241: CURSOR c_select_prev_24qc

Line 8700: FROM pay_action_interlocks

8696: ,p_locked_action_id NUMBER
8697: )
8698: IS
8699: SELECT 1
8700: FROM pay_action_interlocks
8701: WHERE locking_action_id = p_locking_action_id
8702: AND locked_action_id = p_locked_action_id;
8703:
8704: CURSOR c_chk_asg_action(p_assignment_id NUMBER

Line 8716: FROM pay_action_interlocks

8712:
8713: CURSOR c_max_24qc_locking_24q(p_24qc_arc_asg_act_id NUMBER)
8714: IS
8715: SELECT max(locking_action_id)
8716: FROM pay_action_interlocks
8717: WHERE locked_action_id = p_24qc_arc_asg_act_id
8718: ORDER BY locking_action_id DESC;
8719:
8720: CURSOR c_select_prev_24qc(p_locked_pay_act_id_qc NUMBER)