APPS.PAY_EOSURVEY_PKG dependencies on PAY_BALANCE_PKG

Line 1475: monetary_comp:= pay_balance_pkg.get_value(p_defined_balance_id,

1471:
1472: hr_utility.trace('tenure_months = '||to_char(tenure_months));
1473:
1474:
1475: monetary_comp:= pay_balance_pkg.get_value(p_defined_balance_id,
1476: p_max_asact_id);
1477: hr_utility.trace('monetary_comp for new emp = '||to_char(monetary_comp));
1478:
1479: ELSE /*for the employees who have joined before 31-dec-yy

Line 1487: monetary_comp:= pay_balance_pkg.get_value(p_defined_balance_id,

1483: OPEN asact_id(p_assignment_id,calendar_period_end);
1484: FETCH asact_id INTO l_asact_id;
1485: CLOSE asact_id;
1486:
1487: monetary_comp:= pay_balance_pkg.get_value(p_defined_balance_id,
1488: l_asact_id);
1489:
1490: tenure_years:= trunc(months_between(calendar_period_end,p_per_actual_start_date)/12);
1491: tenure_months:=round(mod(months_between(calendar_period_end,p_per_actual_start_date),12));

Line 1507: monetary_comp:= pay_balance_pkg.get_value(p_defined_balance_id,

1503: tenure_months:=round(mod(months_between(p_period_end,p_per_actual_start_date),12));
1504:
1505: /*Asact id calculated in the action_Creation is used here to calcualte the comp. */
1506:
1507: monetary_comp:= pay_balance_pkg.get_value(p_defined_balance_id,
1508: p_max_asact_id);
1509:
1510: END IF;
1511: