eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_RATES_HISTORY_CALC dependencies on PAY_RATES

Line 1662: ,pay_rates pr

1658: CURSOR csr_spinal_pay_scale
1659: IS
1660: SELECT TO_NUMBER(pgr.VALUE)
1661: FROM pay_grade_rules_f pgr
1662: ,pay_rates pr
1663: ,per_spinal_point_placements_f spp
1664: ,per_spinal_point_steps_f sps
1665: WHERE spp.assignment_id = p_assignment_id
1666: AND UPPER(pr.NAME) = UPPER(p_qualifier)

Line 1687: ,pay_rates pr

1683: CURSOR csr_spinal_pay_scale_like
1684: IS
1685: SELECT TO_NUMBER(pgr.VALUE)
1686: FROM pay_grade_rules_f pgr
1687: ,pay_rates pr
1688: ,per_spinal_point_placements_f spp
1689: ,per_spinal_point_steps_f sps
1690: WHERE spp.assignment_id = p_assignment_id
1691: AND UPPER(pr.NAME) LIKE UPPER(p_qualifier)

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 TO_NUMBER(pgr.VALUE)
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 TO_NUMBER(pgr.VALUE)
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