APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on PA_PROJECTS_ALL

Line 61: l_struct_sharing_code pa_projects_all.structure_sharing_code%type;

57: l_etc_fp_ver_name VARCHAR2(60);
58: l_fp_options_id number;
59: l_project_name VARCHAR2(200);
60: l_plan_type_name pa_fin_plan_types_tl.name%type;
61: l_struct_sharing_code pa_projects_all.structure_sharing_code%type;
62: l_return_status varchar2(10);
63: l_msg_count number;
64: l_msg_data varchar2(2000);
65: l_msg_data_in varchar2(2000);

Line 116: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent

112: -- Bug 4367064: Instead of checking if pj.project_status_code <> 'CLOSED'
113: -- directly, we make use of the Is_Project_Status_Closed function, which
114: -- returns 'Y' if the project_status_code is equivalent to 'CLOSED'.
115:
116: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent
117: -- program has been modified to make it single org compliant.
118:
119: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||
120: ' pa_fin_plan_types_b pt, pa_project_types_all pta';