DBA Data[Home] [Help]

APPS.PA_RETENTION_UTIL dependencies on PA_LOOKUPS

Line 1189: FROM pa_projects_all p , pa_lookups lk

1185: SELECT p.segment1, p.name, p.invproc_currency_type,
1186: p.project_currency_code, p.projfunc_currency_code, lk.meaning
1187: INTO x_project_number, x_project_name, l_invproc_currency_type,
1188: l_project_currency_code, x_projfunc_currency_code, x_invproc_currency_type
1189: FROM pa_projects_all p , pa_lookups lk
1190: WHERE project_id = p_project_id
1191: and lk.lookup_type = 'INVPROCE_CURR_TYPE'
1192: and lk.lookup_code = p.invproc_currency_type;
1193:

Line 2607: FROM PA_LOOKUPS

2603:
2604: BEGIN
2605: SELECT Lookup_Code, Meaning
2606: INTO P_Revenue_Category_Code, P_Revenue_Category
2607: FROM PA_LOOKUPS
2608: WHERE Lookup_Type = 'REVENUE CATEGORY'
2609: AND upper(Meaning) = upper(P_Revenue_Category);
2610: EXCEPTION
2611: WHEN OTHERS THEN