[Home] [Help]
166: hsck.segment1,
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
459: substr(paf.employment_category,1,2) employment_category
460: from
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
546: 'FR' employment_category
547: from
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
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,
646: hr_lookups hl2
647: where
648: upper(ltrim(rtrim(hl1.lookup_type)))=decode(pc,1,'CA_PROVINCE',
723: hr_soft_coding_keyflex hsck ,
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: (
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,
1175: hr_soft_coding_keyflex hsck,
1176: per_pay_bases ppb
1177: where
1178: hl.lookup_type='EEOG' and
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,
1253: hr_soft_coding_keyflex hsck,
1254: per_pay_bases ppb
1255: where
1256: hl.lookup_type='EEOG' and
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,
1351: hr_soft_coding_keyflex hsck,
1352: per_pay_bases ppb
1353: where
1354: hl.lookup_type='EEOG' and
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,
1451: hr_soft_coding_keyflex hsck,
1452: per_pay_bases ppb
1453: where
1454: hl.lookup_type='EEOG' and
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,
2183: per_pay_bases ppb
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,
2283: per_pay_bases ppb
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
2419: hl.lookup_type='EEOG' and
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
2526: hl.lookup_type='EEOG' and
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,
3250: hr_locations hl1,
3251: per_ca_ee_report_lines pert,
3252: hr_lookups hl2,
3253: hr_soft_coding_keyflex hsck,
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,
3330: hr_locations hl1,
3331: per_ca_ee_report_lines pert,
3332: hr_lookups hl2,
3333: hr_soft_coding_keyflex hsck,
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,
3442: hr_locations hl1,
3443: per_ca_ee_report_lines pert,
3444: hr_lookups hl2,
3445: hr_soft_coding_keyflex hsck,
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,
3526: hr_locations hl1,
3527: per_ca_ee_report_lines pert,
3528: hr_lookups hl2,
3529: hr_soft_coding_keyflex hsck,
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,
4372: per_ca_ee_report_lines pert,
4373: hr_lookups hl2,
4374: hr_soft_coding_keyflex hsck
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,
4452: per_ca_ee_report_lines pert,
4453: hr_lookups hl2,
4454: hr_soft_coding_keyflex hsck
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,
4566: per_ca_ee_report_lines pert,
4567: hr_lookups hl2,
4568: hr_soft_coding_keyflex hsck
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,
4666: per_ca_ee_report_lines pert,
4667: hr_lookups hl2,
4668: hr_soft_coding_keyflex hsck
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,
5196: per_ca_ee_report_lines pert,
5197: hr_lookups hl2,
5198: hr_soft_coding_keyflex hsck
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,
5280: per_ca_ee_report_lines pert,
5281: hr_lookups hl2,
5282: hr_soft_coding_keyflex hsck
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,
5397: per_ca_ee_report_lines pert,
5398: hr_lookups hl2,
5399: hr_soft_coding_keyflex hsck
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,
5483: per_ca_ee_report_lines pert,
5484: hr_lookups hl2,
5485: hr_soft_coding_keyflex hsck
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,
5636: per_ca_ee_report_lines pert,
5637: hr_lookups hl2,
5638: hr_soft_coding_keyflex hsck,
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,
5714: per_ca_ee_report_lines pert,
5715: hr_lookups hl2,
5716: hr_soft_coding_keyflex hsck,
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,
5804: per_ca_ee_report_lines pert,
5805: hr_lookups hl2,
5806: hr_soft_coding_keyflex hsck,
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,
5882: per_ca_ee_report_lines pert,
5883: hr_lookups hl2,
5884: hr_soft_coding_keyflex hsck,
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,
5971: per_ca_ee_report_lines pert,
5972: hr_lookups hl2,
5973: hr_soft_coding_keyflex hsck,
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,
6052: per_ca_ee_report_lines pert,
6053: hr_lookups hl2,
6054: hr_soft_coding_keyflex hsck,
6870:
6871:
6872: cursor cur_person_types is
6873: select person_type_id
6874: from per_person_types
6875: where upper(ltrim(rtrim(system_person_type)))='EMP'
6876: and business_group_id = p_business_group_id;
6877:
6878: cursor cur_promoted_total(desig number) is
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,
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,
8081: hr_locations hl1,
8082: hr_soft_coding_keyflex hsck
8083: where
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,
8150: hr_locations hl1,
8151: hr_soft_coding_keyflex hsck
8152: where
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 ,
8254: hr_locations hl1,
8255: hr_soft_coding_keyflex hsck
8256: where
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 ,
8326: hr_locations hl1,
8327: hr_soft_coding_keyflex hsck
8328: where