APPS.HRI_OPL_SPRTN_RSNS dependencies on HRI_INV_SPRTN_RSNS

Line 58: hri_inv_sprtn_rsns spr

54: CURSOR leaving_reasons_csr IS
55: SELECT hrl.lookup_code lookup_code,
56: DECODE(spr.reason, null, 'N', 'Y') exists_flag
57: FROM hr_standard_lookups hrl,
58: hri_inv_sprtn_rsns spr
59: WHERE hrl.lookup_code = spr.reason (+)
60: AND hrl.lookup_type = 'LEAV_REAS'
61: UNION ALL
62: SELECT 'NA_EDW' lookup_code,

Line 67: FROM hri_inv_sprtn_rsns spr

63: 'N' exists_flag
64: FROM dual
65: WHERE NOT EXISTS
66: (SELECT -1
67: FROM hri_inv_sprtn_rsns spr
68: WHERE spr.reason = 'NA_EDW')
69: UNION ALL
70: SELECT 'NA_EDW' lookup_code,
71: 'Y' exists_flag

Line 75: FROM hri_inv_sprtn_rsns spr

71: 'Y' exists_flag
72: FROM dual
73: WHERE EXISTS
74: (SELECT -1
75: FROM hri_inv_sprtn_rsns spr
76: WHERE spr.reason = 'NA_EDW');
77: --
78: BEGIN
79: --

Line 87: dbg('insert/update records in hri_inv_sprtn_rsns');

83: --
84: l_formula_id := hr_person_flex_logic.GetTermTypeFormula
85: ( p_business_group_id => 0 );
86: --
87: dbg('insert/update records in hri_inv_sprtn_rsns');
88: --
89: -- Loop through all the leaving reasons defined
90: --
91: FOR v_leaving_reason IN leaving_reasons_csr LOOP

Line 109: INTO hri_inv_sprtn_rsns

105: --
106: -- Insert the details into the table
107: --
108: INSERT
109: INTO hri_inv_sprtn_rsns
110: (reason
111: ,termination_type
112: ,update_allowed_flag
113: )

Line 123: UPDATE hri_inv_sprtn_rsns

119: ELSE
120: --
121: -- Update the reason
122: --
123: UPDATE hri_inv_sprtn_rsns
124: SET termination_type = l_term_type
125: WHERE reason = v_leaving_reason.lookup_code;
126: --
127: END IF;

Line 175: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_INV_SPRTN_RSNS';

171: END IF;
172: --
173: -- Truncate the table
174: --
175: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_INV_SPRTN_RSNS';
176: --
177: EXECUTE IMMEDIATE(l_sql_stmt);
178: --
179: -- Assigning sysdate and user for who columns

Line 186: INSERT /*+ APPEND */ INTO hri_inv_sprtn_rsns

182: l_user := fnd_global.user_id;
183: --
184: -- Insert into the table
185: --
186: INSERT /*+ APPEND */ INTO hri_inv_sprtn_rsns
187: ( reason
188: , termination_type
189: , update_allowed_flag
190: , last_update_date

Line 269: hri_bpl_conc_log.record_process_start('HRI_INV_SPRTN_RSNS');

265: END IF;
266: --
267: -- Bug 4105868: Collection Diagnostics
268: --
269: hri_bpl_conc_log.record_process_start('HRI_INV_SPRTN_RSNS');
270: --
271: -- If the flag for foundation has been set then run the load in shared mode,
272: -- else run in normal mode
273: --