APPS.PAY_US_RULES dependencies on FF_FORMULAS_F

Line 1033: l_fc_formula_name ff_formulas_f.formula_name%TYPE;

1029: l_fc_eff_start_date DATE;
1030: l_fc_eff_end_date DATE;
1031: l_fc_obj_ver_num NUMBER;
1032: l_for_mismatch_warn BOOLEAN;
1033: l_fc_formula_name ff_formulas_f.formula_name%TYPE;
1034: l_fc_formula_id ff_formulas_f.formula_id%TYPE;
1035: l_fc_totamnt_iv_id NUMBER;
1036: l_fc_formula_res_rul_id NUMBER;
1037: ln_proration_group_name pay_event_groups.event_group_name%TYPE;

Line 1034: l_fc_formula_id ff_formulas_f.formula_id%TYPE;

1030: l_fc_eff_end_date DATE;
1031: l_fc_obj_ver_num NUMBER;
1032: l_for_mismatch_warn BOOLEAN;
1033: l_fc_formula_name ff_formulas_f.formula_name%TYPE;
1034: l_fc_formula_id ff_formulas_f.formula_id%TYPE;
1035: l_fc_totamnt_iv_id NUMBER;
1036: l_fc_formula_res_rul_id NUMBER;
1037: ln_proration_group_name pay_event_groups.event_group_name%TYPE;
1038: ln_proration_group_id pay_event_groups.event_group_id%TYPE;

Line 1044: l_fpa_formula_name ff_formulas_f.formula_name%TYPE;

1040: ln_retro_comp_ovn NUMBER;
1041: ln_retro_comp_id NUMBER;
1042: ln_comp_name pay_retro_components.component_name%TYPE;
1043: ln_retro_type pay_retro_components.retro_type%TYPE;
1044: l_fpa_formula_name ff_formulas_f.formula_name%TYPE;
1045: l_fpa_formula_id ff_formulas_f.formula_id%TYPE;
1046: l_fpa_ele_type_id NUMBER;
1047: l_fpa_stat_proc_rule_id NUMBER;
1048: l_fpa_eff_start_date DATE;

Line 1045: l_fpa_formula_id ff_formulas_f.formula_id%TYPE;

1041: ln_retro_comp_id NUMBER;
1042: ln_comp_name pay_retro_components.component_name%TYPE;
1043: ln_retro_type pay_retro_components.retro_type%TYPE;
1044: l_fpa_formula_name ff_formulas_f.formula_name%TYPE;
1045: l_fpa_formula_id ff_formulas_f.formula_id%TYPE;
1046: l_fpa_ele_type_id NUMBER;
1047: l_fpa_stat_proc_rule_id NUMBER;
1048: l_fpa_eff_start_date DATE;
1049: l_fpa_eff_end_date DATE;

Line 1101: FROM ff_formulas_f

1097: p_formula_name IN VARCHAR2,
1098: p_legislation_code IN VARCHAR2
1099: ) IS
1100: SELECT formula_id
1101: FROM ff_formulas_f
1102: WHERE formula_name = p_formula_name
1103: AND legislation_code = p_legislation_code;
1104:
1105: -- Get Formula Name

Line 1112: ff_formulas_f FF

1108: l_business_group_id NUMBER
1109: ) IS
1110: SELECT FF.formula_name
1111: FROM pay_status_processing_rules_f PSP,
1112: ff_formulas_f FF
1113: WHERE PSP.element_type_id = l_element_type_id
1114: AND PSP.processing_rule = l_processing_rule
1115: AND FF.formula_id = PSP.formula_id
1116: AND PSP.business_group_id = l_business_group_id