519: hr_jprts.g_asg_itd,
520: hr_jprts.g_payment,
521: hr_jprts.g_asg_fytd2_jp
522: ) then
523: l_balance := pay_balance_pkg.get_value(
524: p_defined_balance_id,
525: p_assignment_action_id);
526: --
527: elsif l_dimension_name = hr_jprts.g_retro then
554: l_to_date,
555: l_action_sequence);
556: --
557: -- User Defined Dimension
558: -- pay_balance_pkg.get_value cannot be used for user defined dimension.
559: -- route refer to pay_jp_balances_v(call hr_jpbal.balance this code).
560: --
561: -- rtrim is used for support dimension that was created before bug2597843 fix.
562: --
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. */
1152: --
1153: l_balance := pay_balance_pkg.get_value(
1154: l_defined_bal_id,
1155: p_assignment_action_id);
1156: --
1157: else l_balance := null;
1297: --
1298: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_proc_ptd);
1299: --
1300: if l_defined_bal_id is not null then
1301: l_balance := pay_balance_pkg.get_value(
1302: l_defined_bal_id,
1303: p_assignment_action_id);
1304: --
1305: else
1442: --
1443: l_defined_bal_id := dimension_relevant(p_balance_type_id,hr_jprts.g_asg_mtd_jp);
1444: --
1445: if l_defined_bal_id is not null then
1446: l_balance := pay_balance_pkg.get_value(
1447: l_defined_bal_id,
1448: p_assignment_action_id);
1449: --
1450: else
1583: --
1584: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_ast_ytd_jp);
1585: --
1586: if l_defined_bal_id is not null then
1587: l_balance := pay_balance_pkg.get_value(
1588: l_defined_bal_id,
1589: p_assignment_action_id);
1590: --
1591: else
1915: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_fytd2_jp);
1916: --
1917: if l_defined_bal_id is not null then
1918: --
1919: l_balance := pay_balance_pkg.get_value(
1920: l_defined_bal_id,
1921: p_assignment_action_id);
1922: --
1923: else
2062: l_defined_bal_id := dimension_relevant(p_balance_type_id, pyjpexc.c_asg_aprtd);
2063: --
2064: if l_defined_bal_id is not null then
2065: --
2066: l_balance := pay_balance_pkg.get_value(
2067: l_defined_bal_id,
2068: p_assignment_action_id);
2069: --
2070: else
2205: --
2206: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_aug2jul_jp);
2207: --
2208: if l_defined_bal_id is not null then
2209: l_balance := pay_balance_pkg.get_value(
2210: l_defined_bal_id,
2211: p_assignment_action_id);
2212: --
2213: else
2343: --
2344: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_jul2jun_jp);
2345: --
2346: if l_defined_bal_id is not null then
2347: l_balance := pay_balance_pkg.get_value(
2348: l_defined_bal_id,
2349: p_assignment_action_id);
2350: --
2351: else
2467: --
2468: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_asg_itd);
2469: --
2470: if l_defined_bal_id is not null then
2471: l_balance := pay_balance_pkg.get_value(
2472: l_defined_bal_id,
2473: p_assignment_action_id);
2474: --
2475: else
2756: --
2757: l_defined_bal_id := dimension_relevant(p_balance_type_id, hr_jprts.g_payment);
2758: --
2759: if l_defined_bal_id is not null then
2760: l_balance := pay_balance_pkg.get_value(
2761: l_defined_bal_id,
2762: p_assignment_action_id);
2763: --
2764: else
2795: --
2796: -- Fix bug#3083339: Set context to identify element name in the element level
2797: -- dimension rows.
2798: --
2799: -- This set source_id will be used in pay_balance_pkg.get_value function.
2800: pay_balance_pkg.set_context(
2801: p_context_name => 'ORIGINAL_ENTRY_ID',
2802: p_context_value => p_source_id);
2803: --
2796: -- Fix bug#3083339: Set context to identify element name in the element level
2797: -- dimension rows.
2798: --
2799: -- This set source_id will be used in pay_balance_pkg.get_value function.
2800: pay_balance_pkg.set_context(
2801: p_context_name => 'ORIGINAL_ENTRY_ID',
2802: p_context_value => p_source_id);
2803: --
2804: l_balance := pay_balance_pkg.get_value(
2800: pay_balance_pkg.set_context(
2801: p_context_name => 'ORIGINAL_ENTRY_ID',
2802: p_context_value => p_source_id);
2803: --
2804: l_balance := pay_balance_pkg.get_value(
2805: l_defined_bal_id,
2806: p_assignment_action_id);
2807: end if;
2808: else
2838: l_defined_bal_id,
2839: p_source_id);
2840: if l_balance is null then
2841: --
2842: -- This set source_id will be used in pay_balance_pkg.get_value function.
2843: pay_balance_pkg.set_context(
2844: p_context_name => 'ORIGINAL_ENTRY_ID',
2845: p_context_value => p_source_id);
2846: l_balance := pay_balance_pkg.get_value(
2839: p_source_id);
2840: if l_balance is null then
2841: --
2842: -- This set source_id will be used in pay_balance_pkg.get_value function.
2843: pay_balance_pkg.set_context(
2844: p_context_name => 'ORIGINAL_ENTRY_ID',
2845: p_context_value => p_source_id);
2846: l_balance := pay_balance_pkg.get_value(
2847: l_defined_bal_id,
2842: -- This set source_id will be used in pay_balance_pkg.get_value function.
2843: pay_balance_pkg.set_context(
2844: p_context_name => 'ORIGINAL_ENTRY_ID',
2845: p_context_value => p_source_id);
2846: l_balance := pay_balance_pkg.get_value(
2847: l_defined_bal_id,
2848: p_assignment_action_id);
2849: --l_balance := hr_routes.element_ptd(
2850: -- p_assignment_action_id,