eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_RULES dependencies on FF_FORMULAS_F

Line 978: l_fc_formula_name ff_formulas_f.formula_name%TYPE;

974: l_fc_eff_start_date DATE;
975: l_fc_eff_end_date DATE;
976: l_fc_obj_ver_num NUMBER;
977: l_for_mismatch_warn BOOLEAN;
978: l_fc_formula_name ff_formulas_f.formula_name%TYPE;
979: l_fc_formula_id ff_formulas_f.formula_id%TYPE;
980: l_fc_totamnt_iv_id NUMBER;
981: l_fc_formula_res_rul_id NUMBER;
982: ln_proration_group_name pay_event_groups.event_group_name%TYPE;

Line 979: l_fc_formula_id ff_formulas_f.formula_id%TYPE;

975: l_fc_eff_end_date DATE;
976: l_fc_obj_ver_num NUMBER;
977: l_for_mismatch_warn BOOLEAN;
978: l_fc_formula_name ff_formulas_f.formula_name%TYPE;
979: l_fc_formula_id ff_formulas_f.formula_id%TYPE;
980: l_fc_totamnt_iv_id NUMBER;
981: l_fc_formula_res_rul_id NUMBER;
982: ln_proration_group_name pay_event_groups.event_group_name%TYPE;
983: ln_proration_group_id pay_event_groups.event_group_id%TYPE;

Line 989: l_fpa_formula_name ff_formulas_f.formula_name%TYPE;

985: ln_retro_comp_ovn NUMBER;
986: ln_retro_comp_id NUMBER;
987: ln_comp_name pay_retro_components.component_name%TYPE;
988: ln_retro_type pay_retro_components.retro_type%TYPE;
989: l_fpa_formula_name ff_formulas_f.formula_name%TYPE;
990: l_fpa_formula_id ff_formulas_f.formula_id%TYPE;
991: l_fpa_ele_type_id NUMBER;
992: l_fpa_stat_proc_rule_id NUMBER;
993: l_fpa_eff_start_date DATE;

Line 990: l_fpa_formula_id ff_formulas_f.formula_id%TYPE;

986: ln_retro_comp_id NUMBER;
987: ln_comp_name pay_retro_components.component_name%TYPE;
988: ln_retro_type pay_retro_components.retro_type%TYPE;
989: l_fpa_formula_name ff_formulas_f.formula_name%TYPE;
990: l_fpa_formula_id ff_formulas_f.formula_id%TYPE;
991: l_fpa_ele_type_id NUMBER;
992: l_fpa_stat_proc_rule_id NUMBER;
993: l_fpa_eff_start_date DATE;
994: l_fpa_eff_end_date DATE;

Line 1046: FROM ff_formulas_f

1042: p_formula_name IN VARCHAR2,
1043: p_legislation_code IN VARCHAR2
1044: ) IS
1045: SELECT formula_id
1046: FROM ff_formulas_f
1047: WHERE formula_name = p_formula_name
1048: AND legislation_code = p_legislation_code;
1049:
1050: -- Get Formula Name

Line 1057: ff_formulas_f FF

1053: l_business_group_id NUMBER
1054: ) IS
1055: SELECT FF.formula_name
1056: FROM pay_status_processing_rules_f PSP,
1057: ff_formulas_f FF
1058: WHERE PSP.element_type_id = l_element_type_id
1059: AND PSP.processing_rule = l_processing_rule
1060: AND FF.formula_id = PSP.formula_id
1061: AND PSP.business_group_id = l_business_group_id