APPS.OKC_EXP_DATE_ASMBLR_PVT dependencies on OKC_ACTIONS_B

Line 110: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn

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
111: WHERE acn.correlation = 'KEXPIRE';
112:
113: --Check if the variance is positive or negative
114: IF p_before_after = 'A' THEN

Line 400: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn

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';
402:
403: IF (l_debug = 'Y') THEN
404: okc_debug.Log('120: After fetching into l_corrid_rec ',2);