[Home] [Help]
167: hsck.segment6
168: FROM per_assignments_f paf,
169: per_people_f ppf,
170: per_person_types ppt,
171: per_jobs pj,
172: hr_soft_coding_keyflex hsck
173: WHERE
174: p_date_all_emp BETWEEN
175: paf.effective_start_date AND
461: per_people_f ppf,
462: per_assignments_f paf,
463: per_person_types ppt,
464: hr_soft_coding_keyflex hsck,
465: per_jobs pj,
466: hr_lookups hl
467: where
468: ppf.person_type_id = ppt.person_type_id and
469: upper(ltrim(rtrim(ppt.system_person_type)))='EMP' and
548: per_people_f ppf,
549: per_assignments_f paf,
550: per_person_types ppt,
551: hr_soft_coding_keyflex hsck,
552: per_jobs pj,
553: hr_lookups hl
554: where
555: ppf.person_type_id = ppt.person_type_id and
556: upper(ltrim(rtrim(ppt.system_person_type)))='EMP' and
641: hr_locations hl,
642: hr_lookups hl1,
643: per_people_f ppf ,
644: per_person_types ppt,
645: per_jobs pj,
646: hr_lookups hl2
647: where
648: upper(ltrim(rtrim(hl1.lookup_type)))=decode(pc,1,'CA_PROVINCE',
649: 2,'CA_CMA')and
724: hr_organization_information hoi,
725: per_assignments_f paf,
726: per_people_f ppf,
727: per_person_types ppt,
728: per_jobs pj,
729: hr_lookups hl1
730: where
731: (
732: (
1166: hl.meaning meaning,
1167: substr(paf.employment_category,1,2) employment_category
1168: from
1169: hr_lookups hl,
1170: per_jobs pj,
1171: per_pay_proposals_v2 pppv,
1172: per_people_f ppf,
1173: per_assignments_f paf,
1174: per_person_types ppt,
1244: hl.meaning meaning,
1245: 'FR' employment_category
1246: from
1247: hr_lookups hl,
1248: per_jobs pj,
1249: per_pay_proposals_v2 pppv,
1250: per_people_f ppf,
1251: per_assignments_f paf,
1252: per_person_types ppt,
1342: count(distinct paf.person_id) count_total,
1343: ppf.sex
1344: from
1345: hr_lookups hl,
1346: per_jobs pj,
1347: per_assignments_f paf,
1348: per_people_f ppf,
1349: per_pay_proposals_v2 pppv,
1350: per_person_types ppt,
1442: count(distinct paf.person_id) count,
1443: ppf.sex
1444: from
1445: hr_lookups hl,
1446: per_jobs pj,
1447: per_assignments_f paf,
1448: per_people_f ppf,
1449: per_pay_proposals_v2 pppv,
1450: per_person_types ppt,
2168: decode(cma_province_count,1,hl1.region_1
2169: ,2,hl1.region_2) cma_province
2170: from
2171: hr_lookups hl,
2172: per_jobs pj,
2173: per_pay_proposals_v2 pppv,
2174: per_people_f ppf,
2175: per_assignments_f paf,
2176: hr_locations hl1,
2265: decode(cma_province_count,1,hl1.region_1
2266: ,2,hl1.region_2) cma_province
2267: from
2268: hr_lookups hl,
2269: per_jobs pj,
2270: per_pay_proposals_v2 pppv,
2271: per_people_f ppf,
2272: per_assignments_f paf,
2273: hr_locations hl1,
2394: count(distinct paf.person_id) count_total,
2395: ppf.sex --sex
2396: from
2397: hr_lookups hl,
2398: per_jobs pj,
2399: per_assignments_f paf,
2400: per_people_f ppf,
2401: per_pay_proposals_v2 pppv,
2402: hr_locations hl1,
2501: count(distinct paf.person_id) count,
2502: ppf.sex --sex
2503: from
2504: hr_lookups hl,
2505: per_jobs pj,
2506: per_assignments_f paf,
2507: per_people_f ppf,
2508: per_pay_proposals_v2 pppv,
2509: hr_locations hl1,
3229: substr(paf.employment_category,1,2) employment_category,
3230: ppf.sex sex,
3231: decode(cma_province_count,1,hl1.region_1,2,hl1.region_2) cma_province
3232: from
3233: per_jobs pj,
3234: per_assignments_f paf,
3235: per_people_f ppf,
3236: per_pay_proposals_v2 pppv,
3237: per_person_types ppt,
3309: 'FR' employment_category,
3310: ppf.sex sex,
3311: decode(cma_province_count,1,hl1.region_1,2,hl1.region_2) cma_province
3312: from
3313: per_jobs pj,
3314: per_assignments_f paf,
3315: per_people_f ppf,
3316: per_pay_proposals_v2 pppv,
3317: per_person_types ppt,
3421: substr(paf.employment_category,1,2) employment_category,
3422: ppf.sex sex,
3423: decode(cma_province_ct,1,hl1.region_1,2,hl1.region_2) cma_province
3424: from
3425: per_jobs pj,
3426: per_assignments_f paf,
3427: per_people_f ppf,
3428: per_pay_proposals_v2 pppv,
3429: per_person_types ppt,
3505: 'FR' employment_category,
3506: ppf.sex sex,
3507: decode(cma_province_ct,1,hl1.region_1,2,hl1.region_2) cma_province
3508: from
3509: per_jobs pj,
3510: per_assignments_f paf,
3511: per_people_f ppf,
3512: per_pay_proposals_v2 pppv,
3513: per_person_types ppt,
4351: substr(employment_category,1,2) employment_category,
4352: hl1.region_1 province
4353: from
4354: hr_lookups hl,
4355: per_jobs pj,
4356: per_assignments_f paf,
4357: per_people_f ppf,
4358: per_person_types ppt,
4359: hr_locations hl1,
4431: 'FR' employment_category,
4432: hl1.region_1 province
4433: from
4434: hr_lookups hl,
4435: per_jobs pj,
4436: per_assignments_f paf,
4437: per_people_f ppf,
4438: per_person_types ppt,
4439: hr_locations hl1,
4545: ppf.sex sex,
4546: hl1.region_1 province
4547: from
4548: hr_lookups hl,
4549: per_jobs pj,
4550: per_assignments_f paf,
4551: per_people_f ppf,
4552: per_person_types ppt,
4553: hr_locations hl1,
4628: ppf.sex sex,
4629: hl1.region_1 province
4630: from
4631: hr_lookups hl,
4632: per_jobs pj,
4633: per_assignments_f paf,
4634: per_people_f ppf,
4635: per_person_types ppt,
4636: hr_locations hl1,
5141: substr(paf.employment_category,1,2) employment_category,
5142: hl1.region_1 province
5143: from
5144: hr_lookups hl,
5145: per_jobs pj,
5146: per_assignments_f paf,
5147: per_people_f ppf,
5148: per_person_types ppt,
5149: hr_locations hl1,
5225: 'FR' employment_category,
5226: hl1.region_1 province
5227: from
5228: hr_lookups hl,
5229: per_jobs pj,
5230: per_assignments_f paf,
5231: per_people_f ppf,
5232: per_person_types ppt,
5233: hr_locations hl1,
5342: ppf.sex sex,
5343: hl1.region_1 province
5344: from
5345: hr_lookups hl,
5346: per_jobs pj,
5347: per_assignments_f paf,
5348: per_people_f ppf,
5349: per_person_types ppt,
5350: hr_locations hl1,
5428: ppf.sex sex,
5429: hl1.region_1 province
5430: from
5431: hr_lookups hl,
5432: per_jobs pj,
5433: per_assignments_f paf,
5434: per_people_f ppf,
5435: per_person_types ppt,
5436: hr_locations hl1,
5581: substr(paf.employment_category,1,2) employment_category,
5582: hl1.region_1 province
5583: from
5584: hr_lookups hl,
5585: per_jobs pj,
5586: per_assignments_f paf,
5587: per_people_f ppf,
5588: per_person_types ppt,
5589: hr_locations hl1,
5659: 'FR' employment_category,
5660: hl1.region_1 province
5661: from
5662: hr_lookups hl,
5663: per_jobs pj,
5664: per_assignments_f paf,
5665: per_people_f ppf,
5666: per_person_types ppt,
5667: hr_locations hl1,
5749: substr(paf.employment_category,1,2) employment_category,
5750: hl1.region_1 province
5751: from
5752: hr_lookups hl,
5753: per_jobs pj,
5754: per_assignments_f paf,
5755: per_people_f ppf,
5756: per_person_types ppt,
5757: hr_locations hl1,
5827: 'FR' employment_category,
5828: hl1.region_1 province
5829: from
5830: hr_lookups hl,
5831: per_jobs pj,
5832: per_assignments_f paf,
5833: per_people_f ppf,
5834: per_person_types ppt,
5835: hr_locations hl1,
5916: ppf.sex sex,
5917: hl1.region_1 province
5918: from
5919: hr_lookups hl,
5920: per_jobs pj,
5921: per_assignments_f paf,
5922: per_people_f ppf,
5923: per_person_types ppt,
5924: hr_locations hl1,
5997: ppf.sex sex,
5998: hl1.region_1 province
5999: from
6000: hr_lookups hl,
6001: per_jobs pj,
6002: per_assignments_f paf,
6003: per_people_f ppf,
6004: per_person_types ppt,
6005: hr_locations hl1,
6813:
6814: cursor cur_jobs is
6815: select job_id,
6816: meaning
6817: from per_jobs,
6818: hr_lookups
6819: where lookup_type = 'EEOG'
6820: and upper(ltrim(rtrim(lookup_code)))
6821: =upper(ltrim(rtrim(job_information1)))
7312: segment1 = 'PROVINCE' ;
7313:
7314: begin
7315:
7316: /* Caching data from per_jobs and per_person_types tables */
7317:
7318: open cur_jobs;
7319: fetch cur_jobs bulk collect into
7320: v_job_id_temp,
8026: substr(paf.employment_category,1,2) employment_category,
8027: hl1.region_1 region_1
8028: from
8029: hr_lookups hl,
8030: per_jobs pj,
8031: per_assignments_f paf,
8032: per_people_f ppf,
8033: per_person_types ppt,
8034: per_periods_of_service ppos,
8095: 'FR' employment_category,
8096: hl1.region_1 region_1
8097: from
8098: hr_lookups hl,
8099: per_jobs pj,
8100: per_assignments_f paf,
8101: per_people_f ppf,
8102: per_person_types ppt,
8103: per_periods_of_service ppos,
8199: ppf.sex sex,
8200: hl1.region_1 region_1
8201: from
8202: hr_lookups hl,
8203: per_jobs pj,
8204: per_assignments_f paf,
8205: per_people_f ppf,
8206: per_person_types ppt,
8207: per_periods_of_service ppos ,
8271: ppf.sex sex,
8272: hl1.region_1 region_1
8273: from
8274: hr_lookups hl,
8275: per_jobs pj,
8276: per_assignments_f paf,
8277: per_people_f ppf,
8278: per_person_types ppt,
8279: per_periods_of_service ppos ,