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.

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 2178: hr_locations hl1,

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

Line 2278: hr_locations hl1,

2274: per_jobs pj,
2275: per_pay_proposals_v2 pppv,
2276: per_people_f ppf,
2277: per_assignments_f paf,
2278: hr_locations hl1,
2279: per_person_types ppt,
2280: per_ca_ee_report_lines pert,
2281: hr_lookups hl2,
2282: hr_soft_coding_keyflex hsck,

Line 2373: v_cma_province hr_locations.region_1%TYPE;

2369: v_max_salary number;
2370: v_min_salary number;
2371: v_meaning hr_lookups.meaning%TYPE;
2372: v_employment_category per_assignments_f.employment_category%TYPE;
2373: v_cma_province hr_locations.region_1%TYPE;
2374:
2375: j_flag varchar2(1) := 'F';
2376:
2377: cursor cur_meaning(cp number) is

Line 2414: hr_locations hl1,

2410: per_jobs pj,
2411: per_assignments_f paf,
2412: per_people_f ppf,
2413: per_pay_proposals_v2 pppv,
2414: hr_locations hl1,
2415: per_person_types ppt,
2416: hr_soft_coding_keyflex hsck,
2417: per_pay_bases ppb
2418: where

Line 2505: prev_cma_province hr_locations.region_1%TYPE;

