DBA Data[Home] [Help]

APPS.EDW_SEC_PKG dependencies on EDW_SYSTEM_PARAMETERS

Line 369: x_instance_code edw_system_parameters.instance_code%type;

365: x_user_count number;
366: x_user_name fnd_user.user_name%type;
367: x_db_link_name edw_source_instances.warehouse_to_instance_link%type;
368: x_person_id number;
369: x_instance_code edw_system_parameters.instance_code%type;
370: x_pk_fixed_string varchar2(30) := '-EMPLOYEE-PERS';
371: x_pk edw_hr_person_m.asgn_assignment_pk%type;
372: x_pk_key edw_hr_person_m.asgn_assignment_pk_key%type;
373: x_name varchar2(2000); -- edw_hr_person_m.s01_name%type;

Line 418: select instance_code into x_instance_code from edw_system_parameters;

414:
415:
416: -- Find master source instance
417:
418: select instance_code into x_instance_code from edw_system_parameters;
419:
420:
421: -- Find database link to master source instance
422: