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