DBA Data[Home] [Help]

APPS.PER_POS_STRUCT_ELEMENTS_PKG2 dependencies on PER_SECURITY_PROFILES

Line 223: FROM PER_SECURITY_PROFILES PSP

219: l_dummy:= NULL;
220: begin
221: SELECT '1'
222: into l_dummy
223: FROM PER_SECURITY_PROFILES PSP
224: WHERE PSP.business_group_id + 0 = X_Business_Group_Id
225: AND (PSP.POSITION_ID = X_Subordinate_Position_Id
226: OR PSP.POSITION_ID = X_Parent_Position_Id)
227: AND PSP.POSITION_STRUCTURE_ID = l_Position_Structure_Id;

Line 241: FROM PER_SECURITY_PROFILES PSP

237: l_dummy:= NULL;
238: begin
239: SELECT '1'
240: into l_dummy
241: FROM PER_SECURITY_PROFILES PSP
242: WHERE PSP.business_group_id + 0 = X_Business_Group_Id
243: AND PSP.POSITION_ID = X_Position_Id
244: AND PSP.POSITION_STRUCTURE_ID = l_position_structure_id;
245: exception when no_data_found then