APPS.EDW_HR_PERSON_M_C dependencies on STANDARD

Line 40: l_standard_name VARCHAR2(400); -- Name format for non push down levels

36: l_na_edw_fk VARCHAR2(30); -- Foreign key for dummy row
37:
38: l_push_from_level VARCHAR2(30); -- Push from level name
39: l_push_down_name VARCHAR2(400); -- Name format for push down level
40: l_standard_name VARCHAR2(400); -- Name format for non push down levels
41: l_push_down_name_display VARCHAR2(400); -- Display Name format for push down level
42: l_standard_name_display VARCHAR2(400); -- Display Name format for non push down levels
43:
44: l_temp_date DATE; -- Keeps track of execution start time

Line 42: l_standard_name_display VARCHAR2(400); -- Display Name format for non push down levels

38: l_push_from_level VARCHAR2(30); -- Push from level name
39: l_push_down_name VARCHAR2(400); -- Name format for push down level
40: l_standard_name VARCHAR2(400); -- Name format for non push down levels
41: l_push_down_name_display VARCHAR2(400); -- Display Name format for push down level
42: l_standard_name_display VARCHAR2(400); -- Display Name format for non push down levels
43:
44: l_temp_date DATE; -- Keeps track of execution start time
45: l_duration NUMBER := 0; -- Execution time
46: l_rows_inserted NUMBER := 0; -- Number of rows inserted

Line 106: /* Standard "Name" column format */

102: l_na_edw_fk := to_char(p_from_level+1) || '-NA_EDW-' || g_instance_code;
103: END IF;
104:
105: /******************************************************************************/
106: /* Standard "Name" column format */
107: /******************************************************************************/
108: l_standard_name := 'DECODE(peo.known_as||peo.first_name,NULL,'''',
109: NVL(peo.known_as,peo.first_name)||'' '')
110: ||peo.last_name ||

Line 108: l_standard_name := 'DECODE(peo.known_as||peo.first_name,NULL,'''',

104:
105: /******************************************************************************/
106: /* Standard "Name" column format */
107: /******************************************************************************/
108: l_standard_name := 'DECODE(peo.known_as||peo.first_name,NULL,'''',
109: NVL(peo.known_as,peo.first_name)||'' '')
110: ||peo.last_name ||
111: ''(''||NVL(peo.employee_number,
112: peo.applicant_number)||'')''';

Line 113: l_standard_name_display :=

109: NVL(peo.known_as,peo.first_name)||'' '')
110: ||peo.last_name ||
111: ''(''||NVL(peo.employee_number,
112: peo.applicant_number)||'')''';
113: l_standard_name_display :=
114: 'DECODE(peo.known_as||peo.first_name,NULL,'''',
115: NVL(peo.known_as,peo.first_name)||'' '')
116: ||peo.last_name';
117: /******************************************************************************/

Line 167: '||l_standard_name||',

163: sysdate,
164: null,
165: lvln.INSTANCE,
166: sysdate,
167: '||l_standard_name||',
168: '||l_standard_name_display||',
169: to_char(null),
170: lvln.person_id,
171: to_number(null),

Line 168: '||l_standard_name_display||',

164: null,
165: lvln.INSTANCE,
166: sysdate,
167: '||l_standard_name||',
168: '||l_standard_name_display||',
169: to_char(null),
170: lvln.person_id,
171: to_number(null),
172: to_char(null),