APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PAY_RATES

Line 24: FROM pay_rates pr

20: l_grade_id NUMBER;
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

Line 72: FROM pay_rates pr

68: l_grade_id NUMBER;
69:
70: CURSOR csr_chk_grade_table IS
71: SELECT 'Y'
72: FROM pay_rates pr
73: WHERE pr.rate_type = 'G'
74: AND pr.name =p_rate_table
75: AND pr.business_group_id = p_business_group_id;
76:

Line 80: FROM pay_rates pr

76:
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