eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_SICKNESS_DP202 dependencies on PAY_BALANCE_PKG

Line 89: sum(pay_balance_pkg.get_value(

85: ROWNUM=1;
86:
87: CURSOR csr_pay(asg_act_id NUMBER ) IS
88: SELECT
89: sum(pay_balance_pkg.get_value(
90: get_defined_balance_id(pbt.balance_name,'_ASG_PTD',p_business_group_id)
91: ,asg_act_id)) - pay_balance_pkg.get_value(
92: get_defined_balance_id('Employee AMB Deduction','_ASG_PTD',p_business_group_id)
93: ,asg_act_id) pay_value

Line 91: ,asg_act_id)) - pay_balance_pkg.get_value(

87: CURSOR csr_pay(asg_act_id NUMBER ) IS
88: SELECT
89: sum(pay_balance_pkg.get_value(
90: get_defined_balance_id(pbt.balance_name,'_ASG_PTD',p_business_group_id)
91: ,asg_act_id)) - pay_balance_pkg.get_value(
92: get_defined_balance_id('Employee AMB Deduction','_ASG_PTD',p_business_group_id)
93: ,asg_act_id) pay_value
94: FROM
95: pay_balance_types pbt