APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PA_CONTROL_ITEMS

Line 309: FROM PA_CONTROL_ITEMS

305: AND povs.vendor_site_id = c_vendor_site_id;
306:
307: CURSOR c_ci_info IS
308: SELECT description
309: FROM PA_CONTROL_ITEMS
310: WHERE ci_id = p_dctn_hdr_rec.ci_id;
311:
312: l_vend_info_rec c_vendor_info%ROWTYPE;
313: l_orgz_info_rec c_orgz_info%ROWTYPE;

Line 328: l_ci_description PA_CONTROL_ITEMS.description%TYPE;

324: l_err_stack VARCHAR2(630);
325: l_err_stage VARCHAR2(80);
326: l_page_content_id NUMBER :=0;
327: l_ci_type_class_code VARCHAR2(15);
328: l_ci_description PA_CONTROL_ITEMS.description%TYPE;
329:
330: PRAGMA AUTONOMOUS_TRANSACTION;
331:
332: BEGIN