[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,
2170: decode(CMA_PROVINCE_COUNT,1,hl1.region_1
2171: ,2,hl1.region_2) cma_province
2172: from
2173: hr_lookups hl,
2174: per_jobs pj,
2175: per_pay_proposals_v2 pppv,
2176: per_people_f ppf,
2177: per_assignments_f paf,
2178: hr_locations hl1,
2270: decode(cma_province_count,1,hl1.region_1
2271: ,2,hl1.region_2) cma_province
2272: from
2273: hr_lookups hl,
2274: per_jobs pj,
2275: per_pay_proposals_v2 pppv,
2276: per_people_f ppf,
2277: per_assignments_f paf,
2278: hr_locations hl1,
2406: count(distinct paf.person_id) count_total,
2407: ppf.sex --sex
2408: from
2409: hr_lookups hl,
2410: per_jobs pj,
2411: per_assignments_f paf,
2412: per_people_f ppf,
2413: per_pay_proposals_v2 pppv,
2414: hr_locations hl1,
2513: count(distinct paf.person_id) count,
2514: ppf.sex --sex
2515: from
2516: hr_lookups hl,
2517: per_jobs pj,
2518: per_assignments_f paf,
2519: per_people_f ppf,
2520: per_pay_proposals_v2 pppv,
2521: hr_locations hl1,
3241: substr(paf.employment_category,1,2) employment_category,
3242: ppf.sex sex,
3243: decode(cma_province_count,1,hl1.region_1,2,hl1.region_2) cma_province
3244: from
3245: per_jobs pj,
3246: per_assignments_f paf,
3247: per_people_f ppf,
3248: per_pay_proposals_v2 pppv,
3249: per_person_types ppt,
3321: 'FR' employment_category,
3322: ppf.sex sex,
3323: decode(cma_province_count,1,hl1.region_1,2,hl1.region_2) cma_province
3324: from
3325: per_jobs pj,
3326: per_assignments_f paf,
3327: per_people_f ppf,
3328: per_pay_proposals_v2 pppv,
3329: per_person_types ppt,
3433: substr(paf.employment_category,1,2) employment_category,
3434: ppf.sex sex,
3435: decode(cma_province_ct,1,hl1.region_1,2,hl1.region_2) cma_province
3436: from
3437: per_jobs pj,
3438: per_assignments_f paf,
3439: per_people_f ppf,
3440: per_pay_proposals_v2 pppv,
3441: per_person_types ppt,
3517: 'FR' employment_category,
3518: ppf.sex sex,
3519: decode(cma_province_ct,1,hl1.region_1,2,hl1.region_2) cma_province
3520: from
3521: per_jobs pj,
3522: per_assignments_f paf,
3523: per_people_f ppf,
3524: per_pay_proposals_v2 pppv,
3525: per_person_types ppt,
4363: substr(employment_category,1,2) employment_category,
4364: hl1.region_1 province
4365: from
4366: hr_lookups hl,
4367: per_jobs pj,
4368: per_assignments_f paf,
4369: per_people_f ppf,
4370: per_person_types ppt,
4371: hr_locations hl1,
4443: 'FR' employment_category,
4444: hl1.region_1 province
4445: from
4446: hr_lookups hl,
4447: per_jobs pj,
4448: per_assignments_f paf,
4449: per_people_f ppf,
4450: per_person_types ppt,
4451: hr_locations hl1,
4557: ppf.sex sex,
4558: hl1.region_1 province
4559: from
4560: hr_lookups hl,
4561: per_jobs pj,
4562: per_assignments_f paf,
4563: per_people_f ppf,
4564: per_person_types ppt,
4565: hr_locations hl1,
4657: ppf.sex sex,
4658: hl1.region_1 province
4659: from
4660: hr_lookups hl,
4661: per_jobs pj,
4662: per_assignments_f paf,
4663: per_people_f ppf,
4664: per_person_types ppt,
4665: hr_locations hl1,
5187: substr(paf.employment_category,1,2) employment_category,
5188: hl1.region_1 province
5189: from
5190: hr_lookups hl,
5191: per_jobs pj,
5192: per_assignments_f paf,
5193: per_people_f ppf,
5194: per_person_types ppt,
5195: hr_locations hl1,
5271: 'FR' employment_category,
5272: hl1.region_1 province
5273: from
5274: hr_lookups hl,
5275: per_jobs pj,
5276: per_assignments_f paf,
5277: per_people_f ppf,
5278: per_person_types ppt,
5279: hr_locations hl1,
5388: ppf.sex sex,
5389: hl1.region_1 province
5390: from
5391: hr_lookups hl,
5392: per_jobs pj,
5393: per_assignments_f paf,
5394: per_people_f ppf,
5395: per_person_types ppt,
5396: hr_locations hl1,
5474: ppf.sex sex,
5475: hl1.region_1 province
5476: from
5477: hr_lookups hl,
5478: per_jobs pj,
5479: per_assignments_f paf,
5480: per_people_f ppf,
5481: per_person_types ppt,
5482: hr_locations hl1,
5627: substr(paf.employment_category,1,2) employment_category,
5628: hl1.region_1 province
5629: from
5630: hr_lookups hl,
5631: per_jobs pj,
5632: per_assignments_f paf,
5633: per_people_f ppf,
5634: per_person_types ppt,
5635: hr_locations hl1,
5705: 'FR' employment_category,
5706: hl1.region_1 province
5707: from
5708: hr_lookups hl,
5709: per_jobs pj,
5710: per_assignments_f paf,
5711: per_people_f ppf,
5712: per_person_types ppt,
5713: hr_locations hl1,
5795: substr(paf.employment_category,1,2) employment_category,
5796: hl1.region_1 province
5797: from
5798: hr_lookups hl,
5799: per_jobs pj,
5800: per_assignments_f paf,
5801: per_people_f ppf,
5802: per_person_types ppt,
5803: hr_locations hl1,
5873: 'FR' employment_category,
5874: hl1.region_1 province
5875: from
5876: hr_lookups hl,
5877: per_jobs pj,
5878: per_assignments_f paf,
5879: per_people_f ppf,
5880: per_person_types ppt,
5881: hr_locations hl1,
5962: ppf.sex sex,
5963: hl1.region_1 province
5964: from
5965: hr_lookups hl,
5966: per_jobs pj,
5967: per_assignments_f paf,
5968: per_people_f ppf,
5969: per_person_types ppt,
5970: hr_locations hl1,
6043: ppf.sex sex,
6044: hl1.region_1 province
6045: from
6046: hr_lookups hl,
6047: per_jobs pj,
6048: per_assignments_f paf,
6049: per_people_f ppf,
6050: per_person_types ppt,
6051: hr_locations hl1,
6859:
6860: cursor cur_jobs is
6861: select job_id,
6862: meaning
6863: from per_jobs,
6864: hr_lookups
6865: where lookup_type = 'EEOG'
6866: and upper(ltrim(rtrim(lookup_code)))
6867: =upper(ltrim(rtrim(job_information1)))
7358: segment1 = 'PROVINCE' ;
7359:
7360: begin
7361:
7362: /* Caching data from per_jobs and per_person_types tables */
7363:
7364: open cur_jobs;
7365: fetch cur_jobs bulk collect into
7366: v_job_id_temp,
8072: substr(paf.employment_category,1,2) employment_category,
8073: hl1.region_1 region_1
8074: from
8075: hr_lookups hl,
8076: per_jobs pj,
8077: per_assignments_f paf,
8078: per_people_f ppf,
8079: per_person_types ppt,
8080: per_periods_of_service ppos,
8141: 'FR' employment_category,
8142: hl1.region_1 region_1
8143: from
8144: hr_lookups hl,
8145: per_jobs pj,
8146: per_assignments_f paf,
8147: per_people_f ppf,
8148: per_person_types ppt,
8149: per_periods_of_service ppos,
8245: ppf.sex sex,
8246: hl1.region_1 region_1
8247: from
8248: hr_lookups hl,
8249: per_jobs pj,
8250: per_assignments_f paf,
8251: per_people_f ppf,
8252: per_person_types ppt,
8253: per_periods_of_service ppos ,
8317: ppf.sex sex,
8318: hl1.region_1 region_1
8319: from
8320: hr_lookups hl,
8321: per_jobs pj,
8322: per_assignments_f paf,
8323: per_people_f ppf,
8324: per_person_types ppt,
8325: per_periods_of_service ppos ,