DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PROCESS_DEFS_V

Line 167: FROM okc_process_defs_v pdf

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

Line 177: FROM okc_process_defs_v pdf,

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