APPS.PER_CAGR_API_PARAMETERS_PKG dependencies on PER_CAGR_APIS

Line 15: from PER_CAGR_APIS API

11: ) is
12:
13: cursor CSR_CAGR_API( X_API_NAME VARCHAR2 ) is
14: select API.CAGR_API_ID
15: from PER_CAGR_APIS API
16: where API.API_NAME = X_API_NAME;
17:
18: cursor CSR_CAGR_DISPLAY_NAME ( X_DISPLAY_NAME VARCHAR2, X_API_NAME VARCHAR2 ) is
19: select cap.CAGR_API_PARAM_ID

Line 21: PER_CAGR_APIS api

17:
18: cursor CSR_CAGR_DISPLAY_NAME ( X_DISPLAY_NAME VARCHAR2, X_API_NAME VARCHAR2 ) is
19: select cap.CAGR_API_PARAM_ID
20: from PER_CAGR_API_PARAMETERS cap,
21: PER_CAGR_APIS api
22: where cap.DISPLAY_NAME = X_DISPLAY_NAME
23: and cap.cagr_api_id = api.cagr_Api_id
24: and api.api_name = X_API_NAME;
25:

Line 78: p_ref_entity => 'PER_CAGR_APIS',

74:
75: BEGIN
76: PER_RIC_PKG.chk_integrity (
77: p_entity_name => 'PER_CAGR_API_PARAMETERS',
78: p_ref_entity => 'PER_CAGR_APIS',
79: p_ref_column_name => 'CAGR_API_ID',
80: p_ref_col_value_number => X_CAGR_API_ID,
81: p_ref_col_value_varchar => NULL,
82: p_ref_col_value_date => NULL,