APPS.BEN_ABR_BUS dependencies on PER_SPINAL_POINTS

Line 3727: From pay_grade_rules_f a , pay_rates b , per_spinal_points c,ben_opt_f opt

3723: l_dummy varchar2(1);
3724: --
3725: cursor c2 is
3726: select 'x'
3727: From pay_grade_rules_f a , pay_rates b , per_spinal_points c,ben_opt_f opt
3728: where a.grade_rule_id = p_pay_rate_grade_rule_id
3729: and a.rate_id = b.rate_id
3730: and a.rate_type = 'SP'
3731: and c.spinal_point_id = a.grade_or_spinal_point_id

Line 3733: and opt.mapping_table_name = 'PER_SPINAL_POINTS'

3729: and a.rate_id = b.rate_id
3730: and a.rate_type = 'SP'
3731: and c.spinal_point_id = a.grade_or_spinal_point_id
3732: and c.spinal_point_id = opt.mapping_table_pk_id
3733: and opt.mapping_table_name = 'PER_SPINAL_POINTS'
3734: and a.business_group_id = p_business_group_id
3735: and c.business_group_id = p_business_group_id
3736: and b.business_group_id = p_business_group_id
3737: and opt.business_group_id = p_business_group_id