[Home] [Help]
1134: p_info.sequenced_flag := TRUE;
1135: --
1136: select null
1137: into dummy
1138: from pay_action_classifications CLASS
1139: where CLASS.action_type = p_info.action_type
1140: and CLASS.classification_name = 'SEQUENCED';
1141: if g_debug then
1142: hr_utility.trace('this action type IS sequenced');
2304: where not exists
2305: (select null
2306: from pay_assignment_actions ACT,
2307: pay_payroll_actions PACT,
2308: pay_action_classifications CLASS
2309: where ACT.assignment_id = p_info.assignment_id
2310: and ACT.action_sequence > l_action_sequence
2311: and ACT.action_status in ('C', 'S')
2312: and ACT.payroll_action_id = PACT.payroll_action_id
2318: where not exists
2319: (select null
2320: from pay_assignment_actions ACT,
2321: pay_payroll_actions PACT,
2322: pay_action_classifications CLASS
2323: where ACT.assignment_id = p_info.assignment_id
2324: and ACT.action_sequence > l_action_sequence
2325: and ACT.action_status in ('C', 'S','M')
2326: and ACT.payroll_action_id = PACT.payroll_action_id
2344: select null into dummy
2345: from dual
2346: where not exists
2347: (select null
2348: from pay_action_classifications CLASS,
2349: pay_payroll_actions PACT,
2350: pay_assignment_actions ACT,
2351: pay_object_groups POG_ASG,
2352: pay_object_groups POG_PER,
2366: select null into dummy
2367: from dual
2368: where not exists
2369: (select null
2370: from pay_action_classifications CLASS,
2371: pay_payroll_actions PACT,
2372: pay_assignment_actions ACT,
2373: pay_object_groups POG_ASG,
2374: pay_object_groups POG_PER,
2393: select null into dummy
2394: from dual
2395: where not exists
2396: (select null
2397: from pay_action_classifications CLASS,
2398: pay_payroll_actions PACT,
2399: pay_assignment_actions ACT,
2400: pay_object_groups POG_ASG,
2401: pay_object_groups POG_ASG2
2413: select null into dummy
2414: from dual
2415: where not exists
2416: (select null
2417: from pay_action_classifications CLASS,
2418: pay_payroll_actions PACT,
2419: pay_assignment_actions ACT,
2420: pay_object_groups POG_ASG,
2421: pay_object_groups POG_ASG2
2446: select null into dummy
2447: from dual
2448: where not exists
2449: (select null
2450: from pay_action_classifications CLASS,
2451: pay_payroll_actions PACT,
2452: pay_assignment_actions ACT,
2453: per_all_assignments_f ASS,
2454: per_periods_of_service POS
2464: select null into dummy
2465: from dual
2466: where not exists
2467: (select null
2468: from pay_action_classifications CLASS,
2469: pay_payroll_actions PACT,
2470: pay_assignment_actions ACT,
2471: per_all_assignments_f ASS,
2472: per_periods_of_service POS