[Home] [Help]
308: -- IN : --
309: -- --
310: --------------------------------------------------------------------------
311: FUNCTION get_defined_balance
312: (p_balance_type in pay_balance_types.balance_name%type
313: , p_dimension_name in pay_balance_dimensions.dimension_name%type)
314: return number
315: is
316: CURSOR csr_def_bal_id
316: CURSOR csr_def_bal_id
317: IS
318: SELECT pdb.defined_balance_id
319: FROM pay_defined_balances pdb
320: ,pay_balance_types pbt
321: ,pay_balance_dimensions pbd
322: WHERE pbt.balance_name = p_balance_type
323: AND pbd.dimension_name = p_dimension_name
324: AND pdb.balance_type_id = pbt.balance_type_id
2522: -- 1.0 06-Apr-04 statkar Created this function --
2523: ----------------------------------------------------------------------------
2524: FUNCTION get_balance_value
2525: (p_assignment_action_id IN NUMBER
2526: ,p_balance_name IN pay_balance_types.balance_name%TYPE
2527: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
2528: ,p_context_name IN ff_contexts.context_name%TYPE
2529: ,p_context_value IN VARCHAR2
2530: )
3309: FUNCTION get_value_on_le_start
3310: (p_assignment_id IN NUMBER
3311: ,p_tax_unit_id IN NUMBER
3312: ,p_effective_date IN DATE
3313: ,p_balance_name IN pay_balance_types.balance_name%TYPE
3314: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
3315: ,p_context_name IN ff_contexts.context_name%TYPE
3316: ,p_context_value IN VARCHAR2
3317: ,p_success OUT NOCOPY VARCHAR2
3541: (p_assignment_id IN NUMBER
3542: ,p_assignment_action_id IN NUMBER
3543: ,p_payroll_action_id IN NUMBER
3544: ,p_tax_unit_id IN NUMBER
3545: ,p_balance_name IN pay_balance_types.balance_name%TYPE
3546: ,p_le_start_date IN DATE
3547: )
3548: RETURN NUMBER IS
3549: