DBA Data[Home] [Help]

APPS.BEN_ABR_BUS dependencies on PAY_RATES

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 3745: From pay_grade_rules_f a , pay_rates b , per_grades c,ben_pl_f pl

3741:
3742:
3743: cursor c1 is
3744: select 'x'
3745: From pay_grade_rules_f a , pay_rates b , per_grades c,ben_pl_f pl
3746: where a.grade_rule_id = p_pay_rate_grade_rule_id
3747: and a.rate_id = b.rate_id
3748: and a.rate_type = 'G'
3749: and c.grade_id = a.grade_or_spinal_point_id