DBA Data[Home] [Help]

APPS.PAY_NL_WTS_REPORT dependencies on PAY_BALANCE_PKG

Line 291: abs(pay_balance_pkg.get_value(decode(prr.element_type_id,

287: to_char(ppa.date_earned,'MonthYYYY') current_period,
288: paa.assignment_id,
289: pay.payroll_name payroll_name,
290: ppa.date_earned,
291: abs(pay_balance_pkg.get_value(decode(prr.element_type_id,
292: Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),Get_Defined_Balance_Id('Wage Tax Subsidy Low Wages'),
293: Get_Element_Type_Id('Wage Tax Subsidy Education'),Get_Defined_Balance_Id('Wage Tax Subsidy Education'),
294: Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'),Get_Defined_Balance_Id('Wage Tax Subsidy Long Term Unemployed'),
295: Get_Element_Type_Id('Wage Tax Subsidy Paid Parental Leave'),Get_Defined_Balance_Id('Wage Tax Subsidy Paid Parental Leave')),asg_act.assignment_action_id)) Wage_Tax_Subsidy,

Line 840: abs(pay_balance_pkg.get_value(decode(prr.element_type_id,

836: to_char(ppa.date_earned,'MonthYYYY') current_period,
837: paa.assignment_id,
838: pay.payroll_name payroll_name,
839: ppa.date_earned,
840: abs(pay_balance_pkg.get_value(decode(prr.element_type_id,
841: --RSS
842: Get_Element_Type_Id('Wage Tax Subsidy EVC'),Get_Defined_Balance_Id('Wage Tax Subsidy EVC'),
843: --RSS
844: Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),Get_Defined_Balance_Id('Wage Tax Subsidy Low Wages'),