APPS.PQP_RATES_HISTORY_CALC dependencies on PER_ASSIGNMENTS_F

Line 1643: l_business_group_id per_assignments_f.business_group_id%TYPE;

1639: l_fetched_rate NUMBER;
1640: l_step_ceiling per_spinal_points.spinal_point%TYPE;
1641: l_step_ceiling_rate NUMBER;
1642: l_user_col_name VARCHAR2(50);
1643: l_business_group_id per_assignments_f.business_group_id%TYPE;
1644: l_error_message VARCHAR2(200) ;
1645: l_error_code NUMBER ;
1646: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1647: l_input_value_default_txt pay_input_values_f.default_value%TYPE;

Line 1712: FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr

1708: --
1709: CURSOR csr_grade_rate
1710: IS
1711: SELECT fnd_number.canonical_to_number(pgr.VALUE) --Modified for the bug 11795180
1712: FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr
1713: WHERE paf.assignment_id = p_assignment_id
1714: AND paf.grade_id = pgr.grade_or_spinal_point_id
1715: AND pgr.rate_type = 'G'
1716: AND pgr.rate_id = pr.rate_id

Line 1731: FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr

1727: --
1728: CURSOR csr_grade_rate_like
1729: IS
1730: SELECT fnd_number.canonical_to_number(pgr.VALUE) --Modified for the bug 11795180
1731: FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr
1732: WHERE paf.assignment_id = p_assignment_id
1733: AND paf.grade_id = pgr.grade_or_spinal_point_id
1734: AND pgr.rate_type = 'G'
1735: AND pgr.rate_id = pr.rate_id