APPS.PAY_AU_TERMINATIONS dependencies on PAY_BALANCE_PKG

Line 1738: pay_balance_pkg.get_value(P_ASSIGNMENT_ACTION_ID =>l_asg_act_id,

1734: END IF;
1735:
1736: -- Use BBR for retrieving the balance values for the previous financial year.
1737: --
1738: pay_balance_pkg.get_value(P_ASSIGNMENT_ACTION_ID =>l_asg_act_id,
1739: P_DEFINED_BALANCE_LST => g_ytd_input_table,
1740: P_CONTEXT_LST => g_ytd_context_table,
1741: P_OUTPUT_TABLE => g_ytd_result_table);
1742:

Line 2255: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id

2251: and paa.tax_unit_id = p_tax_unit_id;
2252:
2253: cursor csr_get_bal_value (c_balance_name varchar2,
2254: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
2255: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
2256: ,c_max_assignment_action_id
2257: ,p_tax_unit_id
2258: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
2259: FROM pay_balance_types pbt,

Line 2608: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id

2604: and paa.tax_unit_id = p_tax_unit_id;
2605:
2606: cursor csr_get_bal_value (c_balance_name varchar2,
2607: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
2608: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
2609: ,c_max_assignment_action_id
2610: ,p_tax_unit_id
2611: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
2612: FROM pay_balance_types pbt,

Line 3413: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id

3409: and paa.tax_unit_id = p_tax_unit_id;
3410:
3411: cursor csr_get_bal_value (c_balance_name varchar2,
3412: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
3413: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3414: ,c_max_assignment_action_id
3415: ,p_tax_unit_id
3416: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
3417: FROM pay_balance_types pbt,

Line 3738: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id

3734: and paa.tax_unit_id = p_tax_unit_id;
3735:
3736: cursor csr_get_bal_value (c_balance_name varchar2,
3737: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
3738: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3739: ,c_max_assignment_action_id
3740: ,p_tax_unit_id
3741: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
3742: FROM pay_balance_types pbt,

Line 3804: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id

3800: and paa.action_status = 'C' ;
3801:
3802: cursor csr_rehire_get_bal_value (c_balance_name varchar2,
3803: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
3804: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3805: ,c_max_assignment_action_id
3806: ,NULL
3807: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
3808: FROM pay_balance_types pbt,