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 105: /* SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn

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

Line 331: FROM okc_actions_v acn,okc_action_attributes_v aae

327:
328:
329: CURSOR elements_csr IS
330: SELECT aae.element_name
331: FROM okc_actions_v acn,okc_action_attributes_v aae
332: WHERE acn.id = aae.acn_id
333: AND acn.correlation = 'KLEXPIRE';
334:
335: elements_rec elements_csr%ROWTYPE;

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

377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379:
380: --Get the correlation
381: /*SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn
382: WHERE acn.correlation = 'KLEXPIRE';*/
383: --Get the action id
384: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn
385: WHERE acn.correlation = 'KLEXPIRE';