APPS.PAY_GB_ENROLL_PENSION dependencies on FF_FORMULAS_F

Line 1178: ff_formulas_f fff,

1174: IS
1175: SELECT DISTINCT petf.element_type_id
1176: FROM pay_element_types_f petf ,
1177: pay_element_entries_f peef ,
1178: ff_formulas_f fff,
1179: ff_formula_types fft
1180: WHERE petf.element_type_id = peef.element_type_id
1181: AND peef.element_type_id NOT IN
1182: (SELECT DISTINCT prr.ELEMENT_TYPE_ID

Line 1204: L_FORMULA_ID FF_FORMULAS_F.FORMULA_ID%type;

1200: AND peef.assignment_id = P_ASSIGNMENT_ID
1201: AND P_DATE_EARNED BETWEEN petf.effective_start_date AND petf.effective_end_date
1202: AND P_DATE_EARNED BETWEEN peef.effective_start_date AND peef.effective_end_date;
1203: L_SCREEN_ENTRY_VALUE PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%type;
1204: L_FORMULA_ID FF_FORMULAS_F.FORMULA_ID%type;
1205: L_STATUS_PROCES_ID NUMBER;
1206: L_TOTAL_EARNINGS_VALUE NUMBER :=0;
1207: L_INPUTS FF_EXEC.INPUTS_T;
1208: P_INPUTS FF_EXEC.INPUTS_T;

Line 1341: L_FORMULA_ID FF_FORMULAS_F.FORMULA_ID%type;

1337: AND G_PRP_END_DATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE
1338: AND G_PRP_END_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE;
1339: -----------------------------
1340: L_SCREEN_ENTRY_VALUE PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%type;
1341: L_FORMULA_ID FF_FORMULAS_F.FORMULA_ID%type;
1342: L_STATUS_PROCES_ID NUMBER;
1343: L_TOTAL_EARNINGS_VALUE NUMBER :=0;
1344: L_INPUTS FF_EXEC.INPUTS_T;
1345: P_INPUTS FF_EXEC.INPUTS_T;

Line 3626: L_FORMULA_ID FF_FORMULAS_F.FORMULA_ID%type;

3622: AND L_PRP_END_DATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE
3623: AND L_PRP_END_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE;
3624: -----------------------------
3625: L_SCREEN_ENTRY_VALUE PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%type;
3626: L_FORMULA_ID FF_FORMULAS_F.FORMULA_ID%type;
3627: L_STATUS_PROCES_ID NUMBER;
3628: L_TOTAL_EARNINGS_VALUE NUMBER :=0;
3629: L_INPUTS FF_EXEC.INPUTS_T;
3630: P_INPUTS FF_EXEC.INPUTS_T;