APPS.PAY_US_RULES dependencies on PAY_EVENT_GROUPS

Line 1037: ln_proration_group_name pay_event_groups.event_group_name%TYPE;

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;
1039: ln_retro_comp_usge_id NUMBER;
1040: ln_retro_comp_ovn NUMBER;
1041: ln_retro_comp_id NUMBER;

Line 1038: ln_proration_group_id pay_event_groups.event_group_id%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;
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;

Line 1125: FROM pay_event_groups

1121: CURSOR get_proration_group_id( l_proration_group_name VARCHAR2
1122: ,l_bg_id NUMBER
1123: ,l_legislation_code VARCHAR2) IS
1124: SELECT event_group_id
1125: FROM pay_event_groups
1126: WHERE event_group_name = l_proration_group_name
1127: AND ((business_group_id IS NULL and legislation_code IS NULL) OR
1128: (business_group_id IS NULL and legislation_code = l_legislation_code) OR
1129: (business_group_id = l_bg_id and legislation_code IS NULL)