[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
1143: --
1144: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_run);
1145: if l_defined_bal_id is not null then
1146: --
1147: /* -- Run balances will never have a value in pay_assignment_latest_balances
1148: -- table, as they are only used for the duration of the payroll run.
1149: -- We therefore don't need to check the table, time can be saved by
1150: -- simply calling the route code, which is incidentally the most
1151: -- performant (ie simple) route. */
1746: --
1747: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd_jp);
1748: if l_defined_bal_id is not null then
1749: --
1750: /* -- This balances will never have a value in pay_assignment_latest_balances
1751: -- table, as they are only used for the duration of the payroll run.
1752: -- We therefore don't need to check the table, time can be saved by
1753: -- simply calling the route code, which is incidentally the most
1754: -- performant (ie simple) route. */
2609: --
2610: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_retro);
2611: if l_defined_bal_id is not null then
2612: --
2613: /* -- Run balances will never have a value in pay_assignment_latest_balances
2614: -- table, as they are only used for the duration of the payroll run.
2615: -- We therefore don't need to check the table, time can be saved by
2616: -- simply calling the route code, which is incidentally the most
2617: -- performant (ie simple) route. */