[Home] [Help]
1129: p_info.sequenced_flag := TRUE;
1130: --
1131: select null
1132: into dummy
1133: from pay_action_classifications CLASS
1134: where CLASS.action_type = p_info.action_type
1135: and CLASS.classification_name = 'SEQUENCED';
1136: if g_debug then
1137: hr_utility.trace('this action type IS sequenced');
2222: where not exists
2223: (select null
2224: from pay_assignment_actions ACT,
2225: pay_payroll_actions PACT,
2226: pay_action_classifications CLASS
2227: where ACT.assignment_id = p_info.assignment_id
2228: and ACT.action_sequence > l_action_sequence
2229: and ACT.action_status in ('C', 'S')
2230: and ACT.payroll_action_id = PACT.payroll_action_id
2236: where not exists
2237: (select null
2238: from pay_assignment_actions ACT,
2239: pay_payroll_actions PACT,
2240: pay_action_classifications CLASS
2241: where ACT.assignment_id = p_info.assignment_id
2242: and ACT.action_sequence > l_action_sequence
2243: and ACT.action_status in ('C', 'S','M')
2244: and ACT.payroll_action_id = PACT.payroll_action_id
2260: select null into dummy
2261: from dual
2262: where not exists
2263: (select null
2264: from pay_action_classifications CLASS,
2265: pay_payroll_actions PACT,
2266: pay_assignment_actions ACT,
2267: pay_object_groups POG_ASG,
2268: pay_object_groups POG_PER,
2282: select null into dummy
2283: from dual
2284: where not exists
2285: (select null
2286: from pay_action_classifications CLASS,
2287: pay_payroll_actions PACT,
2288: pay_assignment_actions ACT,
2289: pay_object_groups POG_ASG,
2290: pay_object_groups POG_PER,
2308: select null into dummy
2309: from dual
2310: where not exists
2311: (select null
2312: from pay_action_classifications CLASS,
2313: pay_payroll_actions PACT,
2314: pay_assignment_actions ACT,
2315: pay_object_groups POG_ASG,
2316: pay_object_groups POG_ASG2
2328: select null into dummy
2329: from dual
2330: where not exists
2331: (select null
2332: from pay_action_classifications CLASS,
2333: pay_payroll_actions PACT,
2334: pay_assignment_actions ACT,
2335: pay_object_groups POG_ASG,
2336: pay_object_groups POG_ASG2
2359: select null into dummy
2360: from dual
2361: where not exists
2362: (select null
2363: from pay_action_classifications CLASS,
2364: pay_payroll_actions PACT,
2365: pay_assignment_actions ACT,
2366: per_all_assignments_f ASS,
2367: per_periods_of_service POS
2377: select null into dummy
2378: from dual
2379: where not exists
2380: (select null
2381: from pay_action_classifications CLASS,
2382: pay_payroll_actions PACT,
2383: pay_assignment_actions ACT,
2384: per_all_assignments_f ASS,
2385: per_periods_of_service POS