DBA Data[Home] [Help]

APPS.PA_RP_UTIL dependencies on PA_PROJECTS_ALL

Line 806: FROM pa_projects_all

802: END IF;
803:
804: SELECT project_currency_code, projfunc_currency_code
805: INTO l_proj_currency,l_projfunc_currency
806: FROM pa_projects_all
807: WHERE project_id = p_project_id;
808:
809: IF p_currency_type = 'PC' THEN
810: x_currency_record_type := 8;

Line 865: FROM pji_org_extr_info info, pa_projects_all proj

861: x_calendar_id := -1;
862: ELSE
863: SELECT info.gl_calendar_id, info.pa_calendar_id
864: INTO l_gl_calendar_id, l_pa_calendar_id
865: FROM pji_org_extr_info info, pa_projects_all proj
866: WHERE info.org_id = proj.org_id
867: AND proj.project_id = p_project_id;
868:
869: IF p_calendar_type = 'G' THEN

Line 1044: FROM pa_proj_elements ppe, pa_projects_all ppa

1040: SELECT
1041: MAX(DECODE(ppe.object_type, 'PA_TASKS', ppe.element_number, ppa.segment1)) task_number
1042: INTO
1043: l_number
1044: FROM pa_proj_elements ppe, pa_projects_all ppa
1045: WHERE ppe.project_id = p_project_id
1046: AND ppa.project_id = ppe.project_id
1047: AND ppe.proj_element_id = p_proj_elem_id;
1048: