[Home] [Help]
2043: pay_payroll_actions pact,
2044: per_time_periods ptp,
2045: pay_assignment_actions paa1, --Prepayments
2046: pay_payroll_actions ppa1, --Prepayments
2047: pay_action_interlocks pai --Prepayments
2048: WHERE paa.assignment_id = p_asgid
2049: AND paa.payroll_action_id = pact.payroll_action_id
2050: AND pact.time_period_id = ptp.time_period_id
2051: AND pact.action_type IN ('Q','R','B','I','V')
2106: from pay_assignment_actions paa_prepay,
2107: pay_payroll_actions ppa_prepay,
2108: pay_assignment_actions paa_fps,
2109: pay_payroll_actions ppa_fps,
2110: pay_action_interlocks pai
2111: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
2112: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
2113: and paa_prepay.assignment_action_id = pai.locked_action_id
2114: and paa_fps.assignment_action_id = pai.locking_action_id
2819: pay_payroll_actions pact,
2820: per_time_periods ptp,
2821: pay_assignment_actions paa1, --Prepayments
2822: pay_payroll_actions ppa1, --Prepayments
2823: pay_action_interlocks pai --Prepayments
2824: WHERE paa.assignment_id = p_asgid
2825: AND paa.payroll_action_id = pact.payroll_action_id
2826: AND pact.time_period_id = ptp.time_period_id
2827: AND pact.action_type IN ('Q','R','B','I','V')
2882: from pay_assignment_actions paa_prepay,
2883: pay_payroll_actions ppa_prepay,
2884: pay_assignment_actions paa_fps,
2885: pay_payroll_actions ppa_fps,
2886: pay_action_interlocks pai
2887: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
2888: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
2889: and paa_prepay.assignment_action_id = pai.locked_action_id
2890: and paa_fps.assignment_action_id = pai.locking_action_id
2930: pay_payroll_actions pact,
2931: per_time_periods ptp,
2932: pay_assignment_actions paa1, --Prepayments
2933: pay_payroll_actions ppa1, --Prepayments
2934: pay_action_interlocks pai --Prepayments
2935: WHERE paaf.person_id = p_person_rec.person_id--59437
2936: AND sysdate between paaf.effective_start_date and paaf.effective_end_date
2937: AND paa.assignment_id = paaf.assignment_id
2938: AND paa.payroll_action_id = pact.payroll_action_id
3622: pay_payroll_actions pact,
3623: per_time_periods ptp,
3624: pay_assignment_actions paa1, --Prepayments
3625: pay_payroll_actions ppa1, --Prepayments
3626: pay_action_interlocks pai --Prepayments
3627: WHERE paa.assignment_id = p_asgid
3628: AND paa.payroll_action_id = pact.payroll_action_id
3629: AND pact.time_period_id = ptp.time_period_id
3630: AND pact.action_type IN ('Q','R','B','I','V')
3685: from pay_assignment_actions paa_prepay,
3686: pay_payroll_actions ppa_prepay,
3687: pay_assignment_actions paa_fps,
3688: pay_payroll_actions ppa_fps,
3689: pay_action_interlocks pai
3690: where ppa_prepay.payroll_action_id = c_last_pre_pay_id
3691: and ppa_prepay.payroll_action_id = paa_prepay.payroll_action_id
3692: and paa_prepay.assignment_action_id = pai.locked_action_id
3693: and paa_fps.assignment_action_id = pai.locking_action_id
6869: pay_payroll_actions appa, --Payroll Run
6870: pay_payroll_actions appa2, --Prepayments
6871: pay_assignment_actions act, --Payroll Run
6872: pay_assignment_actions act1, --Prepayments
6873: pay_action_interlocks pai, --Prepayments
6874: per_all_assignments_f as1
6875: WHERE ppa.payroll_action_id = pactid
6876: AND as1.person_id BETWEEN stperson AND endperson
6877: AND appa.action_type IN ('R','Q','V','B') -- Payroll Run or Quickpay Run
6997: pay_payroll_actions appa, --Payroll Run
6998: pay_payroll_actions appa2, --Prepayments
6999: pay_assignment_actions act, --Payroll Run
7000: pay_assignment_actions act1, --Prepayments
7001: pay_action_interlocks pai, --Prepayments
7002: per_all_assignments_f as1
7003: WHERE as1.person_id = p_person_id --45885
7004: AND appa.action_type IN ('R','Q','V','B') -- Payroll Run or Quickpay Run
7005: AND act.payroll_action_id = appa.payroll_action_id
7032: pay_payroll_actions appa, --Payroll Run
7033: pay_payroll_actions appa2, --Prepayments
7034: pay_assignment_actions act, --Payroll Run
7035: pay_assignment_actions act1, --Prepayments
7036: pay_action_interlocks pai, --Prepayments
7037: per_all_assignments_f as1
7038: WHERE as1.person_id = p_person_id --45885
7039: AND appa.action_type IN ('R','Q') -- Payroll Run or Quickpay Run
7040: AND act.payroll_action_id = appa.payroll_action_id
7076: ,per_all_assignments_f paaf
7077: ,pay_payroll_actions pact
7078: ,pay_payroll_actions pact1
7079: ,per_time_periods ptp
7080: ,pay_action_interlocks pai
7081: WHERE paa.assignment_id = paaf.assignment_id
7082: AND paa.assignment_id <> p_asg_id
7083: AND paaf.person_id = p_person_id
7084: AND paa.payroll_action_id = pact.payroll_action_id
7134: ,per_all_assignments_f paaf
7135: ,pay_payroll_actions pact
7136: ,pay_payroll_actions pact1
7137: ,per_time_periods ptp
7138: ,pay_action_interlocks pai
7139: WHERE paa.assignment_id = paaf.assignment_id
7140: AND paa.assignment_id = p_asg_id
7141: AND paaf.person_id = p_person_id
7142: AND paa.payroll_action_id = pact.payroll_action_id
7176:
7177: cursor chk_processed_in_prepay(c_cur_asg_action_id number) is
7178: select pai.locking_action_id
7179: from
7180: pay_action_interlocks pai,
7181: pay_payroll_actions ppa,
7182: pay_assignment_actions paa
7183: where pai.locked_action_id = c_cur_asg_action_id
7184: and ppa.action_type in ('P','U')
7229:
7230: -- cursor to fetch the prepayment asg_action id for the given payroll asg_action id
7231: cursor csr_ni_prepay_asg_act_details(c_payroll_asg_act_id number) is
7232: select pai.locking_action_id prepay_asg_act_id from
7233: pay_action_interlocks pai,
7234: pay_assignment_actions paa,
7235: pay_payroll_actions ppa
7236: where pai.locked_action_id = c_payroll_asg_act_id
7237: and pai.locking_action_id = paa.assignment_action_id
7269: pay_payroll_actions pact,
7270: per_time_periods ptp,
7271: pay_assignment_actions paa1, --Prepayments
7272: pay_payroll_actions ppa1, --Prepayments
7273: pay_action_interlocks pai --Prepayments
7274: WHERE paa.assignment_id = paaf.assignment_id
7275: AND paaf.person_id = p_person_id
7276: AND paa.payroll_action_id = pact.payroll_action_id
7277: AND pact.time_period_id = ptp.time_period_id
7290: FROM pay_payroll_actions appa, --Payroll Run
7291: pay_payroll_actions appa2, --Prepayments
7292: pay_assignment_actions act, --Payroll Run
7293: pay_assignment_actions act1, --Prepayments
7294: pay_action_interlocks pai, --Prepayments
7295: per_all_assignments_f as1,
7296: pay_all_payrolls_f papf ,
7297: hr_soft_coding_keyflex flex
7298: WHERE as1.person_id = p_person_id --58105
8837: pay_payroll_actions pact,
8838: per_time_periods ptp,
8839: pay_assignment_actions paa1, --Prepayments
8840: pay_payroll_actions ppa1, --Prepayments
8841: pay_action_interlocks pai --Prepayments
8842: WHERE paa.assignment_id = p_asgid
8843: AND paa.payroll_action_id = pact.payroll_action_id
8844: AND pact.time_period_id = ptp.time_period_id
8845: AND pact.action_type IN ('Q','R','I','V','B')
8863: pay_payroll_actions pact,
8864: per_time_periods ptp,
8865: pay_assignment_actions paa1, --Prepayments
8866: pay_payroll_actions ppa1, --Prepayments
8867: pay_action_interlocks pai --Prepayments
8868: WHERE paa.assignment_id = p_asgid --46959
8869: AND paa.payroll_action_id = pact.payroll_action_id
8870: AND pact.time_period_id = ptp.time_period_id
8871: AND pact.action_type IN ('Q','R','I','V','B')
9012: pay_payroll_actions pact,
9013: per_time_periods ptp,
9014: pay_assignment_actions paa1, --Prepayments
9015: pay_payroll_actions ppa1, --Prepayments
9016: pay_action_interlocks pai --Prepayments
9017: WHERE paa.assignment_id = paaf.assignment_id
9018: AND paaf.person_id = p_person_id
9019: AND paa.payroll_action_id = pact.payroll_action_id
9020: AND pact.time_period_id = ptp.time_period_id
9115: -- CURSOR csr_processed_in_prepayment(c_prepay_asgactid NUMBER, c_payroll_asgactid NUMBER)
9116: CURSOR csr_processed_in_prepayment(c_prepay_asgactid NUMBER, c_payroll_asgactid NUMBER, c_payroll_master_asgactid number)
9117: IS
9118: SELECT 'Y' this_prepayment
9119: FROM pay_action_interlocks pai,
9120: pay_assignment_actions paa,
9121: pay_payroll_actions ppa
9122: WHERE paa.payroll_action_id = ppa.payroll_action_id
9123: AND paa.assignment_action_id = pai.locking_action_id
9127: OR pai.locked_action_id = c_payroll_master_asgactid );
9128:
9129: /*
9130: SELECT 'Y' this_prepayment
9131: FROM pay_action_interlocks pai
9132: WHERE locking_action_id = c_prepay_asgactid
9133: AND (locked_action_id = c_payroll_asgactid
9134: OR locked_action_id = c_payroll_master_asgactid );
9135: */
9333: cursor csr_chk_prepayment_run(c_assignment_action_id number) is
9334: select count(*) from pay_assignment_actions paa, --run
9335: pay_assignment_actions paa1, --Prepayments
9336: pay_payroll_actions ppa1, --Prepayments
9337: pay_action_interlocks pai --Prepayments
9338: where paa.assignment_action_id = c_assignment_action_id --9917796
9339: AND paa.assignment_action_id = pai.locked_action_id
9340: AND paa1.assignment_action_id = pai.locking_action_id
9341: AND paa1.payroll_action_id = ppa1.payroll_action_id
9352: pay_payroll_actions appa, --Payroll Run
9353: pay_payroll_actions appa2, --Prepayments
9354: pay_assignment_actions act, --Payroll Run
9355: pay_assignment_actions act1, --Prepayments
9356: pay_action_interlocks pai, --Prepayments
9357: per_all_assignments_f as1
9358: WHERE as1.person_id = p_person_id --45885
9359: AND appa.action_type IN ('R','Q') -- Payroll Run or Quickpay Run
9360: AND act.payroll_action_id = appa.payroll_action_id
9379: pay_payroll_actions appa, --Payroll Run
9380: pay_payroll_actions appa2, --Prepayments
9381: pay_assignment_actions act, --Payroll Run
9382: pay_assignment_actions act1, --Prepayments
9383: pay_action_interlocks pai, --Prepayments
9384: per_all_assignments_f as1
9385: WHERE as1.person_id = p_person_id --45885
9386: AND appa.action_type IN ('R','Q') -- Payroll Run or Quickpay Run
9387: AND act.payroll_action_id = appa.payroll_action_id
9405: pay_payroll_actions appa, --Payroll Run
9406: pay_payroll_actions appa2, --Prepayments
9407: pay_assignment_actions act, --Payroll Run
9408: pay_assignment_actions act1, --Prepayments
9409: pay_action_interlocks pai, --Prepayments
9410: per_all_assignments_f as1
9411: WHERE
9412: ppa.payroll_action_id = g_payroll_action_id
9413: AND as1.person_id = c_person_id --BETWEEN stperson AND endperson
9444: pay_payroll_actions appa, --Payroll Run
9445: pay_payroll_actions appa2, --Prepayments
9446: pay_assignment_actions act, --Payroll Run
9447: pay_assignment_actions act1, --Prepayments
9448: pay_action_interlocks pai, --Prepayments
9449: per_all_assignments_f as1
9450: WHERE as1.person_id = p_person_id --45885
9451: AND appa.action_type IN ('R','Q') -- Payroll Run or Quickpay Run
9452: AND act.payroll_action_id = appa.payroll_action_id
9613:
9614: cursor chk_processed_in_prepay(c_cur_asg_action_id number) is
9615: select pai.locking_action_id
9616: from
9617: pay_action_interlocks pai,
9618: pay_payroll_actions ppa,
9619: pay_assignment_actions paa
9620: where pai.locked_action_id = c_cur_asg_action_id
9621: and ppa.action_type in ('P','U')
9695: pay_payroll_actions pact,
9696: per_time_periods ptp,
9697: pay_assignment_actions paa1, --Prepayments
9698: pay_payroll_actions ppa1, --Prepayments
9699: pay_action_interlocks pai --Prepayments
9700: WHERE paa.assignment_id = paaf.assignment_id
9701: AND paaf.person_id = p_person_id
9702: AND paa.payroll_action_id = pact.payroll_action_id
9703: AND pact.time_period_id = ptp.time_period_id
10986:
10987: l_payroll_asg_acts(l_tab_counter) := l_cur_asg_action_id;
10988: begin
10989: select ppa.payroll_action_id into l_oth_min_pre_pay_id from
10990: pay_action_interlocks pai,
10991: pay_payroll_actions ppa,
10992: pay_assignment_actions paa
10993: where
10994: pai.locked_action_id = l_cur_asg_action_id