[Home] [Help]
19: ** 19-DEC-2000 abajpai 115.2 Added new function convert_to_period_amt, round_amount
20: ** ============== Formula Fuctions ====================
21: ** Package containing addition processing required by
22: ** formula in AU localisatons.
23: ** 28-NOV-2001 nnaresh 115.5 Updated for GSCC Standards
24: ** 8-JAN-2002 apunekar 115.6 Additional functions added.
25: ** 18-May-2002 apunekar 115.6 Additional function added.
26: ** 17-Sep-2002 Ragovind 115.13 Modified the function check_fixed_deduction declaration
27: ** 03-Dec-2002 Ragovind 115.14 Added NOCOPY for the function get_retro_period.
141: p_assignment_action_id IN number, /* Bug#4467198*/
142: p_payroll_id IN NUMBER, /* Bug#4467198*/
143: p_period_start_date in date,
144: p_case out NOCOPY varchar2,
145: p_earnings_standard out NOCOPY number,
146: p_pre_tax_spread out NOCOPY number,
147: p_pre_tax_fixed out NOCOPY number, /*bug4363057*/
148: p_pre_tax_prog out NOCOPY number, /*bug4363057*/
149: p_paid_periods out NOCOPY number,
153:
154: -----------------------------------------------------------------------
155: -- Cursor : c_get_ytd_def_bal_ids
156: -- Description : To get the YTD defined balance ids for the balances
157: -- Earnings_Standard and Pre Tax Deductions
158: --
159: -----------------------------------------------------------------------
160: CURSOR c_get_ytd_def_bal_ids (c_db_item_suffix IN pay_balance_dimensions.DATABASE_ITEM_SUFFIX%type)
161: IS
162: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
163: FROM pay_balance_types pbt,
164: pay_balance_dimensions pbd,
165: pay_defined_balances pdb
166: WHERE pbt.balance_name in ( 'Earnings_Standard'
167: ,'Pre Tax Spread Deductions'
168: ,'Pre Tax Fixed Deductions' /*bug4363057*/
169: ,'Pre Tax Progressive Deductions')
170: AND pbt.balance_type_id = pdb.balance_type_id