DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PROCESS_DEFS_V

Line 168: FROM okc_process_defs_v pdf

164: CURSOR pdf_cur(l_pdf_id IN NUMBER) IS
165: SELECT
166: decode(pdf.pdf_type,'PPS',
167: pdf.package_name||'.'||pdf.procedure_name,NULL) proc_name
168: FROM okc_process_defs_v pdf
169: -- bug 2112814 ,okc_process_def_parameters_v pdp
170: WHERE pdf.id = l_pdf_id;
171:
172: pdf_rec pdf_cur%ROWTYPE;

Line 178: FROM okc_process_defs_v pdf,

174: /* Bugfix 2151523(1917514) - Commented out nocopy as it is not being used
175: -- Cursor to get the parameters defined for the package.procedure name from PDF
176: CURSOR pdp_cur(l_pdf_id IN NUMBER) IS
177: SELECT pdp.name param_name
178: FROM okc_process_defs_v pdf,
179: okc_process_def_parameters_v pdp
180: WHERE pdf.id = l_pdf_id
181: AND pdf.id = pdp.pdf_id;
182: