DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on HR_OWNER_DEFINITIONS

Line 1063: insert into hr_owner_definitions

1059: begin
1060: --
1061: -- Create a row for the current session for the product specified. This is
1062: -- used to populate application ownerships when startup data is created.
1063: insert into hr_owner_definitions
1064: (PRODUCT_SHORT_NAME,
1065: SESSION_ID)
1066: select
1067: p_app_short_name,

Line 1071: from hr_owner_definitions od

1067: p_app_short_name,
1068: userenv('sessionid')
1069: from sys.dual
1070: where not exists (select 1
1071: from hr_owner_definitions od
1072: where od.product_short_name = p_app_short_name
1073: and session_id = userenv('sessionid'));
1074: --
1075: end create_owner_definitions;