[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
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
2184: where
2185: hl.lookup_type='EEOG' and
2186: hl.lookup_code=pj.job_information1 and
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
2284: where
2285: hl.lookup_type='EEOG' and
2286: hl.lookup_code=pj.job_information1 and
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
2420: upper(ltrim(rtrim(hl.meaning)))=upper(ltrim(rtrim(v_meaning))) and
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
2527: upper(ltrim(rtrim(hl.meaning)))=upper(ltrim(rtrim(v_meaning))) and
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
3255: where
3256: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3257: pj.job_id=paf.job_id and
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
3335: where
3336: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3337: pj.job_id=paf.job_id and
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
3447: where
3448: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3449: pj.job_id=paf.job_id and
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
3531: where
3532: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
3533: pj.job_id=paf.job_id and
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
4376: hl.lookup_type='EEOG' and
4377: upper(ltrim(rtrim(hl.lookup_code)))
4378: = upper(ltrim(rtrim(pj.job_information1))) and
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
4456: hl.lookup_type='EEOG' and
4457: upper(ltrim(rtrim(hl.lookup_code)))
4458: =upper(ltrim(rtrim(pj.job_information1))) and
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
4570: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
4571: upper(ltrim(rtrim(hl.lookup_code)))=
4572: upper(ltrim(ltrim(pj.job_information1))) and
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
4670: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
4671: upper(ltrim(rtrim(hl.lookup_code)))
4672: = upper(ltrim(ltrim(pj.job_information1))) and
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
5200: hl.lookup_type='EEOG' and
5201: upper(ltrim(rtrim(hl.lookup_code)))
5202: =upper(ltrim(rtrim(pj.job_information1))) and
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
5284: hl.lookup_type='EEOG' and
5285: upper(ltrim(rtrim(hl.lookup_code)))
5286: =upper(ltrim(rtrim(pj.job_information1))) and
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
5401: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
5402: upper(ltrim(rtrim(hl.lookup_code)))=upper(ltrim(ltrim(pj.job_information1))) and
5403: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
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
5487: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
5488: upper(ltrim(rtrim(hl.lookup_code)))=upper(ltrim(ltrim(pj.job_information1))) and
5489: upper(ltrim(rtrim(pj.job_information_category))) = 'CA' and
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
5640: where
5641: hl.lookup_type='EEOG' and
5642: upper(ltrim(rtrim(hl.lookup_code)))
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
5718: where
5719: hl.lookup_type='EEOG' and
5720: upper(ltrim(rtrim(hl.lookup_code)))
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
5808: where
5809: hl.lookup_type='EEOG' and
5810: upper(ltrim(rtrim(hl.lookup_code)))
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
5886: where
5887: hl.lookup_type='EEOG' and
5888: upper(ltrim(rtrim(hl.lookup_code)))
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
5975: where
5976: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
5977: upper(ltrim(rtrim(hl.lookup_code)))
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
6056: where
6057: upper(ltrim(rtrim(hl.lookup_type)))='EEOG' and
6058: upper(ltrim(rtrim(hl.lookup_code)))
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
6906: and paf.primary_flag = 'Y'
6907: and paf.assignment_id =
6908: (select max(pafm.assignment_id) -- This select ensures that
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
6990: job_exists(paf.job_id) is not null
6991: and paf.primary_flag = 'Y'
6992: and paf.assignment_id =
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
7160: job_exists(paf.job_id) is not null
7161: and paf.primary_flag = 'Y'
7162: and paf.assignment_id =
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
7244: job_exists(paf.job_id) is not null
7245: and paf.primary_flag = 'Y'
7246: and paf.assignment_id =
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)))
8086: = upper(ltrim(rtrim(pj.job_information1))) and
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)))
8155: = upper(ltrim(rtrim(pj.job_information1))) and
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)))
8259: = upper(ltrim(ltrim(pj.job_information1))) and
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)))
8331: = upper(ltrim(ltrim(pj.job_information1))) and