2501: v_sex per_people_f.sex%TYPE;
2502: prev_employment_category per_assignments_f.employment_category%TYPE;
2503: prev_sex per_people_f.sex%TYPE;
2504: prev_j number := 0;
2505: prev_cma_province hr_locations.region_1%TYPE;
2506: prev_naic_code hr_lookups.lookup_code%TYPE;
2507: prev_meaning hr_lookups.meaning%TYPE;
2508:
2509: cursor cur_count(range number,

Line 2521: hr_locations hl1,

2517: per_jobs pj,
2518: per_assignments_f paf,
2519: per_people_f ppf,
2520: per_pay_proposals_v2 pppv,
2521: hr_locations hl1,
2522: per_person_types ppt,
2523: hr_soft_coding_keyflex hsck,
2524: per_pay_bases ppb
2525: where

Line 3250: hr_locations hl1,

3246: per_assignments_f paf,
3247: per_people_f ppf,
3248: per_pay_proposals_v2 pppv,
3249: per_person_types ppt,
3250: hr_locations hl1,
3251: per_ca_ee_report_lines pert,
3252: hr_lookups hl2,
3253: hr_soft_coding_keyflex hsck,
3254: per_pay_bases ppb

Line 3330: hr_locations hl1,

3326: per_assignments_f paf,
3327: per_people_f ppf,
3328: per_pay_proposals_v2 pppv,
3329: per_person_types ppt,
3330: hr_locations hl1,
3331: per_ca_ee_report_lines pert,
3332: hr_lookups hl2,
3333: hr_soft_coding_keyflex hsck,
3334: per_pay_bases ppb

Line 3406: v_cma_province hr_locations.region_1%TYPE;

3402: v_employment_category per_assignments_f.employment_category%TYPE;
3403: prev_employment_category per_assignments_f.employment_category%TYPE;
3404: prev_sex per_people_f.sex%TYPE;
3405: prev_x number := 0;
3406: v_cma_province hr_locations.region_1%TYPE;
3407: prev_naic_code hr_lookups.lookup_code%TYPE;
3408:
3409:
3410: cursor cur_meaning(cp number) is

Line 3442: hr_locations hl1,

3438: per_assignments_f paf,
3439: per_people_f ppf,
3440: per_pay_proposals_v2 pppv,
3441: per_person_types ppt,
3442: hr_locations hl1,
3443: per_ca_ee_report_lines pert,
3444: hr_lookups hl2,
3445: hr_soft_coding_keyflex hsck,
3446: per_pay_bases ppb

Line 3526: hr_locations hl1,

3522: per_assignments_f paf,
3523: per_people_f ppf,
3524: per_pay_proposals_v2 pppv,
3525: per_person_types ppt,
3526: hr_locations hl1,
3527: per_ca_ee_report_lines pert,
3528: hr_lookups hl2,
3529: hr_soft_coding_keyflex hsck,
3530: per_pay_bases ppb

Line 4371: hr_locations hl1,

4367: per_jobs pj,
4368: per_assignments_f paf,
4369: per_people_f ppf,
4370: per_person_types ppt,
4371: hr_locations hl1,
4372: per_ca_ee_report_lines pert,
4373: hr_lookups hl2,
4374: hr_soft_coding_keyflex hsck
4375: where

Line 4451: hr_locations hl1,

4447: per_jobs pj,
4448: per_assignments_f paf,
4449: per_people_f ppf,
4450: per_person_types ppt,
4451: hr_locations hl1,
4452: per_ca_ee_report_lines pert,
4453: hr_lookups hl2,
4454: hr_soft_coding_keyflex hsck
4455: where

Line 4526: v_province hr_locations.region_1%TYPE;

4522: v_count number(10);
4523: v_meaning hr_lookups.meaning%TYPE;
4524: v_employment_category per_assignments_f.employment_category%TYPE;
4525: v_sex per_people_f.sex%TYPE;
4526: v_province hr_locations.region_1%TYPE;
4527: prev_meaning hr_lookups.meaning%TYPE := 'test';
4528: prev_employment_category per_assignments_f.employment_category%TYPE := 'test';
4529: prev_sex per_people_f.sex%TYPE := 'test';
4530: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 4565: hr_locations hl1,

4561: per_jobs pj,
4562: per_assignments_f paf,
4563: per_people_f ppf,
4564: per_person_types ppt,
4565: hr_locations hl1,
4566: per_ca_ee_report_lines pert,
4567: hr_lookups hl2,
4568: hr_soft_coding_keyflex hsck
4569: where

Line 4665: hr_locations hl1,

4661: per_jobs pj,
4662: per_assignments_f paf,
4663: per_people_f ppf,
4664: per_person_types ppt,
4665: hr_locations hl1,
4666: per_ca_ee_report_lines pert,
4667: hr_lookups hl2,
4668: hr_soft_coding_keyflex hsck
4669: where

Line 5195: hr_locations hl1,

5191: per_jobs pj,
5192: per_assignments_f paf,
5193: per_people_f ppf,
5194: per_person_types ppt,
5195: hr_locations hl1,
5196: per_ca_ee_report_lines pert,
5197: hr_lookups hl2,
5198: hr_soft_coding_keyflex hsck
5199: where

Line 5279: hr_locations hl1,

5275: per_jobs pj,
5276: per_assignments_f paf,
5277: per_people_f ppf,
5278: per_person_types ppt,
5279: hr_locations hl1,
5280: per_ca_ee_report_lines pert,
5281: hr_lookups hl2,
5282: hr_soft_coding_keyflex hsck
5283: where

Line 5358: v_province hr_locations.region_1%TYPE;

5354: v_count number(10);
5355: v_meaning hr_lookups.meaning%TYPE;
5356: v_employment_category per_assignments_f.employment_category%TYPE;
5357: v_sex per_people_f.sex%TYPE;
5358: v_province hr_locations.region_1%TYPE;
5359: prev_meaning hr_lookups.meaning%TYPE := 'test';
5360: prev_employment_category per_assignments_f.employment_category%TYPE := 'test';
5361: prev_sex per_people_f.sex%TYPE := 'test';
5362: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 5396: hr_locations hl1,

5392: per_jobs pj,
5393: per_assignments_f paf,
5394: per_people_f ppf,
5395: per_person_types ppt,
5396: hr_locations hl1,
5397: per_ca_ee_report_lines pert,
5398: hr_lookups hl2,
5399: hr_soft_coding_keyflex hsck
5400: where

Line 5482: hr_locations hl1,

5478: per_jobs pj,
5479: per_assignments_f paf,
5480: per_people_f ppf,
5481: per_person_types ppt,
5482: hr_locations hl1,
5483: per_ca_ee_report_lines pert,
5484: hr_lookups hl2,
5485: hr_soft_coding_keyflex hsck
5486: where

Line 5635: hr_locations hl1,

5631: per_jobs pj,
5632: per_assignments_f paf,
5633: per_people_f ppf,
5634: per_person_types ppt,
5635: hr_locations hl1,
5636: per_ca_ee_report_lines pert,
5637: hr_lookups hl2,
5638: hr_soft_coding_keyflex hsck,
5639: per_pay_proposals_v2 pppv

Line 5713: hr_locations hl1,

5709: per_jobs pj,
5710: per_assignments_f paf,
5711: per_people_f ppf,
5712: per_person_types ppt,
5713: hr_locations hl1,
5714: per_ca_ee_report_lines pert,
5715: hr_lookups hl2,
5716: hr_soft_coding_keyflex hsck,
5717: per_pay_proposals_v2 pppv

Line 5803: hr_locations hl1,

5799: per_jobs pj,
5800: per_assignments_f paf,
5801: per_people_f ppf,
5802: per_person_types ppt,
5803: hr_locations hl1,
5804: per_ca_ee_report_lines pert,
5805: hr_lookups hl2,
5806: hr_soft_coding_keyflex hsck,
5807: per_pay_proposals_v2 pppv

Line 5881: hr_locations hl1,

5877: per_jobs pj,
5878: per_assignments_f paf,
5879: per_people_f ppf,
5880: per_person_types ppt,
5881: hr_locations hl1,
5882: per_ca_ee_report_lines pert,
5883: hr_lookups hl2,
5884: hr_soft_coding_keyflex hsck,
5885: per_pay_proposals_v2 pppv

Line 5970: hr_locations hl1,

5966: per_jobs pj,
5967: per_assignments_f paf,
5968: per_people_f ppf,
5969: per_person_types ppt,
5970: hr_locations hl1,
5971: per_ca_ee_report_lines pert,
5972: hr_lookups hl2,
5973: hr_soft_coding_keyflex hsck,
5974: per_pay_proposals_v2 pppv

Line 6051: hr_locations hl1,

6047: per_jobs pj,
6048: per_assignments_f paf,
6049: per_people_f ppf,
6050: per_person_types ppt,
6051: hr_locations hl1,
6052: per_ca_ee_report_lines pert,
6053: hr_lookups hl2,
6054: hr_soft_coding_keyflex hsck,
6055: per_pay_proposals_v2 pppv

Line 6901: hr_locations hl1,

6897: hl1.region_1 province
6898: from
6899: per_assignments_f paf,
6900: per_people_f ppf,
6901: hr_locations hl1,
6902: per_ca_ee_report_lines pert,
6903: hr_lookups hl2,
6904: hr_soft_coding_keyflex hsck
6905: where job_exists(paf.job_id) is not null

Line 6985: hr_locations hl1,

6981: hl1.region_1 province
6982: from
6983: per_assignments_f paf,
6984: per_people_f ppf,
6985: hr_locations hl1,
6986: per_ca_ee_report_lines pert,
6987: hr_lookups hl2,
6988: hr_soft_coding_keyflex hsck
6989: where

Line 7065: v_province hr_locations.region_1%TYPE;

7061: v_count number(10);
7062: v_meaning hr_lookups.meaning%TYPE;
7063: v_employment_category per_assignments_f.employment_category%TYPE;
7064: v_sex per_people_f.sex%TYPE;
7065: v_province hr_locations.region_1%TYPE;
7066: prev_meaning hr_lookups.meaning%TYPE := 'test';
7067: prev_employment_category per_assignments_f.employment_category%TYPE := 'test';
7068: prev_sex per_people_f.sex%TYPE := 'test';
7069: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 7155: hr_locations hl1,

7151: hl1.region_1 province
7152: from
7153: per_assignments_f paf,
7154: per_people_f ppf,
7155: hr_locations hl1,
7156: per_ca_ee_report_lines pert,
7157: hr_lookups hl2,
7158: hr_soft_coding_keyflex hsck
7159: where

Line 7239: hr_locations hl1,

7235: hl1.region_1 province
7236: from
7237: per_assignments_f paf,
7238: per_people_f ppf,
7239: hr_locations hl1,
7240: per_ca_ee_report_lines pert,
7241: hr_lookups hl2,
7242: hr_soft_coding_keyflex hsck
7243: where

Line 8081: hr_locations hl1,

8077: per_assignments_f paf,
8078: per_people_f ppf,
8079: per_person_types ppt,
8080: per_periods_of_service ppos,
8081: hr_locations hl1,
8082: hr_soft_coding_keyflex hsck
8083: where
8084: hl.lookup_type='EEOG' and
8085: upper(ltrim(rtrim(hl.lookup_code)))

Line 8150: hr_locations hl1,

8146: per_assignments_f paf,
8147: per_people_f ppf,
8148: per_person_types ppt,
8149: per_periods_of_service ppos,
8150: hr_locations hl1,
8151: hr_soft_coding_keyflex hsck
8152: where
8153: hl.lookup_type='EEOG' and
8154: upper(ltrim(rtrim(hl.lookup_code)))

Line 8213: v_region_1 hr_locations.region_1%TYPE;

8209: v_count number(10);
8210: v_meaning hr_lookups.meaning%TYPE;
8211: v_employment_category per_assignments_f.employment_category%TYPE;
8212: v_sex per_people_f.sex%TYPE;
8213: v_region_1 hr_locations.region_1%TYPE;
8214: prev_meaning hr_lookups.meaning%TYPE := 'test';
8215: prev_employment_category per_assignments_f.employment_category%TYPE := '
8216: ';
8217: prev_naic_code hr_lookups.lookup_code%TYPE;

Line 8219: prev_region_1 hr_locations.region_1%TYPE;

8215: prev_employment_category per_assignments_f.employment_category%TYPE := '
8216: ';
8217: prev_naic_code hr_lookups.lookup_code%TYPE;
8218: prev_sex per_people_f.sex%TYPE := '';
8219: prev_region_1 hr_locations.region_1%TYPE;
8220:
8221: cursor cur_hr_lookups is
8222: select
8223: meaning

Line 8254: hr_locations hl1,

8250: per_assignments_f paf,
8251: per_people_f ppf,
8252: per_person_types ppt,
8253: per_periods_of_service ppos ,
8254: hr_locations hl1,
8255: hr_soft_coding_keyflex hsck
8256: where
8257: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
8258: upper(ltrim(rtrim(hl.lookup_code)))

Line 8326: hr_locations hl1,

8322: per_assignments_f paf,
8323: per_people_f ppf,
8324: per_person_types ppt,
8325: per_periods_of_service ppos ,
8326: hr_locations hl1,
8327: hr_soft_coding_keyflex hsck
8328: where
8329: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
8330: upper(ltrim(rtrim(hl.lookup_code)))