APPS.OKC_CNL_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 1148: FROM okc_condition_headers_b cnh,

1144: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1145: l_temp NUMBER ;
1146: CURSOR ctr_cur IS
1147: SELECT 'X'
1148: FROM okc_condition_headers_b cnh,
1149: okc_condition_lines_b cnl,
1150: okx_counters_v ctr
1151: WHERE cnh.id = cnl.cnh_id
1152: AND cnh.counter_group_id = ctr.counter_group_id

Line 1218: FROM okc_condition_headers_b cnh,

1214: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1215: l_temp NUMBER ;
1216: CURSOR ctr_cur IS
1217: SELECT 'X'
1218: FROM okc_condition_headers_b cnh,
1219: okc_condition_lines_b cnl,
1220: okx_counters_v ctr
1221: WHERE cnh.id = cnl.cnh_id
1222: AND cnh.counter_group_id = ctr.counter_group_id

Line 1288: FROM okc_condition_headers_b cnh,

1284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1285: l_temp NUMBER ;
1286: CURSOR ctr_cur IS
1287: SELECT 'X'
1288: FROM okc_condition_headers_b cnh,
1289: okc_condition_lines_b cnl,
1290: okx_counters_v ctr
1291: WHERE cnh.id = cnl.cnh_id
1292: AND cnh.counter_group_id = ctr.counter_group_id

Line 1360: FROM okc_condition_headers_b cnh,

1356:
1357:
1358: CURSOR ctr_cur IS
1359: SELECT 'X'
1360: FROM okc_condition_headers_b cnh,
1361: okc_condition_lines_b cnl,
1362: okx_counters_v ctr
1363: WHERE cnh.id = cnl.cnh_id
1364: AND cnh.counter_group_id = ctr.counter_group_id

Line 2012: okc_condition_headers_b cnh,

2008: CURSOR acn_cur
2009: IS
2010: SELECT acn.counter_action_yn counter_action_yn
2011: FROM okc_actions_b acn,
2012: okc_condition_headers_b cnh,
2013: OKC_condition_lines_b cnl
2014: WHERE acn.id = cnh.acn_id
2015: AND cnh.id = cnl.cnh_id
2016: AND cnl.cnh_id = p_cnlv_rec.cnh_id;