eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_CA_EE_EXTRACT_PKG dependencies on HR_LOCATIONS

Line 641: hr_locations hl,

637: count(distinct paf.person_id) count_province_cma,
638: hl1.meaning meaning
639: from
640: per_assignments_f paf,
641: hr_locations hl,
642: hr_lookups hl1,
643: per_people_f ppf ,
644: per_person_types ppt,
645: per_jobs pj,

Line 2176: hr_locations hl1,

2172: per_jobs pj,
2173: per_pay_proposals_v2 pppv,
2174: per_people_f ppf,
2175: per_assignments_f paf,
2176: hr_locations hl1,
2177: per_person_types ppt,
2178: per_ca_ee_report_lines pert,
2179: hr_lookups hl2,
2180: hr_soft_coding_keyflex hsck,

Line 2273: hr_locations hl1,

2269: per_jobs pj,
2270: per_pay_proposals_v2 pppv,
2271: per_people_f ppf,
2272: per_assignments_f paf,
2273: hr_locations hl1,
2274: per_person_types ppt,
2275: per_ca_ee_report_lines pert,
2276: hr_lookups hl2,
2277: hr_soft_coding_keyflex hsck,

Line 2361: v_cma_province hr_locations.region_1%TYPE;

2357: v_max_salary number;
2358: v_min_salary number;
2359: v_meaning hr_lookups.meaning%TYPE;
2360: v_employment_category per_assignments_f.employment_category%TYPE;
2361: v_cma_province hr_locations.region_1%TYPE;
2362:
2363: j_flag varchar2(1) := 'F';
2364:
2365: cursor cur_meaning(cp number) is

Line 2402: hr_locations hl1,

2398: per_jobs pj,
2399: per_assignments_f paf,
2400: per_people_f ppf,
2401: per_pay_proposals_v2 pppv,
2402: hr_locations hl1,
2403: per_person_types ppt,
2404: hr_soft_coding_keyflex hsck,
2405: per_pay_bases ppb
2406: where

Line 2493: prev_cma_province hr_locations.region_1%TYPE;

