APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_PROJECTS_ALL

Line 95: FROM pa_projects_all

91: l_in_srv_pa_attr_rec cse_datastructures_pub.proj_itm_insv_pa_attr_rec_type;
92:
93: CURSOR project_id_cur(p_project_num IN VARCHAR2) IS
94: SELECT project_id
95: FROM pa_projects_all
96: WHERE segment1 = p_project_num;
97:
98: CURSOR task_id_cur(p_project_id in number, p_task_num in varchar2) IS
99: SELECT task_id

Line 204: FROM pa_projects_all

200: IF l_depreciable = 'N' THEN
201:
202: SELECT org_id
203: INTO l_in_srv_pa_attr_rec.org_id
204: FROM pa_projects_all
205: WHERE project_id = l_project_id;
206:
207: l_in_srv_pa_attr_rec.item_id := inservice_inst_rec.inventory_item_id;
208: l_in_srv_pa_attr_rec.inv_master_org_id := inservice_inst_rec.last_vld_organization_id;

Line 463: FROM pa_projects_all

459: org_id
460: INTO l_project_num,
461: l_project_name,
462: l_org_id
463: FROM pa_projects_all
464: WHERE project_id = p_project_id;
465:
466: debug(' project_name : '||l_project_name);
467: