APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_LOOKUPS

Line 2478: -- b. pa_lookups for Project related transactions

2474: -- #API name : Get_cost_rejection_reason
2475: -- #Type : private
2476: -- #Description : Fundscheck rejection reasons are fetched from
2477: -- a. gms_lookups for Grants related transactions
2478: -- b. pa_lookups for Project related transactions
2479: -- Transaction rejection reason/cost distribution rejection reason are
2480: -- derived from pa_lookups
2481: --=======================================================================================+
2482:

Line 2480: -- derived from pa_lookups

2476: -- #Description : Fundscheck rejection reasons are fetched from
2477: -- a. gms_lookups for Grants related transactions
2478: -- b. pa_lookups for Project related transactions
2479: -- Transaction rejection reason/cost distribution rejection reason are
2480: -- derived from pa_lookups
2481: --=======================================================================================+
2482:
2483: FUNCTION Get_cost_rejection_reason ( p_Lookup_code IN VARCHAR2,
2484: p_sponsored_flag IN VARCHAR2)

Line 2487: l_meaning pa_lookups.meaning%TYPE;

2483: FUNCTION Get_cost_rejection_reason ( p_Lookup_code IN VARCHAR2,
2484: p_sponsored_flag IN VARCHAR2)
2485: return VARCHAR2 IS
2486:
2487: l_meaning pa_lookups.meaning%TYPE;
2488:
2489: CURSOR c_pa_lookup_meaning IS
2490: SELECT LOOKUP.Meaning
2491: FROM PA_Lookups LOOKUP

Line 2491: FROM PA_Lookups LOOKUP

2487: l_meaning pa_lookups.meaning%TYPE;
2488:
2489: CURSOR c_pa_lookup_meaning IS
2490: SELECT LOOKUP.Meaning
2491: FROM PA_Lookups LOOKUP
2492: WHERE LOOKUP.Lookup_Type IN ('IND COST DIST REJECTION CODE','COST DIST REJECTION CODE', 'FC_RESULT_CODE', 'TRANSACTION REJECTION REASON')
2493: AND LOOKUP.Lookup_Code = p_Lookup_code;
2494:
2495: CURSOR c_gms_lookup_meaning IS