APPS.PAY_CA_DD_MAGTAPE_PKG dependencies on FF_FORMULAS_F

Line 108: from FF_FORMULAS_F

104: then
105: begin
106: select formula_name
107: INTO l_ff_formula_name
108: from FF_FORMULAS_F
109: where g_effective_date between EFFECTIVE_START_DATE and
110: EFFECTIVE_END_DATE
111: and FORMULA_id = l_ff_formula_id;
112: if l_ff_formula_name in ('BNC_TRAILER','RBC_TRAILER','BMO_TRAILER')

Line 147: from FF_FORMULAS_F

143: --ELSE
144: BEGIN
145: select TO_CHAR(FORMULA_ID)
146: INTO p_ff_formula_id
147: from FF_FORMULAS_F
148: where g_effective_date between EFFECTIVE_START_DATE and
149: EFFECTIVE_END_DATE
150: and FORMULA_NAME = p_formula_name;
151:

Line 264: from FF_FORMULAS_F

260: hr_utility.trace('Formula id is '||l_ff_formula_id);
261: begin
262: select formula_name
263: INTO l_ff_formula_name
264: from FF_FORMULAS_F
265: where g_effective_date between EFFECTIVE_START_DATE and
266: EFFECTIVE_END_DATE
267: and FORMULA_id = l_ff_formula_id;
268: if l_ff_formula_name not in ( 'BNC_HEADER','BNC_MULTI_PAYMENTS',

Line 283: from FF_FORMULAS_F

279: then
280: hr_utility.trace('In raise no_data_found 1');
281: select TO_CHAR(FORMULA_ID)
282: INTO p_ff_formula_id
283: from FF_FORMULAS_F
284: where g_effective_date between EFFECTIVE_START_DATE and
285: EFFECTIVE_END_DATE
286: and FORMULA_NAME = p_formula_name;
287: pay_mag_tape.internal_prm_values(2) := p_ff_formula_id;