APPS.CN_API dependencies on CN_RATE_SCHEDULES

Line 73: RETURN cn_rate_schedules.name%TYPE IS

69: --| ----------------------------------------------------------------------+
70: --| Function Name : get_rate_table_name
71: --| ----------------------------------------------------------------------+
72: FUNCTION get_rate_table_name( p_rate_table_id NUMBER)
73: RETURN cn_rate_schedules.name%TYPE IS
74:
75: l_rs_name cn_rate_schedules.name%TYPE;
76:
77: BEGIN

Line 75: l_rs_name cn_rate_schedules.name%TYPE;

71: --| ----------------------------------------------------------------------+
72: FUNCTION get_rate_table_name( p_rate_table_id NUMBER)
73: RETURN cn_rate_schedules.name%TYPE IS
74:
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

Line 79: FROM cn_rate_schedules_all

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

90: --| Function Name : get_rate_table_id
91: --| ----------------------------------------------------------------------+
92: FUNCTION get_rate_table_id( p_rate_table_name VARCHAR2,
93: p_org_id NUMBER)
94: RETURN cn_rate_schedules.rate_schedule_id%TYPE IS
95:
96: l_rs_id cn_rate_schedules.rate_schedule_id%TYPE;
97:
98: BEGIN

Line 96: l_rs_id cn_rate_schedules.rate_schedule_id%TYPE;

92: FUNCTION get_rate_table_id( p_rate_table_name VARCHAR2,
93: p_org_id NUMBER)
94: RETURN cn_rate_schedules.rate_schedule_id%TYPE IS
95:
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

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;