APPS.CN_API dependencies on CN_RATE_SCHEDULES

Line 51: RETURN cn_rate_schedules.name%TYPE IS

47: --| ----------------------------------------------------------------------+
48: --| Function Name : get_rate_table_name
49: --| ----------------------------------------------------------------------+
50: FUNCTION get_rate_table_name( p_rate_table_id NUMBER)
51: RETURN cn_rate_schedules.name%TYPE IS
52:
53: l_rs_name cn_rate_schedules.name%TYPE;
54:
55: BEGIN

Line 53: l_rs_name cn_rate_schedules.name%TYPE;

49: --| ----------------------------------------------------------------------+
50: FUNCTION get_rate_table_name( p_rate_table_id NUMBER)
51: RETURN cn_rate_schedules.name%TYPE IS
52:
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

Line 57: FROM cn_rate_schedules_all

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 72: RETURN cn_rate_schedules.rate_schedule_id%TYPE IS

68: --| Function Name : get_rate_table_id
69: --| ----------------------------------------------------------------------+
70: FUNCTION get_rate_table_id( p_rate_table_name VARCHAR2,
71: p_org_id NUMBER)
72: RETURN cn_rate_schedules.rate_schedule_id%TYPE IS
73:
74: l_rs_id cn_rate_schedules.rate_schedule_id%TYPE;
75:
76: BEGIN

Line 74: l_rs_id cn_rate_schedules.rate_schedule_id%TYPE;

70: FUNCTION get_rate_table_id( p_rate_table_name VARCHAR2,
71: p_org_id NUMBER)
72: RETURN cn_rate_schedules.rate_schedule_id%TYPE IS
73:
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

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;