APPS.PER_CEI_BUS dependencies on PER_CAGR_API_PARAMETERS

Line 695: FROM per_cagr_api_parameters p

691: -- Declare Cursors
692: --
693: CURSOR csr_chk_api_param_type IS
694: SELECT column_type
695: FROM per_cagr_api_parameters p
696: WHERE p.cagr_api_param_id = p_cagr_api_param_id
697: AND p.column_type = p_column_type;
698: --
699: -- Local declarations

Line 702: l_api_column_type per_cagr_api_parameters.column_type%TYPE;

698: --
699: -- Local declarations
700: --
701: l_proc VARCHAR2(72) := g_package||'chk_column_type';
702: l_api_column_type per_cagr_api_parameters.column_type%TYPE;
703: --
704: BEGIN
705: --
706: hr_utility.set_location('Entering: '||l_proc,10);

Line 834: FROM per_cagr_api_parameters p

830: -- Declare Cursors
831: --
832: CURSOR csr_chk_api_param_size IS
833: SELECT column_size
834: FROM per_cagr_api_parameters p
835: WHERE p.cagr_api_param_id = p_cagr_api_param_id
836: AND p.column_size = p_column_size;
837: --
838: -- Local declarations

Line 1057: FROM per_cagr_api_parameters cap

1053: l_cagr_api_param_id per_cagr_entitlement_items.cagr_api_param_id%TYPE;
1054: --
1055: CURSOR csr_cagr_api_param_id IS
1056: SELECT cagr_api_param_id
1057: FROM per_cagr_api_parameters cap
1058: WHERE cap.cagr_api_param_id = p_cagr_api_param_id
1059: AND cap.cagr_api_id = p_cagr_api_id;
1060: --
1061: BEGIN

Line 1250: FROM per_cagr_api_parameters p

1246: --
1247: CURSOR csr_get_param_uom IS
1248: SELECT p.uom_lookup,
1249: p.default_uom
1250: FROM per_cagr_api_parameters p
1251: WHERE p.cagr_api_param_id = p_cagr_api_param_id;
1252: --
1253: CURSOR csr_get_pay_default_uom IS
1254: SELECT piv.uom

Line 1263: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;

1259: --
1260: -- Local declarations
1261: --
1262: l_proc VARCHAR2(72) := g_package||'chk_uom';
1263: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;
1264: l_default_uom per_cagr_api_parameters.default_uom%TYPE;
1265: l_uom pay_input_values_f.uom%TYPE;
1266: --
1267: BEGIN

Line 1264: l_default_uom per_cagr_api_parameters.default_uom%TYPE;

1260: -- Local declarations
1261: --
1262: l_proc VARCHAR2(72) := g_package||'chk_uom';
1263: l_uom_lookup per_cagr_api_parameters.uom_lookup%TYPE;
1264: l_default_uom per_cagr_api_parameters.default_uom%TYPE;
1265: l_uom pay_input_values_f.uom%TYPE;
1266: --
1267: BEGIN
1268: --