[Home] [Help]
345: c_defined_bal_id IN NUMBER,
346: c_source_id IN NUMBER)
347: is
348: SELECT palb.value
349: FROM pay_assignment_latest_balances palb,
350: pay_balance_context_values pbcv
351: WHERE pbcv.context_id = c_source_id
352: AND palb.latest_balance_id = pbcv.latest_balance_id
353: AND palb.assignment_action_id = c_assignment_action_id
1123: --
1124: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);
1125: if l_defined_bal_id is not null then
1126: --
1127: /* -- Run balances will never have a value in pay_assignment_latest_balances
1128: -- table, as they are only used for the duration of the payroll run.
1129: -- We therefore don't need to check the table, time can be saved by
1130: -- simply calling the route code, which is incidentally the most
1131: -- performant (ie simple) route. */
1726: --
1727: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);
1728: if l_defined_bal_id is not null then
1729: --
1730: /* -- This balances will never have a value in pay_assignment_latest_balances
1731: -- table, as they are only used for the duration of the payroll run.
1732: -- We therefore don't need to check the table, time can be saved by
1733: -- simply calling the route code, which is incidentally the most
1734: -- performant (ie simple) route. */
2589: --
2590: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);
2591: if l_defined_bal_id is not null then
2592: --
2593: /* -- Run balances will never have a value in pay_assignment_latest_balances
2594: -- table, as they are only used for the duration of the payroll run.
2595: -- We therefore don't need to check the table, time can be saved by
2596: -- simply calling the route code, which is incidentally the most
2597: -- performant (ie simple) route. */