480: ---------------------------------------------------------------------------
481: -- Function : get_sit_type_name
482: -- Function returns the Si Type Name for specified Context Balance
483: ---------------------------------------------------------------------------
484: FUNCTION get_sit_type_name(p_balance_type_id pay_balance_types.balance_type_id%TYPE
485: ,p_assgn_action_id NUMBER
486: ,p_date_earned DATE
487: ,p_si_type VARCHAR2) RETURN VARCHAR2 IS
488:
486: ,p_date_earned DATE
487: ,p_si_type VARCHAR2) RETURN VARCHAR2 IS
488:
489: --
490: CURSOR csr_get_sit_type_name (lp_balance_type_id pay_balance_types.balance_type_id%TYPE
491: ,lp_assgn_action_id NUMBER
492: ,lp_date_earned DATE
493: ,lp_si_type VARCHAR2) IS
494: SELECT prrv1.result_value si_type_name
492: ,lp_date_earned DATE
493: ,lp_si_type VARCHAR2) IS
494: SELECT prrv1.result_value si_type_name
495: FROM pay_balance_feeds_f pbf
496: ,pay_balance_types pbt
497: ,pay_input_values_f piv
498: ,pay_input_values_f piv1
499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet