DBA Data[Home] [Help]

APPS.HR_BIS_ALERTS dependencies on HR_LOCATIONS

Line 1753: l_loc_name hr_locations.location_code%TYPE;

1749: l_orgprc hr_lookups.meaning%TYPE;
1750: l_bmt_name hr_lookups.meaning%TYPE;
1751: l_job_name per_jobs.name%TYPE;
1752: l_job_cat hr_lookups.meaning%TYPE;
1753: l_loc_name hr_locations.location_code%TYPE;
1754:
1755: l_period_name VARCHAR2(50);
1756:
1757: -- Session params

Line 2398: l_loc_name hr_locations.location_code%TYPE;

2394: l_orgprc hr_lookups.meaning%TYPE;
2395: l_bmt_name hr_lookups.meaning%TYPE;
2396: l_job_name per_jobs.name%TYPE;
2397: l_job_cat hr_lookups.meaning%TYPE := '';
2398: l_loc_name hr_locations.location_code%TYPE;
2399:
2400: l_period_name VARCHAR2(50);
2401:
2402: -- Session params

Line 2900: l_loc_name hr_locations.location_code%TYPE; -- Location name

2896: l_activity_version_name ota_activity_versions.version_name%TYPE; -- name of training course (activity version)
2897: l_actual VARCHAR2(80); -- Actual value (e.g. 25%)
2898: l_job_cat hr_lookups.meaning%TYPE; -- Job category
2899: l_job_name per_jobs.name%TYPE; -- Job name
2900: l_loc_name hr_locations.location_code%TYPE; -- Location name
2901: l_org_name per_organization_units.name%TYPE; -- Organization name
2902: l_org_type hr_lookups.meaning%TYPE; --
2903: l_orgprc hr_lookups.meaning%TYPE; -- include subordinate indicator (yes/no)
2904: l_target VARCHAR2(80); -- Target value (e.g. 75%)