DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_LOOKUPS

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

2323: -- #API name : Get_cost_rejection_reason
2324: -- #Type : private
2325: -- #Description : Fundscheck rejection reasons are fetched from
2326: -- a. gms_lookups for Grants related transactions
2327: -- b. pa_lookups for Project related transactions
2328: -- Transaction rejection reason/cost distribution rejection reason are
2329: -- derived from pa_lookups
2330: --=======================================================================================+
2331:

Line 2329: -- derived from pa_lookups

2325: -- #Description : Fundscheck rejection reasons are fetched from
2326: -- a. gms_lookups for Grants related transactions
2327: -- b. pa_lookups for Project related transactions
2328: -- Transaction rejection reason/cost distribution rejection reason are
2329: -- derived from pa_lookups
2330: --=======================================================================================+
2331:
2332: FUNCTION Get_cost_rejection_reason ( p_Lookup_code IN VARCHAR2,
2333: p_sponsored_flag IN VARCHAR2)

Line 2336: l_meaning pa_lookups.meaning%TYPE;

2332: FUNCTION Get_cost_rejection_reason ( p_Lookup_code IN VARCHAR2,
2333: p_sponsored_flag IN VARCHAR2)
2334: return VARCHAR2 IS
2335:
2336: l_meaning pa_lookups.meaning%TYPE;
2337:
2338: CURSOR c_pa_lookup_meaning IS
2339: SELECT LOOKUP.Meaning
2340: FROM PA_Lookups LOOKUP

Line 2340: FROM PA_Lookups LOOKUP

2336: l_meaning pa_lookups.meaning%TYPE;
2337:
2338: CURSOR c_pa_lookup_meaning IS
2339: SELECT LOOKUP.Meaning
2340: FROM PA_Lookups LOOKUP
2341: WHERE LOOKUP.Lookup_Type IN ('IND COST DIST REJECTION CODE','COST DIST REJECTION CODE', 'FC_RESULT_CODE', 'TRANSACTION REJECTION REASON')
2342: AND LOOKUP.Lookup_Code = p_Lookup_code;
2343:
2344: CURSOR c_gms_lookup_meaning IS