APPS.PQP_GB_GAP_BEN_FORMULAS dependencies on FF_FORMULA_TYPES

Line 128: l_formula_type ff_formula_types.formula_type_name%TYPE;-- VARCHAR2(80)

124: )
125: IS
126:
127: l_formula_name ff_formulas.formula_name%TYPE;-- VARCHAR2(80)
128: l_formula_type ff_formula_types.formula_type_name%TYPE;-- VARCHAR2(80)
129: l_description ff_formulas.description%TYPE;-- VARCHAR2(240)
130: l_formula_type_id ff_formula_types.formula_type_id%TYPE;
131:
132: -- this date is passed as effective start date for LER formulas only.

Line 130: l_formula_type_id ff_formula_types.formula_type_id%TYPE;

126:
127: l_formula_name ff_formulas.formula_name%TYPE;-- VARCHAR2(80)
128: l_formula_type ff_formula_types.formula_type_name%TYPE;-- VARCHAR2(80)
129: l_description ff_formulas.description%TYPE;-- VARCHAR2(240)
130: l_formula_type_id ff_formula_types.formula_type_id%TYPE;
131:
132: -- this date is passed as effective start date for LER formulas only.
133: -- In the remaining formulas p_effective_date is passed
134: l_effective_start_date DATE:= fnd_date.canonical_to_date('1951/01/01 00:00:00');

Line 341: FROM ff_formula_types

337:
338: debug(l_proc_name,27);
339: SELECT formula_type_id
340: INTO l_formula_type_id
341: FROM ff_formula_types
342: WHERE formula_type_name = l_formula_type;
343:
344: debug(l_proc_name,29);
345: debug(l_effective_start_date||';'||l_effective_end_date,30);

Line 573: FROM ff_formula_types

569:
570: debug(l_proc_name,37);
571: SELECT formula_type_id
572: INTO l_formula_type_id
573: FROM ff_formula_types
574: WHERE formula_type_name = l_formula_type;
575:
576: debug(l_proc_name,39);
577: l_formula_count := l_formula_count + 1;

Line 927: FROM ff_formula_types

923: ';
924: debug(l_proc_name,47);
925: SELECT formula_type_id
926: INTO l_formula_type_id
927: FROM ff_formula_types
928: WHERE formula_type_name = l_formula_type;
929:
930: debug(l_proc_name,49);
931: l_formula_count := l_formula_count + 1;

Line 1104: FROM ff_formula_types

1100:
1101: debug(l_proc_name,57);
1102: SELECT formula_type_id
1103: INTO l_formula_type_id
1104: FROM ff_formula_types
1105: WHERE formula_type_name = l_formula_type;
1106:
1107: debug(l_proc_name,59);
1108: l_formula_count := l_formula_count + 1;

Line 1265: FROM ff_formula_types

1261:
1262: debug(l_proc_name,67);
1263: SELECT formula_type_id
1264: INTO l_formula_type_id
1265: FROM ff_formula_types
1266: WHERE formula_type_name = l_formula_type;
1267:
1268: debug(l_proc_name,69);
1269: l_formula_count := l_formula_count + 1;

Line 1601: FROM ff_formula_types

1597:
1598: debug(l_proc_name,77);
1599: SELECT formula_type_id
1600: INTO l_formula_type_id
1601: FROM ff_formula_types
1602: WHERE formula_type_name = l_formula_type;
1603:
1604: debug(l_proc_name,79);
1605: l_formula_count := l_formula_count + 1;

Line 1776: FROM ff_formula_types

1772: ';
1773: debug(l_proc_name,87);
1774: SELECT formula_type_id
1775: INTO l_formula_type_id
1776: FROM ff_formula_types
1777: WHERE formula_type_name = l_formula_type;
1778:
1779: debug(l_proc_name,89);
1780: l_formula_count := l_formula_count + 1;

Line 2115: FROM ff_formula_types

2111:
2112: debug(l_proc_name,97);
2113: SELECT formula_type_id
2114: INTO l_formula_type_id
2115: FROM ff_formula_types
2116: WHERE formula_type_name = l_formula_type;
2117:
2118: debug(l_proc_name,99);
2119: l_formula_count := l_formula_count + 1;

Line 2472: FROM ff_formula_types

2468:
2469: debug(l_proc_name,107);
2470: SELECT formula_type_id
2471: INTO l_formula_type_id
2472: FROM ff_formula_types
2473: WHERE formula_type_name = l_formula_type;
2474:
2475: --DELETE FROM ff_formulas_f WHERE formula_name = l_formula_name;
2476: