DBA Data[Home] [Help]

APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PAY_GRADE_RULES_F

Line 25: ,pay_grade_rules_f pg

21:
22: CURSOR csr_get_grade_value IS
23: SELECT pg.value
24: FROM pay_rates pr
25: ,pay_grade_rules_f pg
26: WHERE pr.rate_type= 'G'
27: AND pr.rate_id = p_rate_id
28: AND pr.rate_id = pg.rate_id
29: AND pg.grade_or_spinal_point_id = l_grade_id

Line 81: ,pay_grade_rules_f pg

77:
78: CURSOR csr_get_grade_value IS
79: SELECT pg.value
80: FROM pay_rates pr
81: ,pay_grade_rules_f pg
82: WHERE pr.rate_type= 'G'
83: AND pr.name = p_rate_table
84: AND pr.rate_id = pg.rate_id
85: AND pg.grade_or_spinal_point_id = l_grade_id