APPS.PA_RETENTION_UTIL dependencies on PA_PROJECTS_ALL

Line 994: FROM pa_projects_all

990: projfunc_currency_code
991: INTO x_invproc_currency_type,
992: x_project_currency_code,
993: x_projfunc_currency_code
994: FROM pa_projects_all
995: WHERE project_id = p_project_id;
996:
997:
998: x_funding_currency_code := NULL;

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 1316: FROM pa_projects_all fr_proj, pa_projects_all to_proj

1312: --dbms_output.put_line ('in calculate date factor ');
1313:
1314: SELECT fr_proj.start_date, to_proj.start_date
1315: INTO l_fr_start_date, l_to_start_date
1316: FROM pa_projects_all fr_proj, pa_projects_all to_proj
1317: WHERE fr_proj.project_id = p_fr_project_id
1318: AND to_proj.project_id = p_to_project_id;
1319:
1320: if (l_to_start_date is null) then