APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_PROJECTS_ALL

Line 1341: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1337: l_project_as_id_minus1 NUMBER:=-1;
1338: l_res_as_type_USER_ENTERED VARCHAR2(30):='USER_ENTERED';
1339: l_rec_ver_number_1 NUMBER:=1;
1340:
1341: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1342: BEGIN
1343: IF P_PA_DEBUG_MODE = 'Y' THEN
1344: pa_debug.set_curr_function( p_function => 'CREATE_RES_ASG',
1345: p_debug_mode => p_pa_debug_mode );

Line 1383: FROM pa_projects_all

1379:
1380: SELECT NVL(start_date,trunc(sysdate)),
1381: NVL(completion_date,trunc(sysdate))
1382: INTO l_proj_start_date, l_proj_completion_date
1383: FROM pa_projects_all
1384: WHERE project_id = P_PROJECT_ID;
1385:
1386: /* When the Target is a Revenue-only version, we need to take the target
1387: * version's ETC source code instead of the task-level source code for

Line 1600: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1596: l_data VARCHAR2(1000);
1597: l_msg_data VARCHAR2(1000);
1598: l_msg_index_out NUMBER;
1599:
1600: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1601: BEGIN
1602: IF P_PA_DEBUG_MODE = 'Y' THEN
1603: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG',
1604: p_debug_mode => p_pa_debug_mode );