APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_CAGR_APIS

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 595: FROM per_cagr_api_parameters apip, per_cagr_apis api

591: ,apip.cagr_api_param_id
592: ,apip.column_type
593: ,apip.uom_parameter
594: ,api.api_name
595: FROM per_cagr_api_parameters apip, per_cagr_apis api
596: WHERE api.api_name = v_api_name
597: AND api.cagr_api_id = apip.cagr_api_id;
598:
599: -- get placement_id rec

Line 608: l_api_name per_cagr_apis.api_name%type;

604: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);
605:
606: TYPE t_api_details IS TABLE OF csr_api%ROWTYPE INDEX BY BINARY_INTEGER;
607:
608: l_api_name per_cagr_apis.api_name%type;
609: l_mapping_table t_mapping_table;
610: l_api_details t_api_details;
611: l_proc constant VARCHAR2(80) := g_pkg || 'call_PYS_api';
612: l_map_count NUMBER(10) := 0;