DBA Data[Home] [Help]

APPS.HR_RATE_VALUES_SWI dependencies on PAY_GRADE_RULES_V

Line 1425: FROM PAY_GRADE_RULES_V pgr

1421: pgr.object_version_number,
1422: pgr.grade_rule_id,
1423: pgr.currency_code,
1424: NULL transaction_step_id
1425: FROM PAY_GRADE_RULES_V pgr
1426: WHERE pgr.rate_type = 'A'
1427: AND pgr.assignment_id = to_number(p_assignment_id)
1428: AND pgr.business_group_id = to_number(p_business_gp_id)
1429: AND pgr.grade_rule_id NOT IN (SELECT nvl(a.number_value, -1)

Line 1494: from pay_grade_rules_v

1490:
1491: cursor csr_asg_rate_date(l_grade_rule_id IN NUMBER) is
1492: select effective_start_date,
1493: effective_end_date
1494: from pay_grade_rules_v
1495: where grade_rule_id = l_grade_rule_id;
1496:
1497:
1498: l_rec_start_date date := null;