APPS.XLA_ASSIGNMENT_DEFNS_F_PKG dependencies on XLA_ASSIGNMENT_DEFNS_B

Line 86: FROM xla_assignment_defns_b

82: IS
83:
84: CURSOR c IS
85: SELECT rowid
86: FROM xla_assignment_defns_b
87: WHERE program_code = x_program_code
88: AND program_owner_code = x_program_owner_code
89: AND assignment_code = x_assignment_code
90: AND assignment_owner_code = x_assignment_owner_code

Line 107: INSERT INTO xla_assignment_defns_b

103: p_level => C_LEVEL_PROCEDURE);
104: END IF;
105:
106:
107: INSERT INTO xla_assignment_defns_b
108: (creation_date
109: ,created_by
110: ,program_code
111: ,program_owner_code

Line 205: FROM xla_assignment_defns_b

201: IS
202:
203: CURSOR c IS
204: SELECT enabled_flag, ledger_id
205: FROM xla_assignment_defns_b
206: WHERE program_code = x_program_code
207: AND program_owner_code = x_program_owner_code
208: AND assignment_code = x_assignment_code
209: AND assignment_owner_code = x_assignment_owner_code

Line 314: UPDATE xla_assignment_defns_b

310: p_module => l_log_module,
311: p_level => C_LEVEL_PROCEDURE);
312: END IF;
313:
314: UPDATE xla_assignment_defns_b
315: SET
316: last_update_date = x_last_update_date
317: ,ledger_id = x_ledger_id
318: ,enabled_flag = x_enabled_flag

Line 392: DELETE FROM xla_assignment_defns_b

388: IF (SQL%NOTFOUND) THEN
389: RAISE NO_DATA_FOUND;
390: END IF;
391:
392: DELETE FROM xla_assignment_defns_b
393: WHERE program_code = x_program_code
394: AND program_owner_code = x_program_owner_code
395: AND assignment_code = x_assignment_code
396: AND assignment_owner_code = x_assignment_owner_code;

Line 434: FROM xla_assignment_defns_b b

430:
431: DELETE FROM xla_assignment_defns_tl T
432: WHERE NOT EXISTS
433: (SELECT NULL
434: FROM xla_assignment_defns_b b
435: WHERE b.program_code = t.program_code
436: AND b.program_owner_code = t.program_owner_code
437: AND b.assignment_code = t.assignment_code
438: AND b.assignment_owner_code = t.assignment_owner_code);