DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP201 dependencies on PAY_BALANCE_PKG

Line 91: SUM (pay_balance_pkg.get_value(

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

Line 93: ,asg_act_id)) - pay_balance_pkg.get_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