[Home] [Help]
39: 20-Mar-2013 sampmand 115.26 16505555 modified decode logic of tax_basis in procedure fetch_tax_code_basis.
40: 22-Mar-2013 krreddy 115.128 16409794 Resolved the issue of incorrect picking of actions when no payment exists.
41: 25-Mar-2013 rajganga 115.28 16501443 Added sysdate+30 condition to Termination date in first fps.Added Det3 in First FPS.
42: 25-Mar-2013 rajganga 115.29 16542698 Resolved the NI Only and PAYE Aggr issues with No Payment Exist scenarios.
43: 26-Mar-2013 ssarap 115.128 16306737 Added a third party prepayment check for pay_pre_payments tables. Removed
44: the balances Pre Tax Deductions and NIable Deductions Free of Tax from 58B.
45: 28-Mar-2013 rajganga 115.30 16567045 Added 13 version report type in fetching first fps
46: 29-Mar-2013 ssarap 115.32 16555308 Changes to 58B calculation. Used the updated procedure fetch_HASH_FPS_PER.
47: Fetched the correct NI Employee values .
6888: AND (as1.payroll_id = p_payroll_id
6889: OR p_payroll_id IS NULL)
6890: AND appa2.payroll_action_id = p_pre_pact_id
6891: AND exists( select 1
6892: from pay_pre_payments ppp
6893: where ASSIGNMENT_ACTION_ID = act1.assignment_action_id
6894: and ppp.value <> 0)
6895: ORDER BY act.assignment_id;
6896:
7015: AND (as1.payroll_id = p_payroll_id
7016: OR p_payroll_id IS NULL)
7017: AND appa2.payroll_action_id = p_pre_pact_id
7018: AND exists( select 1
7019: from pay_pre_payments ppp
7020: where ASSIGNMENT_ACTION_ID = act1.assignment_action_id
7021: and ppp.value <> 0); --For the bug 16542698
7022:
7023: CURSOR csr_ni_aggr_max_act_id( p_person_id NUMBER,
7112: )
7113: AND ptp.regular_payment_date >= nvl (l_first_fps_run_date, l_first_fps_eff_date)
7114: AND paa.assignment_action_id < p_asg_act_id
7115: AND exists( select 1
7116: from pay_pre_payments ppp
7117: where ASSIGNMENT_ACTION_ID = paa1.assignment_action_id
7118: and ppp.value <> 0)
7119: GROUP BY paa.payroll_action_id,paa.assignment_id ;
7120: -- ORDER BY max_asg_act_id;
7249: and paa.assignment_id = c_ni_rpt_asg_id
7250: and ppa.action_type IN ('P','U')
7251: and paa.action_status IN ('C','S')
7252: AND exists( select 1
7253: from pay_pre_payments ppp
7254: where ASSIGNMENT_ACTION_ID = paa.assignment_action_id
7255: and ppp.value <> 0); --For the bug 16542698
7256:
7257: CURSOR csr_chk_earlier_processed (c_person_id number, c_cur_asg_action_id number) is
8957: CURSOR csr_bacs_payment_exists (c_prepay_payroll_action_id NUMBER,
8958: c_prepay_asg_action_id NUMBER)
8959: IS
8960: SELECT 'Y'
8961: FROM pay_pre_payments ppp,
8962: pay_payment_types ppt,
8963: pay_org_payment_methods_f popf,
8964: pay_personal_payment_methods_f pppf,
8965: pay_external_accounts Orgkey,
8982:
8983: CURSOR csr_total_payment (c_prepay_asg_action_id NUMBER)
8984: IS
8985: select (sum(ppp.value) * 100) amount
8986: from pay_pre_payments ppp,
8987: pay_org_payment_methods_f popmf,
8988: pay_assignment_actions paa,
8989: pay_payroll_actions ppa
8990: where ppp.ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id
8995:
8996: CURSOR csr_total_payment_new(c_prepay_asg_action_id NUMBER)
8997: IS
8998: select (sum(ppp.value) * 100) amount
8999: from pay_pre_payments ppp
9000: where ASSIGNMENT_ACTION_ID = c_prepay_asg_action_id;
9001:
9002: --Below cursor fetches the latest payroll run details of the current assignment
9003: 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)
9026: AND paa1.payroll_action_id = ppa1.payroll_action_id
9027: AND paa1.assignment_action_id = pai.locking_action_id
9028: AND paa.assignment_action_id = pai.locked_action_id
9029: AND exists( select 1
9030: from pay_pre_payments ppp
9031: where ASSIGNMENT_ACTION_ID = paa1.assignment_action_id
9032: and ppp.value <> 0); --For the bug 16542698
9033:
9034: /**********************************************************************************************
9460: AND act1.payroll_action_id = appa2.payroll_action_id
9461: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
9462: AND appa2.payroll_action_id = p_pre_pact_id
9463: AND exists( select 1
9464: from pay_pre_payments ppp
9465: where ASSIGNMENT_ACTION_ID = act1.assignment_action_id
9466: and ppp.value <> 0); --For the bug 16542698
9467:
9468: l_asg_primary_flag VARCHAR2(1);