DBA Data[Home] [Help]

APPS.PAY_FR_DB_PAY_SETUP dependencies on HR_OWNER_DEFINITIONS

Line 1038: insert into hr_owner_definitions

1034: begin
1035: --
1036: -- Create a row for the current session for the product specified. This is
1037: -- used to populate application ownerships when startup data is created.
1038: insert into hr_owner_definitions
1039: (PRODUCT_SHORT_NAME,
1040: SESSION_ID)
1041: select
1042: p_app_short_name,

Line 1046: from hr_owner_definitions od

1042: p_app_short_name,
1043: userenv('sessionid')
1044: from sys.dual
1045: where not exists (select 1
1046: from hr_owner_definitions od
1047: where od.product_short_name = p_app_short_name
1048: and session_id = userenv('sessionid'));
1049: --
1050: end create_owner_definitions;