DBA Data[Home] [Help]

APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_OUTCOMES_B

Line 958: FROM okc_outcomes_b oce,

954: 'DATE' ,'OKC_API.G_MISS_DATE',
955: 'OKC_API.G_MISS_CHAR')) default_value,
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

Line 969: l_oce_id okc_outcomes_b.id%TYPE;

965: AND UPPER(oce.enabled_yn) = 'Y'
966: ORDER BY outcome,parameter;
967: oce_rec oce_cur%ROWTYPE;
968:
969: l_oce_id okc_outcomes_b.id%TYPE;
970: l_pdp_id okc_process_def_parms_b.id%TYPE;
971: l_value okc_outcome_arguments.value%TYPE;
972: l_element_name okc_action_attributes_b.element_name%TYPE;
973: CURSOR oat_cur(l_oce_id IN NUMBER,

Line 1345: FROM okc_outcomes_b oce,

1341: 'DATE' ,'OKC_API.G_MISS_DATE',
1342: 'OKC_API.G_MISS_CHAR')) default_value,
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

Line 1356: l_oce_id okc_outcomes_b.id%TYPE;

1352: AND UPPER(oce.enabled_yn) = 'Y'
1353: ORDER BY outcome,parameter;
1354: oce_rec oce_cur%ROWTYPE;
1355:
1356: l_oce_id okc_outcomes_b.id%TYPE;
1357: l_pdp_id okc_process_def_parms_b.id%TYPE;
1358: l_value okc_outcome_arguments.value%TYPE;
1359: l_element_name okc_action_attributes_b.element_name%TYPE;
1360: CURSOR oat_cur(l_oce_id IN NUMBER,