DBA Data[Home] [Help]

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_BATCHES

Line 1177: xtr_batches b, xtr_batch_events e

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

Line 1275: xtr_batches b,xtr_batch_events e

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

Line 2059: from xtr_batches b, xtr_batch_events e

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

Line 2068: from xtr_batches b, xtr_batch_events e

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