APPS.PAY_US_RULES dependencies on PAY_EVENT_GROUPS

Line 982: ln_proration_group_name pay_event_groups.event_group_name%TYPE;

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;
984: ln_retro_comp_usge_id NUMBER;
985: ln_retro_comp_ovn NUMBER;
986: ln_retro_comp_id NUMBER;

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

Line 1070: FROM pay_event_groups

1066: CURSOR get_proration_group_id( l_proration_group_name VARCHAR2
1067: ,l_bg_id NUMBER
1068: ,l_legislation_code VARCHAR2) IS
1069: SELECT event_group_id
1070: FROM pay_event_groups
1071: WHERE event_group_name = l_proration_group_name
1072: AND ((business_group_id IS NULL and legislation_code IS NULL) OR
1073: (business_group_id IS NULL and legislation_code = l_legislation_code) OR
1074: (business_group_id = l_bg_id and legislation_code IS NULL)