APPS.HR_BIS_ALERTS dependencies on PER_ORGANIZATION_UNITS

Line 1296: l_org_name per_organization_units.name%TYPE;

1292: l_dummy VARCHAR2(2000);
1293: l_freq_code VARCHAR2(4);
1294: l_subject fnd_new_messages.message_text%TYPE;
1295: l_message VARCHAR2(2000);
1296: l_org_name per_organization_units.name%TYPE;
1297: l_period_name VARCHAR2(50);
1298: l_param VARCHAR2(2000);
1299: l_report_name VARCHAR2(8) := 'HRMNPLOS';
1300: l_return_status VARCHAR2(2000);

Line 1747: l_org_name per_organization_units.name%TYPE;

1743: l_error VARCHAR2(2000);
1744: l_param VARCHAR2(2000);
1745:
1746: -- Dimension Params
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;

Line 2392: l_org_name per_organization_units.name%TYPE;

2388:
2389: l_actual VARCHAR2(30);
2390: l_target VARCHAR2(30);
2391:
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;

Line 2901: l_org_name per_organization_units.name%TYPE; -- Organization name

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%)
2905: l_period_name VARCHAR2(50);