APPS.HRI_BPL_PERIOD_OF_WORK dependencies on BIS_BUCKET

Line 19: -- For storing the row fetched from BIS_BUCKET that stores POW information

15: g_low_months_service NUMBER;
16: g_low_latest_hire_date DATE;
17:
18: --
19: -- For storing the row fetched from BIS_BUCKET that stores POW information
20: --
21: g_pow_bucket_emp BIS_BUCKET_CUSTOMIZATIONS%rowtype;
22: g_pow_bucket_cwk BIS_BUCKET_CUSTOMIZATIONS%rowtype;
23: --

Line 21: g_pow_bucket_emp BIS_BUCKET_CUSTOMIZATIONS%rowtype;

17:
18: --
19: -- For storing the row fetched from BIS_BUCKET that stores POW information
20: --
21: g_pow_bucket_emp BIS_BUCKET_CUSTOMIZATIONS%rowtype;
22: g_pow_bucket_cwk BIS_BUCKET_CUSTOMIZATIONS%rowtype;
23: --
24: -- Number table type with varchar2 indexing.
25: --

Line 22: g_pow_bucket_cwk BIS_BUCKET_CUSTOMIZATIONS%rowtype;

18: --
19: -- For storing the row fetched from BIS_BUCKET that stores POW information
20: --
21: g_pow_bucket_emp BIS_BUCKET_CUSTOMIZATIONS%rowtype;
22: g_pow_bucket_cwk BIS_BUCKET_CUSTOMIZATIONS%rowtype;
23: --
24: -- Number table type with varchar2 indexing.
25: --
26: TYPE g_index_by_varchar2_num_tab IS TABLE OF NUMBER INDEX BY VARCHAR2(30);

Line 493: FROM bis_bucket_customizations bb,

489: -- 4293064 Bucket definition should be picked from the bucket customization table
490: --
491: CURSOR c_bucket (c_bucket VARCHAR2) IS
492: SELECT bb.*
493: FROM bis_bucket_customizations bb,
494: bis_bucket b
495: WHERE b.short_name = c_bucket
496: AND b.bucket_id = bb.bucket_id;
497: --

Line 494: bis_bucket b

490: --
491: CURSOR c_bucket (c_bucket VARCHAR2) IS
492: SELECT bb.*
493: FROM bis_bucket_customizations bb,
494: bis_bucket b
495: WHERE b.short_name = c_bucket
496: AND b.bucket_id = bb.bucket_id;
497: --
498: BEGIN

Line 570: FROM bis_bucket_customizations bb,

566: l_band NUMBER;
567: --
568: CURSOR c_bucket (c_bucket VARCHAR2) IS
569: SELECT bb.*
570: FROM bis_bucket_customizations bb,
571: bis_bucket b
572: WHERE b.short_name = c_bucket
573: AND b.bucket_id = bb.bucket_id;
574: --

Line 571: bis_bucket b

567: --
568: CURSOR c_bucket (c_bucket VARCHAR2) IS
569: SELECT bb.*
570: FROM bis_bucket_customizations bb,
571: bis_bucket b
572: WHERE b.short_name = c_bucket
573: AND b.bucket_id = bb.bucket_id;
574: --
575: BEGIN