[Home] [Help]
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
176: paf.effective_end_date
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
468: ppf.person_type_id = ppt.person_type_id and
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
555: ppf.person_type_id = ppt.person_type_id and
719: count(distinct paf.person_id) count_naic_person,
720: hl.lookup_code lcode
721: from
722: hr_lookups hl,
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,
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
1179: hl.lookup_code=pj.job_information1 and
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
1257: hl.lookup_code=pj.job_information1 and
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
1355: upper(ltrim(rtrim(hl.meaning)))=upper(ltrim(rtrim(v_meaning))) and
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
1455: upper(ltrim(rtrim(hl.meaning))) = upper(ltrim(rtrim(v_meaning))) and
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,
2181: per_pay_bases ppb
2182: where
2183: hl.lookup_type='EEOG' and
2184: hl.lookup_code=pj.job_information1 and
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,
2278: per_pay_bases ppb
2279: where
2280: hl.lookup_type='EEOG' and
2281: hl.lookup_code=pj.job_information1 and
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
2407: hl.lookup_type='EEOG' and
2408: upper(ltrim(rtrim(hl.meaning)))=upper(ltrim(rtrim(v_meaning))) and
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
2514: hl.lookup_type='EEOG' and
2515: upper(ltrim(rtrim(hl.meaning)))=upper(ltrim(rtrim(v_meaning))) and
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
3243: where
3244: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3245: pj.job_id=paf.job_id and
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
3323: where
3324: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3325: pj.job_id=paf.job_id and
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
3435: where
3436: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3437: pj.job_id=paf.job_id and
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
3519: where
3520: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3521: pj.job_id=paf.job_id and
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
4364: hl.lookup_type='EEOG' and
4365: upper(ltrim(rtrim(hl.lookup_code)))
4366: = upper(ltrim(rtrim(pj.job_information1))) and
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
4444: hl.lookup_type='EEOG' and
4445: upper(ltrim(rtrim(hl.lookup_code)))
4446: =upper(ltrim(rtrim(pj.job_information1))) and
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
4558: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
4559: upper(ltrim(rtrim(hl.lookup_code)))=
4560: upper(ltrim(ltrim(pj.job_information1))) and
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
4641: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
4642: upper(ltrim(rtrim(hl.lookup_code)))
4643: = upper(ltrim(ltrim(pj.job_information1))) and
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
5154: hl.lookup_type='EEOG' and
5155: upper(ltrim(rtrim(hl.lookup_code)))
5156: =upper(ltrim(rtrim(pj.job_information1))) and
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
5238: hl.lookup_type='EEOG' and
5239: upper(ltrim(rtrim(hl.lookup_code)))
5240: =upper(ltrim(rtrim(pj.job_information1))) and
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
5355: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
5356: upper(ltrim(rtrim(hl.lookup_code)))=upper(ltrim(ltrim(pj.job_information1))) and
5357: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
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
5441: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
5442: upper(ltrim(rtrim(hl.lookup_code)))=upper(ltrim(ltrim(pj.job_information1))) and
5443: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
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
5594: where
5595: hl.lookup_type='EEOG' and
5596: upper(ltrim(rtrim(hl.lookup_code)))
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
5672: where
5673: hl.lookup_type='EEOG' and
5674: upper(ltrim(rtrim(hl.lookup_code)))
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
5762: where
5763: hl.lookup_type='EEOG' and
5764: upper(ltrim(rtrim(hl.lookup_code)))
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
5840: where
5841: hl.lookup_type='EEOG' and
5842: upper(ltrim(rtrim(hl.lookup_code)))
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
5929: where
5930: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
5931: upper(ltrim(rtrim(hl.lookup_code)))
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
6010: where
6011: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
6012: upper(ltrim(rtrim(hl.lookup_code)))
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
6860: and paf.primary_flag = 'Y'
6861: and paf.assignment_id =
6862: (select max(pafm.assignment_id) -- This select ensures that
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
6944: job_exists(paf.job_id) is not null
6945: and paf.primary_flag = 'Y'
6946: and paf.assignment_id =
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
7114: job_exists(paf.job_id) is not null
7115: and paf.primary_flag = 'Y'
7116: and paf.assignment_id =
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
7198: job_exists(paf.job_id) is not null
7199: and paf.primary_flag = 'Y'
7200: and paf.assignment_id =
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)))
8040: = upper(ltrim(rtrim(pj.job_information1))) and
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)))
8109: = upper(ltrim(rtrim(pj.job_information1))) and
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)))
8213: = upper(ltrim(ltrim(pj.job_information1))) and
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)))
8285: = upper(ltrim(ltrim(pj.job_information1))) and