[Home] [Help]
721: IS
722: SELECT pai.action_information1
723: ,MAX(pai.action_context_id)
724: FROM pay_action_information pai
725: ,pay_action_interlocks locks
726: ,pay_assignment_actions paa
727: ,pay_assignment_actions paa_24qc
728: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
729: AND locks.locking_action_id = pai.action_context_id
831: AND (
832: pai.source_id NOT IN
833: (SELECT pai.source_id
834: FROM pay_action_information pai
835: ,pay_action_interlocks locks
836: ,pay_assignment_actions paa
837: ,pay_assignment_actions masters
838: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
839: AND pai.action_information15 = 'D'
858: pay_in_utils.get_ee_value(pai.source_id,'Challan or Voucher Number') NOT IN
859: (
860: (SELECT pai.action_information1
861: FROM pay_action_information pai
862: ,pay_action_interlocks locks
863: ,pay_assignment_actions paa
864: ,pay_assignment_actions masters
865: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
866: AND pai.action_information15 = 'A'
920: AND (
921: entry.element_entry_id NOT IN
922: (SELECT pai.source_id
923: FROM pay_action_information pai
924: ,pay_action_interlocks locks
925: ,pay_assignment_actions paa
926: ,pay_assignment_actions paa_24qc
927: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
928: AND locks.locking_action_id = pai.action_context_id
947: pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') NOT IN
948: (
949: (SELECT pai.action_information1
950: FROM pay_action_information pai
951: ,pay_action_interlocks locks
952: ,pay_assignment_actions paa
953: ,pay_assignment_actions paa_24qc
954: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
955: AND locks.locking_action_id = pai.action_context_id
1129: )
1130: IS
1131: SELECT pai_locking.action_context_id last_action_context_id
1132: FROM pay_action_information pai_locking
1133: ,pay_action_interlocks locks
1134: ,pay_assignment_actions paa
1135: WHERE pai_locking.action_information_category = 'IN_24QC_DEDUCTEE'
1136: AND pai_locking.action_information3 = g_gre_id
1137: AND pai_locking.action_information15 = p_mode
1774: AND ppa.effective_date between g_start_date and g_end_date
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
1791: AND (
1792: pai.source_id NOT IN
1793: (SELECT pai.source_id
1794: FROM pay_action_information pai
1795: ,pay_action_interlocks locks
1796: ,pay_assignment_actions paa
1797: ,pay_assignment_actions masters
1798: WHERE pai.action_information_category = 'IN_24QC_PERSON'
1799: AND pai.action_information10 IN ('D')
1838: AND ppa.effective_date between g_start_date and g_end_date
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
1864: AND (
1865: a.source_id NOT IN
1866: (SELECT pai.source_id
1867: FROM pay_action_information pai
1868: ,pay_action_interlocks locks
1869: ,pay_assignment_actions paa
1870: ,pay_assignment_actions paa_24qc
1871: WHERE pai.action_information_category = 'IN_24QC_PERSON'
1872: AND locks.locking_action_id = pai.action_context_id
1891: AND (
1892: a.source_id NOT IN
1893: (SELECT pai.source_id
1894: FROM pay_action_information pai
1895: ,pay_action_interlocks locks
1896: ,pay_assignment_actions paa
1897: ,pay_assignment_actions paa_24qc
1898: WHERE pai.action_information_category = 'IN_24QC_PERSON'
1899: AND locks.locking_action_id = pai.action_context_id
1980: AND ppa.effective_date between g_start_date and g_end_date
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
2086: )
2087: IS
2088: SELECT pai_locking.action_context_id last_action_context_id
2089: FROM pay_action_information pai_locking
2090: ,pay_action_interlocks locks
2091: ,pay_assignment_actions paa
2092: WHERE pai_locking.action_information_category = 'IN_24QC_PERSON'
2093: AND fnd_number.canonical_to_number(pai_locking.action_information1)
2094: BETWEEN p_start_person AND p_end_person
2160: AND ppa.effective_date between g_start_date and g_end_date
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
2436: AND ppa.effective_date between g_start_date and g_end_date
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
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
4275: AND pai.action_information3 = g_gre_id
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
4324: AND pai.action_information3 = g_gre_id
4403: AND ppa.effective_date between p_start_date and p_end_date
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
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
4941: AND pai.action_information2 = g_year||g_quarter
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
4990: AND pai.action_information2 = g_year||g_quarter
5031: AND ppa.effective_date between g_start_date and g_end_date
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
5064: AND ppa.effective_date between g_start_date and g_end_date
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
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
5092: AND pai.action_information3 = g_gre_id
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
6321: AND pai.action_information1 = p_challan_number
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
6337: AND pai.action_information2 = g_year||g_quarter
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;
7852:
7854: ,p_locked_act_id NUMBER
7855: )
7856: IS
7857: SELECT 1
7858: FROM pay_action_interlocks pai
7859: WHERE pai.locking_action_id = p_locking_act_id
7860: AND pai.locked_action_id = p_locked_act_id;
7861:
7862: CURSOR c_select_prev_24qc
8294: ,p_locked_action_id NUMBER
8295: )
8296: IS
8297: SELECT 1
8298: FROM pay_action_interlocks
8299: WHERE locking_action_id = p_locking_action_id
8300: AND locked_action_id = p_locked_action_id;
8301:
8302: CURSOR c_chk_asg_action(p_assignment_id NUMBER
8310:
8311: CURSOR c_max_24qc_locking_24q(p_24qc_arc_asg_act_id NUMBER)
8312: IS
8313: SELECT max(locking_action_id)
8314: FROM pay_action_interlocks
8315: WHERE locked_action_id = p_24qc_arc_asg_act_id
8316: ORDER BY locking_action_id DESC;
8317:
8318: CURSOR c_select_prev_24qc(p_locked_pay_act_id_qc NUMBER)