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 PAY_RETRO_COMPONENTS

Line 1042: ln_comp_name pay_retro_components.component_name%TYPE;

1038: ln_proration_group_id pay_event_groups.event_group_id%TYPE;
1039: ln_retro_comp_usge_id NUMBER;
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;

Line 1043: ln_retro_type pay_retro_components.retro_type%TYPE;

1039: ln_retro_comp_usge_id NUMBER;
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;

Line 1138: FROM pay_retro_components

1134: ,l_retro_type VARCHAR2
1135: ,l_legislation_code VARCHAR2
1136: ) IS
1137: SELECT retro_component_id
1138: FROM pay_retro_components
1139: WHERE component_name = l_comp_name
1140: AND retro_type = l_retro_type
1141: AND legislation_code = l_legislation_code;/*For seeded retro component, US
1142: legislation_code will be present