DBA Data[Home] [Help]

APPS.OZF_REASON_CODES_ALL_PKG dependencies on OZF_REASON_CODES_ALL_B_S

Line 60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;

56: l_reason_count NUMBER;
57:
58: CURSOR C IS SELECT rowid FROM OZF_REASON_CODES_ALL_B
59: WHERE REASON_CODE_ID = px_REASON_CODE_ID;
60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;
61: CURSOR C_REASON_COUNT(l_reason_code_id NUMBER) IS
62: SELECT COUNT(REASON_CODE_ID)
63: FROM OZF_REASON_CODES_ALL_B
64: WHERE REASON_CODE_ID = l_reason_code_id;