APPS.PQH_RLM_BUS dependencies on PQH_ROUTING_LISTS

Line 111: from pqh_routing_lists a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pqh_routing_lists a
112: where a.routing_list_id = p_routing_list_id;
113: --
114: Begin
115: --

Line 127: -- check if routing_list_id value exists in pqh_routing_lists table

123: and nvl(p_routing_list_id,hr_api.g_number)
124: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if routing_list_id value exists in pqh_routing_lists table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

Line 136: -- raise error as FK does not relate to PK in pqh_routing_lists

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in pqh_routing_lists
137: -- table.
138: --
139: hr_utility.set_message(8302, 'PQH_INVALID_ROUTING_LIST');
140: hr_utility.raise_error;

Line 540: from pqh_routing_lists

536: l_dummy varchar2(10);
537: --
538: cursor c_routing_list_enable_flag(p_routing_list_id number) is
539: select enable_flag
540: from pqh_routing_lists
541: where routing_list_id = p_routing_list_id;
542: --
543: cursor c_role_enable_flag(p_role_id number) is
544: select enable_flag