APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_CAGR_API_PARAMETERS

Line 9: TYPE mapping_rec IS RECORD (parameter_name per_cagr_api_parameters.parameter_name%TYPE

5: -- | Package Types and Variables (globals)
6: -- ----------------------------------------------------------------------------
7: --
8:
9: TYPE mapping_rec IS RECORD (parameter_name per_cagr_api_parameters.parameter_name%TYPE
10: ,value VARCHAR2(30));
11:
12: TYPE asg_rec is record (cagr_entitlement_result_id NUMBER(15)
13: ,assignment_id NUMBER(11)

Line 318: FROM per_cagr_api_parameters apip, per_cagr_apis api

314: ,apip.cagr_api_param_id
315: ,apip.column_type
316: ,apip.uom_parameter
317: ,api.api_name
318: FROM per_cagr_api_parameters apip, per_cagr_apis api
319: WHERE api.cagr_api_id = v_cagr_api_id
320: AND api.cagr_api_id = apip.cagr_api_id;
321:
322: TYPE t_api_details IS TABLE OF csr_api%ROWTYPE INDEX BY BINARY_INTEGER;

Line 603: FROM per_cagr_api_parameters apip, per_cagr_apis api

599: ,apip.cagr_api_param_id
600: ,apip.column_type
601: ,apip.uom_parameter
602: ,api.api_name
603: FROM per_cagr_api_parameters apip, per_cagr_apis api
604: WHERE api.api_name = v_api_name
605: AND api.cagr_api_id = apip.cagr_api_id;
606:
607: -- get placement_id rec