APPS.HR_BIS_ALERTS dependencies on FF_FORMULAS_F

Line 1085: RETURN ff_formulas.formula_id%TYPE

1081: -------------------------------------------------------------------------
1082: FUNCTION get_formula_id
1083: (p_business_group_id IN NUMBER
1084: ,p_budget_type IN VARCHAR2)
1085: RETURN ff_formulas.formula_id%TYPE
1086: IS
1087:
1088: CURSOR formula_cur
1089: (p_c_business_group_id NUMBER

Line 1093: FROM ff_formulas_f

1089: (p_c_business_group_id NUMBER
1090: ,p_c_formula_name VARCHAR2)
1091: IS
1092: SELECT formula_id
1093: FROM ff_formulas_f
1094: WHERE ( (p_c_business_group_id IS null
1095: AND business_group_id IS null )
1096: OR
1097: p_c_business_group_id = business_group_id

Line 1103: l_formula_id ff_formulas.formula_id%TYPE;

1099: AND trunc(sysdate) BETWEEN
1100: effective_start_date AND effective_end_date
1101: AND formula_name = p_c_formula_name;
1102:
1103: l_formula_id ff_formulas.formula_id%TYPE;
1104:
1105: BEGIN
1106: pl('*Get Formula id','Start');
1107: pl(' Budgt Type : ', p_budget_type);

Line 1314: l_formula_id ff_formulas_f.formula_id%TYPE;

1310: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
1311: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
1312: l_resp_appl_id fnd_responsibility.application_id%TYPE;
1313:
1314: l_formula_id ff_formulas_f.formula_id%TYPE;
1315:
1316: BEGIN
1317: pl('----------------------------------');
1318: pl('*SEND MPS notification','Start');

Line 1490: l_formula_id ff_formulas_f.formula_id%TYPE;

1486: l_period_end_date DATE;
1487:
1488: l_business_group_id NUMBER;
1489:
1490: l_formula_id ff_formulas_f.formula_id%TYPE;
1491:
1492: --
1493: -- get each assignment that has separated IN the period defined
1494: -- by the target time dimension

Line 2115: l_formula_id ff_formulas.formula_id%TYPE;

2111:
2112: l_period_start_date DATE;
2113: l_period_end_date DATE;
2114:
2115: l_formula_id ff_formulas.formula_id%TYPE;
2116:
2117: --
2118: -- Get the total manpower matching the target dimensions
2119: --

Line 2628: l_formula_id ff_formulas_f.formula_id%TYPE;

2624:
2625: l_business_group_id NUMBER;
2626: l_budget_value NUMBER;
2627:
2628: l_formula_id ff_formulas_f.formula_id%TYPE;
2629:
2630: --
2631: -- This cursor gets each vacancy that closed in period defined by the
2632: -- pmf time dimension

Line 3139: l_formula_id ff_formulas_f.formula_id%TYPE;

3135: l_period_end_date DATE;
3136:
3137: l_business_group_id NUMBER;
3138:
3139: l_formula_id ff_formulas_f.formula_id%TYPE;
3140:
3141: -- get the training duration for each attendance to a scheduled event
3142: -- that start date lies between the period start and end date
3143: --