APPS.PAY_FR_DADS_EMP_PKG dependencies on PAY_BALANCE_PKG

Line 2932: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));

2928: from fnd_sessions
2929: where session_id = userenv('sessionid');
2930: if l_session_id > 0 then
2931: -- find the SMIC rate
2932: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2933: else
2934: /* 4172068 insert a record only if there is no record exists in fnd_sessions table */
2935: -- insert a row into fnd_sessions for the DBI value to be retrieved
2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);

Line 2938: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));

2934: /* 4172068 insert a record only if there is no record exists in fnd_sessions table */
2935: -- insert a row into fnd_sessions for the DBI value to be retrieved
2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);
2937: -- find the SMIC rate
2938: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2939: -- delete the row from fnd_sessions
2940: Delete from fnd_sessions where session_id = userenv('sessionid');
2941: end if;
2942: /* 4172068 */

Line 3969: l_value := l_value +pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

3965: --
3966: For get_assign_rec In get_assign_actions
3967: Loop
3968: Begin
3969: l_value := l_value +pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
3970: ,p_assignment_action_id => get_assign_rec.assignment_action_id);
3971: EXCEPTION
3972: WHEN NO_DATA_FOUND THEN
3973: l_value := 0;