DBA Data[Home] [Help]

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_BATCHES

Line 1175: xtr_batches b, xtr_batch_events e

1171: -- balance date entered by the user
1172: CURSOR c_accrl_comp IS
1173: SELECT max(period_end)
1174: FROM
1175: xtr_batches b, xtr_batch_events e
1176: WHERE b.company_code = p_company_code
1177: AND b.batch_id = e.batch_id
1178: AND e.event_code = 'ACCRUAL'
1179: AND b.period_end >=p_balance_date;

Line 1273: xtr_batches b,xtr_batch_events e

1269: -- balance date entered by the user
1270: CURSOR c_reval_comp IS
1271: SELECT max(period_end)
1272: FROM
1273: xtr_batches b,xtr_batch_events e
1274: WHERE
1275: b.company_code = p_company_code
1276: AND b.batch_id = e.batch_id
1277: AND e.event_code = 'REVAL'

Line 2057: from xtr_batches b, xtr_batch_events e

2053:
2054: -- Accrual Check cursor
2055: cursor CHK_ACCRLS is
2056: select 'Y'
2057: from xtr_batches b, xtr_batch_events e
2058: where b.company_code = p_PARTY_CODE
2059: and b.batch_id = e.batch_id
2060: and e.event_code = 'ACCRUAL'
2061: and b.period_end > p_oldest_date;

Line 2066: from xtr_batches b, xtr_batch_events e

2062:
2063: -- Journal Check cursor
2064: cursor CHK_JNLS is
2065: select 'Y'
2066: from xtr_batches b, xtr_batch_events e
2067: where b.company_code =p_PARTY_CODE
2068: and b.batch_id = e.batch_id
2069: and e.event_code = 'JRNLGN'
2070: and b.period_end > p_oldest_date;