DBA Data[Home] [Help]

APPS.HXC_TIMECARD_AUDIT dependencies on HXC_DEPOSIT_PROCESSES

Line 46: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;

42: cursor c_transaction_sequence is
43: select hxc_transactions_s.nextval from dual;
44:
45: l_transaction_id hxc_transactions.transaction_id%TYPE;
46: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
47: l_data_set_id hxc_transactions.data_set_id%TYPE;
48: l_index BINARY_INTEGER;
49:
50: Begin

Line 54: from hxc_deposit_processes

50: Begin
51:
52: select deposit_process_id
53: into l_deposit_process_id
54: from hxc_deposit_processes
55: where name = 'OTL Deposit Process';
56:
57: open c_transaction_sequence;
58: fetch c_transaction_sequence into l_transaction_id;