APPS.PAY_SE_ABSENCE dependencies on PAY_BALANCE_PKG

Line 2982: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id/*189398*/);

2978: /* Logic to change the Sick Pay and Sickness Deduction, if the waiting day has crossed for bug 5718434 */
2979: /* Get the value from the balance */
2980: /*If balance value is less than 10 then waiting day can be one */
2981:
2982: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id/*189398*/);
2983: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_WAITING_DAY_ASG_13MONTH');
2984: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2985:
2986: CLOSE csr_Get_Defined_Balance_Id;

Line 2987: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2983: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_WAITING_DAY_ASG_13MONTH');
2984: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2985:
2986: CLOSE csr_Get_Defined_Balance_Id;
2987: l_value:=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2988: P_ASSIGNMENT_ID => p_assignment_id, --22145,
2989: P_VIRTUAL_DATE=> p_pay_end_date/*TO_DATE('28-feb-2000')*/);
2990:
2991: /*If the balance value is greater than 10 then check from the run results,

Line 3326: /*pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id/*1305752*/--);

3322:
3323: l_basic_amount_month:=(7.5*l_global_value/12);
3324:
3325: /* Get the monthly Salary value from balance */
3326: /*pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id/*1305752*/--);
3327: /*pay_balance_pkg.set_context('DATE_EARNED',p_effective_date/*'28-feb-2000'*/--);
3328:
3329: /*OPEN csr_Get_Defined_Balance_Id( 'SICK_PAY_AFTER_14_MONTHLY_PAY_ASG_MONTH');
3330: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 3327: /*pay_balance_pkg.set_context('DATE_EARNED',p_effective_date/*'28-feb-2000'*/--);

3323: l_basic_amount_month:=(7.5*l_global_value/12);
3324:
3325: /* Get the monthly Salary value from balance */
3326: /*pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id/*1305752*/--);
3327: /*pay_balance_pkg.set_context('DATE_EARNED',p_effective_date/*'28-feb-2000'*/--);
3328:
3329: /*OPEN csr_Get_Defined_Balance_Id( 'SICK_PAY_AFTER_14_MONTHLY_PAY_ASG_MONTH');
3330: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
3331: CLOSE csr_Get_Defined_Balance_Id;

Line 3333: l_value :=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

3329: /*OPEN csr_Get_Defined_Balance_Id( 'SICK_PAY_AFTER_14_MONTHLY_PAY_ASG_MONTH');
3330: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
3331: CLOSE csr_Get_Defined_Balance_Id;
3332:
3333: l_value :=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
3334: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id/*1305752*/--),0);
3335: /*l_monthly_salary:=l_value;*/
3336: l_monthly_salary:=p_monthly_pay;
3337: --checking salaried person