75: l_rs_name cn_rate_schedules.name%TYPE;
76:
77: BEGIN
78: SELECT name INTO l_rs_name 79: FROM cn_rate_schedules_all 80: WHERE rate_schedule_id = p_rate_table_id;
81:
82: RETURN l_rs_name;
83:
Line 100: FROM cn_rate_schedules_all
96: l_rs_id cn_rate_schedules.rate_schedule_id%TYPE;
97:
98: BEGIN
99: SELECT rate_schedule_id INTO l_rs_id 100: FROM cn_rate_schedules_all 101: WHERE name = p_rate_table_name
102: AND org_id = p_org_id;
103:
104: RETURN l_rs_id;