[Home] [Help]
436: -- IN : --
437: -- --
438: --------------------------------------------------------------------------
439: FUNCTION get_defined_balance
440: (p_balance_type in pay_balance_types.balance_name%type
441: , p_dimension_name in pay_balance_dimensions.dimension_name%type)
442: return number
443: is
444: CURSOR csr_def_bal_id
444: CURSOR csr_def_bal_id
445: IS
446: SELECT pdb.defined_balance_id
447: FROM pay_defined_balances pdb
448: ,pay_balance_types pbt
449: ,pay_balance_dimensions pbd
450: WHERE pbt.balance_name = p_balance_type
451: AND pbd.dimension_name = p_dimension_name
452: AND pdb.balance_type_id = pbt.balance_type_id
2958: -- 1.0 06-Apr-04 statkar Created this function --
2959: ----------------------------------------------------------------------------
2960: FUNCTION get_balance_value
2961: (p_assignment_action_id IN NUMBER
2962: ,p_balance_name IN pay_balance_types.balance_name%TYPE
2963: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
2964: ,p_context_name IN ff_contexts.context_name%TYPE
2965: ,p_context_value IN VARCHAR2
2966: )
4362: FUNCTION get_value_on_le_start
4363: (p_assignment_id IN NUMBER
4364: ,p_tax_unit_id IN NUMBER
4365: ,p_effective_date IN DATE
4366: ,p_balance_name IN pay_balance_types.balance_name%TYPE
4367: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
4368: ,p_context_name IN ff_contexts.context_name%TYPE
4369: ,p_context_value IN VARCHAR2
4370: ,p_success OUT NOCOPY VARCHAR2
4594: (p_assignment_id IN NUMBER
4595: ,p_assignment_action_id IN NUMBER
4596: ,p_payroll_action_id IN NUMBER
4597: ,p_tax_unit_id IN NUMBER
4598: ,p_balance_name IN pay_balance_types.balance_name%TYPE
4599: ,p_le_start_date IN DATE
4600: )
4601: RETURN NUMBER IS
4602: