APPS.CN_LEDGER_JOURNAL_ENTRIES_API dependencies on CN_SRP_PERIODS

Line 45: FROM cn_srp_periods srp_per,

41: (SELECT X_batch_id, srp_per.srp_period_id, X_account,
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);

Line 102: FROM cn_srp_periods srp_per,

98: X_debit,
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

Line 145: FROM cn_srp_periods srp_per

141: ledger_je_id, reason)
142: (SELECT X_batch_id, srp_per.srp_period_id, X_account,
143: X_credit, X_debit, X_date,
144: cn_ledger_journal_entries_s.nextval, X_reason
145: FROM cn_srp_periods srp_per
146: WHERE salesrep_id = X_salesrep_id
147: AND period_id = X_period_id);
148:
149: SELECT cn_ledger_journal_entries_s.currval INTO JE_Return FROM dual;

Line 191: cn_srp_periods per

187:
188: SELECT rep.name, rep.salesrep_id
189: INTO X_salesrep_name, X_salesrep_id
190: FROM cn_salesreps rep,
191: cn_srp_periods per
192: WHERE per.srp_period_id = X_srp_period_id
193: AND rep.salesrep_id = per.salesrep_id;
194:
195: SELECT per.period_name, per.period_ID

Line 198: cn_srp_periods srp

194:
195: SELECT per.period_name, per.period_ID
196: INTO X_period_name, X_period_id
197: FROM cn_periods per,
198: cn_srp_periods srp
199: WHERE srp.period_id = per.period_id
200: AND srp.srp_period_id = X_srp_period_id;
201:
202: -- MLS Change