1975: and ppa.payroll_action_id = paa.payroll_action_id;
1976: --
1977: begin
1978: --
1979: l_defined_balance_id := dimension_relevant(p_balance_type_id, pyjpexc.c_asg_aprtd);
1980: --
1981: if l_defined_balance_id is not null then
1982: --
1983: l_assignment_action_id := get_latest_action_id(
2038: l_defined_bal_id number;
2039: --
2040: begin
2041: --
2042: l_defined_bal_id := dimension_relevant(p_balance_type_id, pyjpexc.c_asg_aprtd);
2043: --
2044: if l_defined_bal_id is not null then
2045: --
2046: l_balance := pay_balance_pkg.get_value(
2890: p_assignment_action_id,
2891: l_balance_type_id);
2892: -- l_dimension_name);
2893: --
2894: elsif l_dimension_name = pyjpexc.c_asg_aprtd then
2895: --
2896: l_balance := calc_asg_apr2mar_jp_action(
2897: p_assignment_action_id,
2898: l_balance_type_id);
3005: p_assignment_id,
3006: l_balance_type_id,
3007: p_effective_date);
3008: --
3009: elsif l_dimension_name = pyjpexc.c_asg_aprtd then
3010: --
3011: l_balance := calc_asg_apr2mar_jp_date(
3012: p_assignment_id,
3013: l_balance_type_id,