DBA Data[Home] [Help]

APPS.BEN_ABR_BUS dependencies on PER_GRADES

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

Line 3751: and pl.mapping_table_name = 'PER_GRADES'

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
3750: and c.grade_id = pl.mapping_table_pk_id
3751: and pl.mapping_table_name = 'PER_GRADES'
3752: and a.business_group_id = p_business_group_id
3753: and c.business_group_id = p_business_group_id
3754: and b.business_group_id = p_business_group_id
3755: and pl.business_group_id = p_business_group_id