[Home] [Help]
165: 22-Mar-2013 krreddy 115.131 16409794 Resolved the issue of incorrect picking of actions when no payment exists.
166: 25-Mar-2013 krreddy 115.132 16542698 Resolved the NI Only and PAYE Aggr issues with No Payment Exist scenarios.
167: 26-Mar-2013 krreddy 115.133 16459087 Modified two cursor queries in internal_action_creation to improve performance.
168: 16503199 Updated the Starter Declaration validation logic.
169: 26-Mar-2013 ssarap 115.128 16306737 Added a third party prepayment check for pay_pre_payments tables. Removed
170: the balances Pre Tax Deductions and NIable Deductions Free of Tax from 58B.
171: 29-Mar-2013 ssarap 115.35 16555308 Changes to 58B calculation. Used the updated procedure fetch_HASH_FPS_PER.
172: Fetched the correct NI Employee values .
173: ============================================================================*/
6217: AND as1.payroll_id = p_payroll_id
6218: --OR p_payroll_id IS NULL)
6219: AND appa2.payroll_action_id = p_pre_pact_id
6220: AND exists( select 1
6221: from pay_pre_payments ppp
6222: where ASSIGNMENT_ACTION_ID = act1.assignment_action_id
6223: and ppp.value <> 0)
6224: ORDER BY act.assignment_id;
6225:
6346: AND (as1.payroll_id = p_payroll_id
6347: OR p_payroll_id IS NULL)
6348: AND appa2.payroll_action_id = p_pre_pact_id
6349: AND exists( select 1
6350: from pay_pre_payments ppp
6351: where ASSIGNMENT_ACTION_ID = act1.assignment_action_id
6352: and ppp.value <> 0); --For the bug 16542698
6353:
6354:
6444: )
6445: AND ptp.regular_payment_date >= nvl (l_first_fps_run_date, l_first_fps_eff_date)
6446: AND paa.assignment_action_id < p_asg_act_id
6447: AND exists( select 1
6448: from pay_pre_payments ppp
6449: where ASSIGNMENT_ACTION_ID = paa1.assignment_action_id
6450: and ppp.value <> 0)
6451: GROUP BY paa.payroll_action_id,paa.assignment_id ;
6452: -- ORDER BY max_asg_act_id;
6580: and paa.assignment_id = c_ni_rpt_asg_id
6581: and ppa.action_type IN ('P','U')
6582: and paa.action_status IN ('C','S')
6583: AND exists( select 1
6584: from pay_pre_payments ppp
6585: where ASSIGNMENT_ACTION_ID = paa.assignment_action_id
6586: and ppp.value <> 0); --For the bug 16542698
6587:
6588: CURSOR csr_chk_earlier_processed (c_person_id number, c_cur_asg_action_id number) is
8323: CURSOR csr_bacs_payment_exists (c_prepay_payroll_action_id NUMBER,
8324: c_prepay_asg_action_id NUMBER)
8325: IS
8326: SELECT 'Y'
8327: FROM pay_pre_payments ppp,
8328: pay_payment_types ppt,
8329: pay_org_payment_methods_f popf,
8330: pay_personal_payment_methods_f pppf,
8331: pay_external_accounts Orgkey,
8348:
8349: CURSOR csr_total_payment (c_prepay_asg_action_id NUMBER)
8350: IS
8351: select (sum(ppp.value) * 100) amount
8352: from pay_pre_payments ppp,
8353: pay_org_payment_methods_f popmf,
8354: pay_assignment_actions paa,
8355: pay_payroll_actions ppa
8356: where ppp.ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id
8361:
8362: CURSOR csr_total_payment_new(c_prepay_asg_action_id NUMBER)
8363: IS
8364: select (sum(ppp.value) * 100) amount
8365: from pay_pre_payments ppp
8366: where ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id;
8367:
8368: --Below cursor fetches the latest payroll run details of the current assignment
8369: CURSOR csr_aggr_last_payroll_action(p_person_id NUMBER, p_pre_pay_id NUMBER, p_asg_start DATE, p_start_year DATE, p_end_year DATE)
8392: AND paa1.payroll_action_id = ppa1.payroll_action_id
8393: AND paa1.assignment_action_id = pai.locking_action_id
8394: AND paa.assignment_action_id = pai.locked_action_id
8395: AND exists( select 1
8396: from pay_pre_payments ppp
8397: where ASSIGNMENT_ACTION_ID = paa1.assignment_action_id
8398: and ppp.value <> 0); --For the bug 16542698
8399:
8400: /**********************************************************************************************
8825: AND act1.payroll_action_id = appa2.payroll_action_id
8826: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
8827: AND appa2.payroll_action_id = p_pre_pact_id
8828: AND exists( select 1
8829: from pay_pre_payments ppp
8830: where ASSIGNMENT_ACTION_ID = act1.assignment_action_id
8831: and ppp.value <> 0); --For the bug 16542698
8832:
8833: l_asg_primary_flag VARCHAR2(1);