DBA Data[Home] [Help]

APPS.PER_CEI_BUS dependencies on PER_CAGR_APIS

Line 902: -- Validate that that the cagr_api_id exists in PER_CAGR_APIS, and that the

898: -- ---------------------------------------------------------------------------
899: --
900: -- Desciption :
901: --
902: -- Validate that that the cagr_api_id exists in PER_CAGR_APIS, and that the
903: -- cagr_api_param_id has also been populated. Also ensure that the
904: -- element_type_id is blank.
905: --
906: -- Pre-conditions :

Line 942: FROM per_cagr_apis pca

938: l_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE;
939: --
940: CURSOR csr_cagr_api_id IS
941: SELECT cagr_api_id
942: FROM per_cagr_apis pca
943: WHERE pca.cagr_api_id = p_cagr_api_id;
944: --
945: BEGIN
946: --

Line 983: -- Check that the cagr_api_id exists in PER_CAGR_APIS

979: END IF;
980: --
981: hr_utility.set_location(l_proc,30);
982: --
983: -- Check that the cagr_api_id exists in PER_CAGR_APIS
984: --
985: OPEN csr_cagr_api_id;
986: FETCH csr_cagr_api_id INTO l_cagr_api_id;
987: --