DBA Data[Home] [Help]

APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_PROCESS_DEF_PARAMETERS_V

Line 335: okc_process_def_parameters_v pdp,

331: decode(pdp.data_type,'CHAR','''',
332: 'DATE','''',NULL) prefix_param,
333: fep.value fep_value
334: FROM okc_process_defs_b pdf,
335: okc_process_def_parameters_v pdp,
336: okc_function_expr_params fep,
337: okc_action_attributes_b aae
338: WHERE pdf.id = p_pdf_id
339: AND pdp.pdf_id = pdf.id

Line 960: okc_process_def_parameters_v pdp

956: pdp.data_type datatype,
957: pdp.required_yn required_yn
958: FROM okc_outcomes_b oce,
959: okc_process_defs_v pdf,
960: okc_process_def_parameters_v pdp
961: WHERE oce.cnh_id = p_cnh_tab(x).v_id
962: AND oce.pdf_id = pdf.id
963: AND pdf.id = pdp.pdf_id(+)
964: AND UPPER(pdf.usage) = 'OUTCOME'

Line 1347: okc_process_def_parameters_v pdp

1343: pdp.data_type datatype,
1344: pdp.required_yn required_yn
1345: FROM okc_outcomes_b oce,
1346: okc_process_defs_v pdf,
1347: okc_process_def_parameters_v pdp
1348: WHERE oce.cnh_id = p_cnh_tab(x).v_id
1349: AND oce.pdf_id = pdf.id
1350: AND pdf.id = pdp.pdf_id(+)
1351: AND UPPER(pdf.usage) = 'OUTCOME'