APPS.FND_SEQNUM dependencies on FND_ORACLE_USERID

Line 408: v_fnd_schema fnd_oracle_userid.oracle_username%TYPE;

404: procedure create_db_seq ( db_seq_name in fnd_document_sequences.db_sequence_name%TYPE,
405: init_value in fnd_document_sequences.initial_value%TYPE )
406: is
407: v_ddl_sql varchar2(150);
408: v_fnd_schema fnd_oracle_userid.oracle_username%TYPE;
409: v_stage number := 0; /* sets the stage of execution for exception processing */
410:
411: begin
412: -- First get the FND schema name

Line 415: fnd_oracle_userid fou,

411: begin
412: -- First get the FND schema name
413: SELECT fou.oracle_username into v_fnd_schema
414: FROM fnd_product_installations fpi,
415: fnd_oracle_userid fou,
416: fnd_application fa
417: WHERE fpi.application_id = fa.application_id
418: AND fpi.oracle_id = fou.oracle_id
419: AND fa.application_short_name = 'FND';