2489: v_sex per_people_f.sex%TYPE;
2490: prev_employment_category per_assignments_f.employment_category%TYPE;
2491: prev_sex per_people_f.sex%TYPE;
2492: prev_j number := 0;
2493: prev_cma_province hr_locations.region_1%TYPE;
2494: prev_naic_code hr_lookups.lookup_code%TYPE;
2495: prev_meaning hr_lookups.meaning%TYPE;
2496:
2497: cursor cur_count(range number,

Line 2509: hr_locations hl1,

2505: per_jobs pj,
2506: per_assignments_f paf,
2507: per_people_f ppf,
2508: per_pay_proposals_v2 pppv,
2509: hr_locations hl1,
2510: per_person_types ppt,
2511: hr_soft_coding_keyflex hsck,
2512: per_pay_bases ppb
2513: where

Line 3238: hr_locations hl1,

3234: per_assignments_f paf,
3235: per_people_f ppf,
3236: per_pay_proposals_v2 pppv,
3237: per_person_types ppt,
3238: hr_locations hl1,
3239: per_ca_ee_report_lines pert,
3240: hr_lookups hl2,
3241: hr_soft_coding_keyflex hsck,
3242: per_pay_bases ppb

Line 3318: hr_locations hl1,

3314: per_assignments_f paf,
3315: per_people_f ppf,
3316: per_pay_proposals_v2 pppv,
3317: per_person_types ppt,
3318: hr_locations hl1,
3319: per_ca_ee_report_lines pert,
3320: hr_lookups hl2,
3321: hr_soft_coding_keyflex hsck,
3322: per_pay_bases ppb

Line 3394: v_cma_province hr_locations.region_1%TYPE;

3390: v_employment_category per_assignments_f.employment_category%TYPE;
3391: prev_employment_category per_assignments_f.employment_category%TYPE;
3392: prev_sex per_people_f.sex%TYPE;
3393: prev_x number := 0;
3394: v_cma_province hr_locations.region_1%TYPE;
3395: prev_naic_code hr_lookups.lookup_code%TYPE;
3396:
3397:
3398: cursor cur_meaning(cp number) is

Line 3430: hr_locations hl1,

3426: per_assignments_f paf,
3427: per_people_f ppf,
3428: per_pay_proposals_v2 pppv,
3429: per_person_types ppt,
3430: hr_locations hl1,
3431: per_ca_ee_report_lines pert,
3432: hr_lookups hl2,
3433: hr_soft_coding_keyflex hsck,
3434: per_pay_bases ppb

Line 3514: hr_locations hl1,

3510: per_assignments_f paf,
3511: per_people_f ppf,
3512: per_pay_proposals_v2 pppv,
3513: per_person_types ppt,
3514: hr_locations hl1,
3515: per_ca_ee_report_lines pert,
3516: hr_lookups hl2,
3517: hr_soft_coding_keyflex hsck,
3518: per_pay_bases ppb

Line 4359: hr_locations hl1,

4355: per_jobs pj,
4356: per_assignments_f paf,
4357: per_people_f ppf,
4358: per_person_types ppt,
4359: hr_locations hl1,
4360: per_ca_ee_report_lines pert,
4361: hr_lookups hl2,
4362: hr_soft_coding_keyflex hsck
4363: where

Line 4439: hr_locations hl1,

4435: per_jobs pj,
4436: per_assignments_f paf,
4437: per_people_f ppf,
4438: per_person_types ppt,
4439: hr_locations hl1,
4440: per_ca_ee_report_lines pert,
4441: hr_lookups hl2,
4442: hr_soft_coding_keyflex hsck
4443: where

Line 4514: v_province hr_locations.region_1%TYPE;

4510: v_count number(10);
4511: v_meaning hr_lookups.meaning%TYPE;
4512: v_employment_category per_assignments_f.employment_category%TYPE;
4513: v_sex per_people_f.sex%TYPE;
4514: v_province hr_locations.region_1%TYPE;
4515: prev_meaning hr_lookups.meaning%TYPE := 'test';
4516: prev_employment_category per_assignments_f.employment_category%TYPE := 'test';
4517: prev_sex per_people_f.sex%TYPE := 'test';
4518: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 4553: hr_locations hl1,

4549: per_jobs pj,
4550: per_assignments_f paf,
4551: per_people_f ppf,
4552: per_person_types ppt,
4553: hr_locations hl1,
4554: per_ca_ee_report_lines pert,
4555: hr_lookups hl2,
4556: hr_soft_coding_keyflex hsck
4557: where

Line 4636: hr_locations hl1,

4632: per_jobs pj,
4633: per_assignments_f paf,
4634: per_people_f ppf,
4635: per_person_types ppt,
4636: hr_locations hl1,
4637: per_ca_ee_report_lines pert,
4638: hr_lookups hl2,
4639: hr_soft_coding_keyflex hsck
4640: where

Line 5149: hr_locations hl1,

5145: per_jobs pj,
5146: per_assignments_f paf,
5147: per_people_f ppf,
5148: per_person_types ppt,
5149: hr_locations hl1,
5150: per_ca_ee_report_lines pert,
5151: hr_lookups hl2,
5152: hr_soft_coding_keyflex hsck
5153: where

Line 5233: hr_locations hl1,

5229: per_jobs pj,
5230: per_assignments_f paf,
5231: per_people_f ppf,
5232: per_person_types ppt,
5233: hr_locations hl1,
5234: per_ca_ee_report_lines pert,
5235: hr_lookups hl2,
5236: hr_soft_coding_keyflex hsck
5237: where

Line 5312: v_province hr_locations.region_1%TYPE;

5308: v_count number(10);
5309: v_meaning hr_lookups.meaning%TYPE;
5310: v_employment_category per_assignments_f.employment_category%TYPE;
5311: v_sex per_people_f.sex%TYPE;
5312: v_province hr_locations.region_1%TYPE;
5313: prev_meaning hr_lookups.meaning%TYPE := 'test';
5314: prev_employment_category per_assignments_f.employment_category%TYPE := 'test';
5315: prev_sex per_people_f.sex%TYPE := 'test';
5316: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 5350: hr_locations hl1,

5346: per_jobs pj,
5347: per_assignments_f paf,
5348: per_people_f ppf,
5349: per_person_types ppt,
5350: hr_locations hl1,
5351: per_ca_ee_report_lines pert,
5352: hr_lookups hl2,
5353: hr_soft_coding_keyflex hsck
5354: where

Line 5436: hr_locations hl1,

5432: per_jobs pj,
5433: per_assignments_f paf,
5434: per_people_f ppf,
5435: per_person_types ppt,
5436: hr_locations hl1,
5437: per_ca_ee_report_lines pert,
5438: hr_lookups hl2,
5439: hr_soft_coding_keyflex hsck
5440: where

Line 5589: hr_locations hl1,

5585: per_jobs pj,
5586: per_assignments_f paf,
5587: per_people_f ppf,
5588: per_person_types ppt,
5589: hr_locations hl1,
5590: per_ca_ee_report_lines pert,
5591: hr_lookups hl2,
5592: hr_soft_coding_keyflex hsck,
5593: per_pay_proposals_v2 pppv

Line 5667: hr_locations hl1,

5663: per_jobs pj,
5664: per_assignments_f paf,
5665: per_people_f ppf,
5666: per_person_types ppt,
5667: hr_locations hl1,
5668: per_ca_ee_report_lines pert,
5669: hr_lookups hl2,
5670: hr_soft_coding_keyflex hsck,
5671: per_pay_proposals_v2 pppv

Line 5757: hr_locations hl1,

5753: per_jobs pj,
5754: per_assignments_f paf,
5755: per_people_f ppf,
5756: per_person_types ppt,
5757: hr_locations hl1,
5758: per_ca_ee_report_lines pert,
5759: hr_lookups hl2,
5760: hr_soft_coding_keyflex hsck,
5761: per_pay_proposals_v2 pppv

Line 5835: hr_locations hl1,

5831: per_jobs pj,
5832: per_assignments_f paf,
5833: per_people_f ppf,
5834: per_person_types ppt,
5835: hr_locations hl1,
5836: per_ca_ee_report_lines pert,
5837: hr_lookups hl2,
5838: hr_soft_coding_keyflex hsck,
5839: per_pay_proposals_v2 pppv

Line 5924: hr_locations hl1,

5920: per_jobs pj,
5921: per_assignments_f paf,
5922: per_people_f ppf,
5923: per_person_types ppt,
5924: hr_locations hl1,
5925: per_ca_ee_report_lines pert,
5926: hr_lookups hl2,
5927: hr_soft_coding_keyflex hsck,
5928: per_pay_proposals_v2 pppv

Line 6005: hr_locations hl1,

6001: per_jobs pj,
6002: per_assignments_f paf,
6003: per_people_f ppf,
6004: per_person_types ppt,
6005: hr_locations hl1,
6006: per_ca_ee_report_lines pert,
6007: hr_lookups hl2,
6008: hr_soft_coding_keyflex hsck,
6009: per_pay_proposals_v2 pppv

Line 6855: hr_locations hl1,

6851: hl1.region_1 province
6852: from
6853: per_assignments_f paf,
6854: per_people_f ppf,
6855: hr_locations hl1,
6856: per_ca_ee_report_lines pert,
6857: hr_lookups hl2,
6858: hr_soft_coding_keyflex hsck
6859: where job_exists(paf.job_id) is not null

Line 6939: hr_locations hl1,

6935: hl1.region_1 province
6936: from
6937: per_assignments_f paf,
6938: per_people_f ppf,
6939: hr_locations hl1,
6940: per_ca_ee_report_lines pert,
6941: hr_lookups hl2,
6942: hr_soft_coding_keyflex hsck
6943: where

Line 7019: v_province hr_locations.region_1%TYPE;

7015: v_count number(10);
7016: v_meaning hr_lookups.meaning%TYPE;
7017: v_employment_category per_assignments_f.employment_category%TYPE;
7018: v_sex per_people_f.sex%TYPE;
7019: v_province hr_locations.region_1%TYPE;
7020: prev_meaning hr_lookups.meaning%TYPE := 'test';
7021: prev_employment_category per_assignments_f.employment_category%TYPE := 'test';
7022: prev_sex per_people_f.sex%TYPE := 'test';
7023: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 7109: hr_locations hl1,

7105: hl1.region_1 province
7106: from
7107: per_assignments_f paf,
7108: per_people_f ppf,
7109: hr_locations hl1,
7110: per_ca_ee_report_lines pert,
7111: hr_lookups hl2,
7112: hr_soft_coding_keyflex hsck
7113: where

Line 7193: hr_locations hl1,

7189: hl1.region_1 province
7190: from
7191: per_assignments_f paf,
7192: per_people_f ppf,
7193: hr_locations hl1,
7194: per_ca_ee_report_lines pert,
7195: hr_lookups hl2,
7196: hr_soft_coding_keyflex hsck
7197: where

Line 8035: hr_locations hl1,

8031: per_assignments_f paf,
8032: per_people_f ppf,
8033: per_person_types ppt,
8034: per_periods_of_service ppos,
8035: hr_locations hl1,
8036: hr_soft_coding_keyflex hsck
8037: where
8038: hl.lookup_type='EEOG' and
8039: upper(ltrim(rtrim(hl.lookup_code)))

Line 8104: hr_locations hl1,

8100: per_assignments_f paf,
8101: per_people_f ppf,
8102: per_person_types ppt,
8103: per_periods_of_service ppos,
8104: hr_locations hl1,
8105: hr_soft_coding_keyflex hsck
8106: where
8107: hl.lookup_type='EEOG' and
8108: upper(ltrim(rtrim(hl.lookup_code)))

Line 8167: v_region_1 hr_locations.region_1%TYPE;

8163: v_count number(10);
8164: v_meaning hr_lookups.meaning%TYPE;
8165: v_employment_category per_assignments_f.employment_category%TYPE;
8166: v_sex per_people_f.sex%TYPE;
8167: v_region_1 hr_locations.region_1%TYPE;
8168: prev_meaning hr_lookups.meaning%TYPE := 'test';
8169: prev_employment_category per_assignments_f.employment_category%TYPE := '
8170: ';
8171: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 8173: prev_region_1 hr_locations.region_1%TYPE;

8169: prev_employment_category per_assignments_f.employment_category%TYPE := '
8170: ';
8171: prev_naic_code hr_lookups.lookup_code%TYPE;
8172: prev_sex per_people_f.sex%TYPE := '';
8173: prev_region_1 hr_locations.region_1%TYPE;
8174:
8175: cursor cur_hr_lookups is
8176: select
8177: meaning

Line 8208: hr_locations hl1,

8204: per_assignments_f paf,
8205: per_people_f ppf,
8206: per_person_types ppt,
8207: per_periods_of_service ppos ,
8208: hr_locations hl1,
8209: hr_soft_coding_keyflex hsck
8210: where
8211: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
8212: upper(ltrim(rtrim(hl.lookup_code)))

Line 8280: hr_locations hl1,

8276: per_assignments_f paf,
8277: per_people_f ppf,
8278: per_person_types ppt,
8279: per_periods_of_service ppos ,
8280: hr_locations hl1,
8281: hr_soft_coding_keyflex hsck
8282: where
8283: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
8284: upper(ltrim(rtrim(hl.lookup_code)))