APPS.PQH_RHT_BUS dependencies on PQH_ROLES

Line 937: from pqh_roles a

933: l_dummy varchar2(1);
934: --
935: cursor c1 is
936: select null
937: from pqh_roles a
938: where a.role_id = p_forwarded_to_role_id
939: and nvl(a.enable_flag,'X') ='Y';
940: --
941: Begin

Line 955: -- check if forwarded_to_role_id value exists in pqh_roles table

951: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_role_id,hr_api.g_number)
952: or not l_api_updating) and
953: p_forwarded_to_role_id is not null then
954: --
955: -- check if forwarded_to_role_id value exists in pqh_roles table
956: hr_utility.set_location('checking forwarded_to_role '||p_forwarded_to_role_id||l_proc,5);
957: --
958: open c1;
959: --

Line 965: -- raise error as FK does not relate to PK in pqh_roles table

961: if c1%notfound then
962: --
963: close c1;
964: --
965: -- raise error as FK does not relate to PK in pqh_roles table
966: -- table.
967: --
968: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
969: hr_utility.raise_error;

Line 1017: from pqh_roles a

1013: l_dummy varchar2(1);
1014: --
1015: cursor c1 is
1016: select null
1017: from pqh_roles a
1018: where a.role_id = p_forwarded_by_role_id
1019: and nvl(a.enable_flag,'X') ='Y';
1020: --
1021: Begin

Line 1035: -- check if forwarded_by_role_id value exists in pqh_roles table

1031: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_role_id,hr_api.g_number)
1032: or not l_api_updating) and
1033: p_forwarded_by_role_id is not null then
1034: --
1035: -- check if forwarded_by_role_id value exists in pqh_roles table
1036: hr_utility.set_location('checking forwarded_by_role '||p_forwarded_by_role_id||l_proc,5);
1037: --
1038: open c1;
1039: --