APPS.HR_BIS_ALERTS dependencies on PER_JOBS

Line 1751: l_job_name per_jobs.name%TYPE;

1747: l_org_name per_organization_units.name%TYPE;
1748: l_org_type hr_lookups.meaning%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);

Line 2396: l_job_name per_jobs.name%TYPE;

2392: l_org_name per_organization_units.name%TYPE;
2393: l_org_type hr_lookups.meaning%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);

Line 2899: l_job_name per_jobs.name%TYPE; -- Job name

2895:
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)