DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_RETRO_COMPONENTS

Line 987: ln_comp_name pay_retro_components.component_name%TYPE;

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

Line 988: ln_retro_type pay_retro_components.retro_type%TYPE;

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

Line 1083: FROM pay_retro_components

1079: ,l_retro_type VARCHAR2
1080: ,l_legislation_code VARCHAR2
1081: ) IS
1082: SELECT retro_component_id
1083: FROM pay_retro_components
1084: WHERE component_name = l_comp_name
1085: AND retro_type = l_retro_type
1086: AND legislation_code = l_legislation_code;/*For seeded retro component, US
1087: legislation_code will be present