DBA Data[Home] [Help]

APPS.HRI_OPL_PERIOD_OF_WORK dependencies on BIS_BUCKET

Line 190: FROM bis_bucket bkt,

186: 'CWK'
187: ELSE
188: NULL
189: END wkth_wktyp_sk_fk
190: FROM bis_bucket bkt,
191: bis_bucket_customizations bbc
192: WHERE bkt.bucket_id = bbc.bucket_id
193: AND bkt.short_name IN ('HRI_DBI_LOW_BAND_CURRENT','HRI_DBI_POW_PLCMNT_BAND');
194:

Line 191: bis_bucket_customizations bbc

187: ELSE
188: NULL
189: END wkth_wktyp_sk_fk
190: FROM bis_bucket bkt,
191: bis_bucket_customizations bbc
192: WHERE bkt.bucket_id = bbc.bucket_id
193: AND bkt.short_name IN ('HRI_DBI_LOW_BAND_CURRENT','HRI_DBI_POW_PLCMNT_BAND');
194:
195: BEGIN

Line 204: -- Loop for 10 times (since there are 10 buckets in bis_bucket table)

200: --
201: FETCH pow_csr INTO l_pow_bucket_record;
202: EXIT WHEN pow_csr%NOTFOUND;
203: --
204: -- Loop for 10 times (since there are 10 buckets in bis_bucket table)
205: --
206: FOR n IN 1..10 LOOP
207: --
208: -- Check if the table needs to be populated