DBA Data[Home] [Help]

APPS.CN_LEDGER_JOURNAL_ENTRIES_API dependencies on CN_LEDGER_JE_BATCHES

Line 46: cn_ledger_je_batches batch

42: X_credit, X_debit, X_date,
43: cn_ledger_journal_entries_s.nextval,
44: batch.reason
45: FROM cn_srp_periods srp_per,
46: cn_ledger_je_batches batch
47: WHERE salesrep_id = X_salesrep_id
48: AND period_id = X_period_id
49: AND batch.batch_id = X_batch_id);
50:

Line 103: cn_ledger_je_batches batch

99: X_date,
100: cn_ledger_journal_entries_s.nextval,
101: batch.reason
102: FROM cn_srp_periods srp_per,
103: cn_ledger_je_batches batch
104: WHERE salesrep_id = X_salesrep_id
105: AND period_id = x_period_id
106: AND credit_type_id = x_credit_type_id
107: AND role_id = x_role_id

Line 175: FROM cn_ledger_je_batches

171: BEGIN
172:
173: SELECT who, reason, decode(status, 'POSTED', 'Y', 'N')
174: INTO X_who_name, X_reason, X_posted
175: FROM cn_ledger_je_batches
176: WHERE batch_id = X_batch_id;
177:
178: EXCEPTION
179: