DBA Data[Home] [Help]

APPS.OKC_EXP_DATE_ASMBLR_PVT dependencies on OKC_ACTIONS_V

Line 60: FROM okc_actions_v acn,okc_action_attributes_v aae

56: k1_rec k1_csr%ROWTYPE;
57:
58: CURSOR elements_csr IS
59: SELECT aae.element_name
60: FROM okc_actions_v acn,okc_action_attributes_v aae
61: WHERE acn.id = aae.acn_id
62: AND acn.correlation = 'KEXPIRE';
63:
64: elements_rec elements_csr%ROWTYPE;

Line 106: /* SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn

102: RAISE OKC_API.G_EXCEPTION_ERROR;
103: END IF;
104:
105: --Get the correlation
106: /* SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn
107: WHERE acn.correlation = 'KEXPIRE';*/
108:
109: --Get the action id
110: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn

Line 347: FROM okc_actions_v acn,okc_action_attributes_v aae

343:
344:
345: CURSOR elements_csr IS
346: SELECT aae.element_name
347: FROM okc_actions_v acn,okc_action_attributes_v aae
348: WHERE acn.id = aae.acn_id
349: AND acn.correlation = 'KLEXPIRE';
350:
351: elements_rec elements_csr%ROWTYPE;

Line 397: /*SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn

393: RAISE OKC_API.G_EXCEPTION_ERROR;
394: END IF;
395:
396: --Get the correlation
397: /*SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn
398: WHERE acn.correlation = 'KLEXPIRE';*/
399: --Get the action id
400: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn
401: WHERE acn.correlation = 'KLEXPIRE';