DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on STANDARD

Line 24: ** 28-NOV-2001 nnaresh 115.4 Updated for GSCC Standards

20: **
21: ** ============== Formula Fuctions ====================
22: ** Package containing addition processing required by
23: ** terminations module in AU localisatons.
24: ** 28-NOV-2001 nnaresh 115.4 Updated for GSCC Standards
25: ** 04-DEC-2002 Ragovind 115.6 Added NOCOPY for the functions check_rollover, etp_prepost_ratios,
26: ** get_long_service_leave, term_lsl_eligibility_years
27: ** 15-May-2003 Ragovind 115.7 Bug#2819479 - ETP Pre/Post Enhancement
28: ** 23-Jul-2003 Nanuradh 115.8 Bug#2984390 - ETP Pre/post Enhancement - Added an extra parameter p_etp_service_date

Line 292: p_earnings_standard out NOCOPY number, /*Bug# 4474896*/

288: p_hire_date in date,
289: p_period_start_date in date,
290: p_period_end_date in date,
291: p_case out NOCOPY varchar2,
292: p_earnings_standard out NOCOPY number, /*Bug# 4474896*/
293: p_pre_tax_spread out NOCOPY number, /*Bug# 4474896*/
294: p_pre_tax_fixed out NOCOPY number, /*Bug# 4474896*/
295: p_pre_tax_prog out NOCOPY number, /*Bug# 4474896*/
296: p_paid_periods out NOCOPY number, /*Bug# 4474896*/

Line 316: WHERE pbt.balance_name in ( 'Earnings_Standard'

312: SELECT pdb.defined_balance_id, pbt.balance_name, pbd.DIMENSION_NAME
313: FROM pay_balance_types pbt,
314: pay_balance_dimensions pbd,
315: pay_defined_balances pdb
316: WHERE pbt.balance_name in ( 'Earnings_Standard'
317: ,'Pre Tax Spread Deductions'
318: ,'Pre Tax Fixed Deductions' /*bug 4474896*/
319: ,'Pre Tax Progressive Deductions')
320: AND pbt.balance_type_id = pdb.balance_type_id