[Home] [Help]
285: where pai_pre.locking_action_id = cp_assignment_action_id
286: and exists (
287: select 1
288: from pay_payroll_actions ppa,
289: pay_assignment_actions paa,
290: pay_action_interlocks pai_run
291: /* Get the run assignment action id locked by pre-payment */
292: where pai_run.locked_action_id = pai_pre.locked_action_id
293: /* Check if the Run is being locked by Reversal */
303: ****************************************************************/
304: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
305: select paa.assignment_action_id
306: from pay_action_interlocks paci,
307: pay_assignment_actions paa,
308: pay_payroll_actions ppa
309: where paci.locking_action_id = cp_assignment_action_id
310: and paa.assignment_action_id = paci.locked_action_id
311: and ppa.payroll_action_id = paa.payroll_action_id
321: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
322: select paa_pre.assignment_action_id
323: from pay_action_interlocks pai_run,
324: pay_action_interlocks pai_pre,
325: pay_assignment_actions paa_pre,
326: pay_payroll_actions ppa_pre
327: where pai_run.locking_action_id = cp_assignment_action_id
328: and pai_pre.locked_action_id = pai_run.locked_action_id
329: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
332:
333: cursor c_get_date_earned(cp_assignment_action_id in number) is
334: select nvl(max(ppa.date_earned), max(ppa.effective_date))
335: from pay_payroll_actions ppa
336: ,pay_assignment_actions paa
337: ,pay_action_interlocks pai
338: where ppa.payroll_action_id = paa.payroll_action_id
339: and pai.locked_action_id = paa.assignment_action_id
340: and pai.locking_action_id = cp_assignment_action_id
435: exit;
436: end if;
437:
438: lv_payment_status := ltrim(rtrim(
439: pay_assignment_actions_pkg.get_payment_status_code
440: (ln_prepay_action_id,
441: ln_pre_payment_id)));
442:
443: if lv_payment_status <> 'P' then
856: where pai_pre.locking_action_id = cp_assignment_action_id
857: and exists (
858: select 1
859: from pay_payroll_actions ppa,
860: pay_assignment_actions paa,
861: pay_action_interlocks pai_run
862: /* Get the run assignment action id locked by pre-payment */
863: where pai_run.locked_action_id = pai_pre.locked_action_id
864: /* Check if the Run is being locked by Reversal */
874: ****************************************************************/
875: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
876: select paa.assignment_action_id
877: from pay_action_interlocks paci,
878: pay_assignment_actions paa,
879: pay_payroll_actions ppa
880: where paci.locking_action_id = cp_assignment_action_id
881: and paa.assignment_action_id = paci.locked_action_id
882: and ppa.payroll_action_id = paa.payroll_action_id
892: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
893: select paa_pre.assignment_action_id
894: from pay_action_interlocks pai_run,
895: pay_action_interlocks pai_pre,
896: pay_assignment_actions paa_pre,
897: pay_payroll_actions ppa_pre
898: where pai_run.locking_action_id = cp_assignment_action_id
899: and pai_pre.locked_action_id = pai_run.locked_action_id
900: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
904: --Modified Cursor for bug 8550075
905: CURSOR c_get_date_earned(cp_assignment_action_id IN NUMBER) IS
906: SELECT nvl(MAX(ppa.date_earned), MAX(ppa.effective_date)), MAX(ppa.effective_date), BUSINESS_GROUP_ID
907: FROM pay_payroll_actions ppa
908: , pay_assignment_actions paa
909: , pay_action_interlocks pai
910: WHERE ppa.payroll_action_id = paa.payroll_action_id
911: AND pai.locked_action_id = paa.assignment_action_id
912: AND pai.locking_action_id = cp_assignment_action_id
927: *****************************************************************/
928:
929: cursor c_purge_run(cp_assignment_action_id in number) is
930: select 1
931: from pay_assignment_actions paa
932: where paa.assignment_action_id = cp_assignment_action_id
933: and not exists
934: (select 1
935: from pay_action_interlocks ai
934: (select 1
935: from pay_action_interlocks ai
936: where ai.locking_action_id = paa.assignment_action_id )
937: and exists
938: (select 1 from pay_assignment_actions paa2,
939: pay_payroll_actions ppa2
940: where paa2.assignment_id = paa.assignment_id
941: and paa2.payroll_action_id = ppa2.payroll_action_id
942: and ppa2.action_type = 'Z');
973: *****************************************************************/
974:
975: cursor c_get_completion_status(cp_assignment_action_id in number) is
976: select 1
977: from pay_assignment_actions paa,
978: pay_payroll_actions ppa
979: where paa.assignment_action_id = cp_assignment_action_id
980: and paa.payroll_action_id = ppa.payroll_action_id
981: and paa.assignment_id = p_assignment_id
1220: exit;
1221: end if;
1222:
1223: lv_payment_status := ltrim(rtrim(
1224: pay_assignment_actions_pkg.get_payment_status_code
1225: (ln_prepay_action_id,
1226: ln_pre_payment_id)));
1227:
1228: if lv_payment_status <> 'P' then
1296:
1297: cursor c_get_date_earned(cp_assignment_action_id in number) is
1298: select nvl(max(ppa.date_earned), max(ppa.effective_date))
1299: from pay_payroll_actions ppa
1300: ,pay_assignment_actions paa
1301: ,pay_action_interlocks pai
1302: where ppa.payroll_action_id = paa.payroll_action_id
1303: and pai.locked_action_id = paa.assignment_action_id
1304: and pai.locking_action_id = cp_assignment_action_id
1386: select prrv.result_value
1387: from pay_run_results prr,
1388: pay_run_result_values prrv,
1389: pay_input_values_f piv,
1390: pay_assignment_actions paa,
1391: pay_payroll_actions ppa
1392: where prr.element_type_id = piv.element_type_id
1393: and prr.run_result_id = prrv.run_result_id
1394: and prr.source_type = 'E'
1408: select prrv.result_value
1409: from pay_run_results prr,
1410: pay_run_result_values prrv,
1411: pay_input_values_f piv,
1412: pay_assignment_actions paa,
1413: pay_payroll_actions ppa
1414: where prr.element_type_id = piv.element_type_id
1415: and prr.run_result_id = prrv.run_result_id
1416: and prr.source_type = 'E'
1708: select decode(ppa_pymt.action_type,
1709: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
1710: paa_pymt.serial_number)
1711: from pay_pre_payments ppp,
1712: pay_assignment_actions paa_pymt,
1713: pay_payroll_actions ppa_pymt,
1714: pay_action_interlocks pai
1715: where pai.locked_action_id = cp_pre_payment_action
1716: and paa_pymt.assignment_action_id = pai.locking_action_id
1720: and ppp.pre_payment_id = paa_pymt.pre_payment_id
1721: and not exists (
1722: select 1
1723: from pay_payroll_actions ppa,
1724: pay_assignment_actions paa,
1725: pay_action_interlocks pai_void
1726: /* Assignment Action of Payment Type - NACHA/Check */
1727: where pai_void.locked_action_id = paa_pymt.assignment_action_id --Void
1728: /* Check if the locking is that of Void Pymt */
2609: CURSOR get_locked_act_id (v_action_context_id pay_action_interlocks.locking_action_id%TYPE) IS
2610: SELECT
2611: paci.locked_action_id
2612: FROM pay_action_interlocks paci,
2613: pay_assignment_actions paa,
2614: pay_payroll_actions ppa
2615: WHERE paci.locking_action_id = v_action_context_id
2616: AND paa.assignment_action_id = paci.locked_action_id
2617: AND ppa.payroll_action_id = paa.payroll_action_id
2915: WHERE pai_pre.locking_action_id = cp_assignment_action_id
2916: AND EXISTS (
2917: SELECT 1
2918: FROM pay_payroll_actions ppa,
2919: pay_assignment_actions paa,
2920: pay_action_interlocks pai_run
2921: /* Get the run assignment action id locked by pre-payment */
2922: WHERE pai_run.locked_action_id = pai_pre.locked_action_id
2923: /* Check if the Run is being locked by Reversal */
2933: ****************************************************************/
2934: CURSOR c_prepay_arch_action(cp_assignment_action_id IN NUMBER) IS
2935: SELECT paa.assignment_action_id
2936: FROM pay_action_interlocks paci,
2937: pay_assignment_actions paa,
2938: pay_payroll_actions ppa
2939: WHERE paci.locking_action_id = cp_assignment_action_id
2940: AND paa.assignment_action_id = paci.locked_action_id
2941: AND ppa.payroll_action_id = paa.payroll_action_id
2951: CURSOR c_prepay_run_arch_action(cp_assignment_action_id IN NUMBER) IS
2952: SELECT paa_pre.assignment_action_id
2953: FROM pay_action_interlocks pai_run,
2954: pay_action_interlocks pai_pre,
2955: pay_assignment_actions paa_pre,
2956: pay_payroll_actions ppa_pre
2957: WHERE pai_run.locking_action_id = cp_assignment_action_id
2958: AND pai_pre.locked_action_id = pai_run.locked_action_id
2959: AND paa_pre.assignment_Action_id = pai_pre.locking_action_id
2963: --Modified Cursor for bug 8550075
2964: CURSOR c_get_date_earned(cp_assignment_action_id IN NUMBER) IS
2965: SELECT nvl(MAX(ppa.date_earned), MAX(ppa.effective_date)), MAX(ppa.effective_date), BUSINESS_GROUP_ID
2966: FROM pay_payroll_actions ppa
2967: , pay_assignment_actions paa
2968: , pay_action_interlocks pai
2969: WHERE ppa.payroll_action_id = paa.payroll_action_id
2970: AND pai.locked_action_id = paa.assignment_action_id
2971: AND pai.locking_action_id = cp_assignment_action_id
3115: EXIT;
3116: END IF;
3117:
3118: lv_payment_status := ltrim(rtrim(
3119: pay_assignment_actions_pkg.get_payment_status_code
3120: (ln_prepay_action_id,
3121: ln_pre_payment_id)));
3122:
3123: IF lv_payment_status <> 'P' THEN