DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on PAY_BALANCE_TYPES

Line 484: FUNCTION get_sit_type_name(p_balance_type_id pay_balance_types.balance_type_id%TYPE

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:

Line 490: CURSOR csr_get_sit_type_name (lp_balance_type_id pay_balance_types.balance_type_id%TYPE

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

Line 496: ,pay_balance_types pbt

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