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 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

Line 616: l_api_name per_cagr_apis.api_name%type;

612: AND p_params.effective_date BETWEEN effective_start_date and nvl(effective_end_date,hr_general.end_of_time);
613:
614: TYPE t_api_details IS TABLE OF csr_api%ROWTYPE INDEX BY BINARY_INTEGER;
615:
616: l_api_name per_cagr_apis.api_name%type;
617: l_mapping_table t_mapping_table;
618: l_api_details t_api_details;
619: l_proc constant VARCHAR2(80) := g_pkg || 'call_PYS_api';
620: l_map_count NUMBER(10) := 0;