53: l_rs_name cn_rate_schedules.name%TYPE;
54:
55: BEGIN
56: SELECT name INTO l_rs_name 57: FROM cn_rate_schedules_all 58: WHERE rate_schedule_id = p_rate_table_id;
59:
60: RETURN l_rs_name;
61:
Line 78: FROM cn_rate_schedules_all
74: l_rs_id cn_rate_schedules.rate_schedule_id%TYPE;
75:
76: BEGIN
77: SELECT rate_schedule_id INTO l_rs_id 78: FROM cn_rate_schedules_all 79: WHERE name = p_rate_table_name
80: AND org_id = p_org_id;
81:
82: RETURN l_rs_id;