APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_PROJECTS_ALL

Line 1482: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1478: l_project_as_id_minus1 NUMBER:=-1;
1479: l_res_as_type_USER_ENTERED VARCHAR2(30):='USER_ENTERED';
1480: l_rec_ver_number_1 NUMBER:=1;
1481:
1482: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1483:
1484: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16200605
1485: l_cbs_ele_ids PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
1486: l_cbs_id_tab pa_plsql_datatypes.IdTabTyp; --bug#16791711

Line 1530: FROM pa_projects_all

1526:
1527: SELECT NVL(start_date,trunc(sysdate)),
1528: NVL(completion_date,trunc(sysdate))
1529: INTO l_proj_start_date, l_proj_completion_date
1530: FROM pa_projects_all
1531: WHERE project_id = P_PROJECT_ID;
1532:
1533: /* When the Target is a Revenue-only version, we need to take the target
1534: * version's ETC source code instead of the task-level source code for

Line 1835: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1831: l_data VARCHAR2(1000);
1832: l_msg_data VARCHAR2(1000);
1833: l_msg_index_out NUMBER;
1834:
1835: l_proj_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1836: BEGIN
1837: IF P_PA_DEBUG_MODE = 'Y' THEN
1838: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG',
1839: p_debug_mode => p_pa_debug_mode );