APPS.WF_MAINTENANCE dependencies on WF_UR_VALIDATE_STG

Line 472: from wf_ur_validate_stg

468: user_orig_system, user_orig_system_id,
469: assigning_role_start_date, assigning_role_end_date,
470: effective_start_date, effective_end_date,
471: relationship_id
472: from wf_ur_validate_stg
473: order by ROLE_NAME, USER_NAME;
474:
475: CURSOR dangling_UR_refs is
476: select rowid

Line 904: WF_DDL.TruncateTable('WF_UR_VALIDATE_STG',WF_CORE.Translate('WF_SCHEMA'),

900: --Enable parallel DML
901: execute IMMEDIATE 'alter session enable parallel dml';
902:
903: --truncate the stage table now
904: WF_DDL.TruncateTable('WF_UR_VALIDATE_STG',WF_CORE.Translate('WF_SCHEMA'),
905: FALSE);
906:
907: --
908: select min(to_number(value))

Line 925: 'INSERT /*+ append parallel(WF_UR_VALIDATE_STG,'|| l_parallelProc ||') */

921:
922: -- populate the stage table
923: -- bug 6823723. Now inserting as a dynamic DML to include the number of parallel processes
924: l_sql :=
925: 'INSERT /*+ append parallel(WF_UR_VALIDATE_STG,'|| l_parallelProc ||') */
926: INTO WF_UR_VALIDATE_STG (WURA_ID, WUR_ID , ROLE_NAME , USER_NAME ,
927: ASSIGNING_ROLE , START_DATE , END_DATE , ROLE_START_DATE, ROLE_END_DATE
928: , USER_START_DATE , USER_END_DATE , ROLE_ORIG_SYSTEM ,
929: ROLE_ORIG_SYSTEM_ID , USER_ORIG_SYSTEM , USER_ORIG_SYSTEM_ID ,

Line 926: INTO WF_UR_VALIDATE_STG (WURA_ID, WUR_ID , ROLE_NAME , USER_NAME ,

922: -- populate the stage table
923: -- bug 6823723. Now inserting as a dynamic DML to include the number of parallel processes
924: l_sql :=
925: 'INSERT /*+ append parallel(WF_UR_VALIDATE_STG,'|| l_parallelProc ||') */
926: INTO WF_UR_VALIDATE_STG (WURA_ID, WUR_ID , ROLE_NAME , USER_NAME ,
927: ASSIGNING_ROLE , START_DATE , END_DATE , ROLE_START_DATE, ROLE_END_DATE
928: , USER_START_DATE , USER_END_DATE , ROLE_ORIG_SYSTEM ,
929: ROLE_ORIG_SYSTEM_ID , USER_ORIG_SYSTEM , USER_ORIG_SYSTEM_ID ,
930: ASSIGNING_ROLE_START_DATE , ASSIGNING_ROLE_END_DATE ,