DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on XLA_EVENTS

Line 190: | xla_events table. |

186: | |
187: | Procedure Name : min_mre_date |
188: | |
189: | Purpose : This Procedure gets the minimum receipt date from |
190: | xla_events table. |
191: | |
192: | Called from : DetUpgDatesFromDate |
193: | |
194: | Parameters : |

Line 207: FROM xla_events ev

203: (x_mre_date OUT NOCOPY DATE)
204: IS
205: CURSOR c_min_recp IS
206: SELECT min(ev.event_date)
207: FROM xla_events ev
208: WHERE ev.application_id = 707
209: AND ev.event_type_code = 'RECEIVE'
210: AND ev.process_status_code = 'P'
211: AND ev.event_status_code = 'P';