305: AND ((p_basis_type = 'OTHER'
306: AND asg.pay_basis_id IS NULL)
307: OR (p_basis_type = 'HOURLY'
308: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
309: FROM per_pay_bases pyb
310: WHERE pyb.pay_basis = 'HOURLY'))
311: OR (p_basis_type = 'SALARIED'
312: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
313: FROM per_pay_bases pyb
309: FROM per_pay_bases pyb
310: WHERE pyb.pay_basis = 'HOURLY'))
311: OR (p_basis_type = 'SALARIED'
312: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
313: FROM per_pay_bases pyb
314: WHERE pyb.pay_basis IN
315: ('ANNUAL','MONTHLY','PERIOD')))
316: OR (p_basis_type IS NULL))
317: AND asa.assignment_id = asg.assignment_id
347: AND ((p_basis_type = 'OTHER'
348: AND asg.pay_basis_id IS NULL)
349: OR (p_basis_type = 'HOURLY'
350: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
351: FROM per_pay_bases pyb
352: WHERE pyb.pay_basis = 'HOURLY'))
353: OR (p_basis_type = 'SALARIED'
354: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
355: FROM per_pay_bases pyb
351: FROM per_pay_bases pyb
352: WHERE pyb.pay_basis = 'HOURLY'))
353: OR (p_basis_type = 'SALARIED'
354: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
355: FROM per_pay_bases pyb
356: WHERE pyb.pay_basis IN
357: ('ANNUAL','MONTHLY','PERIOD')))
358: OR (p_basis_type IS NULL));
359:
392: AND ((p_basis_type = 'OTHER'
393: AND asg.pay_basis_id IS NULL)
394: OR (p_basis_type = 'HOURLY'
395: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
396: FROM per_pay_bases pyb
397: WHERE pyb.pay_basis = 'HOURLY'))
398: OR (p_basis_type = 'SALARIED'
399: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
400: FROM per_pay_bases pyb
396: FROM per_pay_bases pyb
397: WHERE pyb.pay_basis = 'HOURLY'))
398: OR (p_basis_type = 'SALARIED'
399: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
400: FROM per_pay_bases pyb
401: WHERE pyb.pay_basis IN
402: ('ANNUAL','MONTHLY','PERIOD')))
403: OR (p_basis_type IS NULL));
404:
438: AND ((p_basis_type = 'OTHER'
439: AND asg.pay_basis_id IS NULL)
440: OR (p_basis_type = 'HOURLY'
441: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
442: FROM per_pay_bases pyb
443: WHERE pyb.pay_basis = 'HOURLY'))
444: OR (p_basis_type = 'SALARIED'
445: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
446: FROM per_pay_bases pyb
442: FROM per_pay_bases pyb
443: WHERE pyb.pay_basis = 'HOURLY'))
444: OR (p_basis_type = 'SALARIED'
445: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
446: FROM per_pay_bases pyb
447: WHERE pyb.pay_basis IN
448: ('ANNUAL','MONTHLY','PERIOD')))
449: OR (p_basis_type IS NULL));
450:
621: AND ((p_basis_type = 'OTHER'
622: AND asg.pay_basis_id IS NULL)
623: OR (p_basis_type = 'HOURLY'
624: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
625: FROM per_pay_bases pyb
626: WHERE pyb.pay_basis = 'HOURLY'))
627: OR (p_basis_type = 'SALARIED'
628: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
629: FROM per_pay_bases pyb
625: FROM per_pay_bases pyb
626: WHERE pyb.pay_basis = 'HOURLY'))
627: OR (p_basis_type = 'SALARIED'
628: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
629: FROM per_pay_bases pyb
630: WHERE pyb.pay_basis IN
631: ('ANNUAL','MONTHLY','PERIOD')))
632: OR (p_basis_type IS NULL))
633: AND prb.assignment_id = asg.assignment_id
661: AND ((p_basis_type = 'OTHER'
662: AND asg.pay_basis_id IS NULL)
663: OR (p_basis_type = 'HOURLY'
664: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
665: FROM per_pay_bases pyb
666: WHERE pyb.pay_basis = 'HOURLY'))
667: OR (p_basis_type = 'SALARIED'
668: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
669: FROM per_pay_bases pyb
665: FROM per_pay_bases pyb
666: WHERE pyb.pay_basis = 'HOURLY'))
667: OR (p_basis_type = 'SALARIED'
668: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
669: FROM per_pay_bases pyb
670: WHERE pyb.pay_basis IN
671: ('ANNUAL','MONTHLY','PERIOD')))
672: OR (p_basis_type IS NULL));
673:
705: AND ((p_basis_type = 'OTHER'
706: AND asg.pay_basis_id IS NULL)
707: OR (p_basis_type = 'HOURLY'
708: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
709: FROM per_pay_bases pyb
710: WHERE pyb.pay_basis = 'HOURLY'))
711: OR (p_basis_type = 'SALARIED'
712: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
713: FROM per_pay_bases pyb
709: FROM per_pay_bases pyb
710: WHERE pyb.pay_basis = 'HOURLY'))
711: OR (p_basis_type = 'SALARIED'
712: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
713: FROM per_pay_bases pyb
714: WHERE pyb.pay_basis IN
715: ('ANNUAL','MONTHLY','PERIOD')))
716: OR (p_basis_type IS NULL));
717:
753: AND ((p_basis_type = 'OTHER'
754: AND asg.pay_basis_id IS NULL)
755: OR (p_basis_type = 'HOURLY'
756: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
757: FROM per_pay_bases pyb
758: WHERE pyb.pay_basis = 'HOURLY'))
759: OR (p_basis_type = 'SALARIED'
760: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
761: FROM per_pay_bases pyb
757: FROM per_pay_bases pyb
758: WHERE pyb.pay_basis = 'HOURLY'))
759: OR (p_basis_type = 'SALARIED'
760: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
761: FROM per_pay_bases pyb
762: WHERE pyb.pay_basis IN
763: ('ANNUAL','MONTHLY','PERIOD')))
764: OR (p_basis_type IS NULL));
765:
1060: AND ((p_basis_type = 'OTHER'
1061: AND asg.pay_basis_id IS NULL)
1062: OR (p_basis_type = 'HOURLY'
1063: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1064: FROM per_pay_bases pyb
1065: WHERE pyb.pay_basis = 'HOURLY'))
1066: OR (p_basis_type = 'SALARIED'
1067: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1068: FROM per_pay_bases pyb
1064: FROM per_pay_bases pyb
1065: WHERE pyb.pay_basis = 'HOURLY'))
1066: OR (p_basis_type = 'SALARIED'
1067: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1068: FROM per_pay_bases pyb
1069: WHERE pyb.pay_basis IN
1070: ('ANNUAL','MONTHLY','PERIOD')))
1071: OR (p_basis_type IS NULL))
1072: AND EXISTS (SELECT 'X'
1106: AND ((p_basis_type = 'OTHER'
1107: AND asg.pay_basis_id IS NULL)
1108: OR (p_basis_type = 'HOURLY'
1109: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1110: FROM per_pay_bases pyb
1111: WHERE pyb.pay_basis = 'HOURLY'))
1112: OR (p_basis_type = 'SALARIED'
1113: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1114: FROM per_pay_bases pyb
1110: FROM per_pay_bases pyb
1111: WHERE pyb.pay_basis = 'HOURLY'))
1112: OR (p_basis_type = 'SALARIED'
1113: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1114: FROM per_pay_bases pyb
1115: WHERE pyb.pay_basis IN
1116: ('ANNUAL','MONTHLY','PERIOD')))
1117: OR (p_basis_type IS NULL));
1118:
1152: AND ((p_basis_type = 'OTHER'
1153: AND asg.pay_basis_id IS NULL)
1154: OR (p_basis_type = 'HOURLY'
1155: AND asg.pay_basis_id+0 IN (SELECT pyb.pay_basis_id
1156: FROM per_pay_bases pyb
1157: WHERE pyb.pay_basis = 'HOURLY'))
1158: OR (p_basis_type = 'SALARIED'
1159: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1160: FROM per_pay_bases pyb
1156: FROM per_pay_bases pyb
1157: WHERE pyb.pay_basis = 'HOURLY'))
1158: OR (p_basis_type = 'SALARIED'
1159: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1160: FROM per_pay_bases pyb
1161: WHERE pyb.pay_basis IN
1162: ('ANNUAL','MONTHLY','PERIOD')))
1163: OR (p_basis_type IS NULL));
1164:
1199: AND ((p_basis_type = 'OTHER'
1200: AND asg.pay_basis_id IS NULL)
1201: OR (p_basis_type = 'HOURLY'
1202: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1203: FROM per_pay_bases pyb
1204: WHERE pyb.pay_basis = 'HOURLY'))
1205: OR (p_basis_type = 'SALARIED'
1206: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1207: FROM per_pay_bases pyb
1203: FROM per_pay_bases pyb
1204: WHERE pyb.pay_basis = 'HOURLY'))
1205: OR (p_basis_type = 'SALARIED'
1206: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1207: FROM per_pay_bases pyb
1208: WHERE pyb.pay_basis IN
1209: ('ANNUAL','MONTHLY','PERIOD')))
1210: OR (p_basis_type IS NULL));
1211:
1603: AND ((p_basis_type = 'OTHER'
1604: AND asg.pay_basis_id IS NULL)
1605: OR (p_basis_type = 'HOURLY'
1606: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1607: FROM per_pay_bases pyb
1608: WHERE pyb.pay_basis = 'HOURLY'))
1609: OR (p_basis_type = 'SALARIED'
1610: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1611: FROM per_pay_bases pyb
1607: FROM per_pay_bases pyb
1608: WHERE pyb.pay_basis = 'HOURLY'))
1609: OR (p_basis_type = 'SALARIED'
1610: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1611: FROM per_pay_bases pyb
1612: WHERE pyb.pay_basis IN
1613: ('ANNUAL','MONTHLY','PERIOD')))
1614: OR (p_basis_type IS NULL))
1615: AND EXISTS (SELECT 'X'
1646: AND ((p_basis_type = 'OTHER'
1647: AND asg.pay_basis_id IS NULL)
1648: OR (p_basis_type = 'HOURLY'
1649: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1650: FROM per_pay_bases pyb
1651: WHERE pyb.pay_basis = 'HOURLY'))
1652: OR (p_basis_type = 'SALARIED'
1653: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1654: FROM per_pay_bases pyb
1650: FROM per_pay_bases pyb
1651: WHERE pyb.pay_basis = 'HOURLY'))
1652: OR (p_basis_type = 'SALARIED'
1653: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1654: FROM per_pay_bases pyb
1655: WHERE pyb.pay_basis IN
1656: ('ANNUAL','MONTHLY','PERIOD')))
1657: OR (p_basis_type IS NULL));
1658:
1692: AND ((p_basis_type = 'OTHER'
1693: AND asg.pay_basis_id IS NULL)
1694: OR (p_basis_type = 'HOURLY'
1695: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1696: FROM per_pay_bases pyb
1697: WHERE pyb.pay_basis = 'HOURLY'))
1698: OR (p_basis_type = 'SALARIED'
1699: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1700: FROM per_pay_bases pyb
1696: FROM per_pay_bases pyb
1697: WHERE pyb.pay_basis = 'HOURLY'))
1698: OR (p_basis_type = 'SALARIED'
1699: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1700: FROM per_pay_bases pyb
1701: WHERE pyb.pay_basis IN
1702: ('ANNUAL','MONTHLY','PERIOD')))
1703: OR (p_basis_type IS NULL));
1704:
1740: AND ((p_basis_type = 'OTHER'
1741: AND asg.pay_basis_id IS NULL)
1742: OR (p_basis_type = 'HOURLY'
1743: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1744: FROM per_pay_bases pyb
1745: WHERE pyb.pay_basis = 'HOURLY'))
1746: OR (p_basis_type = 'SALARIED'
1747: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1748: FROM per_pay_bases pyb
1744: FROM per_pay_bases pyb
1745: WHERE pyb.pay_basis = 'HOURLY'))
1746: OR (p_basis_type = 'SALARIED'
1747: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
1748: FROM per_pay_bases pyb
1749: WHERE pyb.pay_basis IN
1750: ('ANNUAL','MONTHLY','PERIOD')))
1751: OR (p_basis_type IS NULL));
1752:
2093: AND ((p_basis_type = 'OTHER'
2094: AND asg.pay_basis_id IS NULL)
2095: OR (p_basis_type = 'HOURLY'
2096: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2097: FROM per_pay_bases pyb
2098: WHERE pyb.pay_basis = 'HOURLY'))
2099: OR (p_basis_type = 'SALARIED'
2100: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2101: FROM per_pay_bases pyb
2097: FROM per_pay_bases pyb
2098: WHERE pyb.pay_basis = 'HOURLY'))
2099: OR (p_basis_type = 'SALARIED'
2100: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2101: FROM per_pay_bases pyb
2102: WHERE pyb.pay_basis IN
2103: ('ANNUAL','MONTHLY','PERIOD')))
2104: OR (p_basis_type IS NULL))
2105: AND ROWNUM=1;
2168: AND ((p_basis_type = 'OTHER'
2169: AND asg.pay_basis_id IS NULL)
2170: OR (p_basis_type = 'HOURLY'
2171: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2172: FROM per_pay_bases pyb
2173: WHERE pyb.pay_basis = 'HOURLY'))
2174: OR (p_basis_type = 'SALARIED'
2175: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2176: FROM per_pay_bases pyb
2172: FROM per_pay_bases pyb
2173: WHERE pyb.pay_basis = 'HOURLY'))
2174: OR (p_basis_type = 'SALARIED'
2175: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2176: FROM per_pay_bases pyb
2177: WHERE pyb.pay_basis IN
2178: ('ANNUAL','MONTHLY','PERIOD')))
2179: OR (p_basis_type IS NULL))
2180: AND pya.payroll_action_id = asa.payroll_action_id
2631: AND ((p_basis_type = 'OTHER'
2632: AND asg.pay_basis_id IS NULL)
2633: OR (p_basis_type = 'HOURLY'
2634: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2635: FROM per_pay_bases pyb
2636: WHERE pyb.pay_basis = 'HOURLY')
2637: )
2638: OR (p_basis_type = 'SALARIED'
2639: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2636: WHERE pyb.pay_basis = 'HOURLY')
2637: )
2638: OR (p_basis_type = 'SALARIED'
2639: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2640: FROM per_pay_bases pyb
2641: WHERE pyb.pay_basis IN
2642: ('ANNUAL','MONTHLY','PERIOD'))
2643: )
2644: OR (p_basis_type IS NULL)
2689: AND ((p_basis_type = 'OTHER'
2690: AND asg.pay_basis_id IS NULL)
2691: OR (p_basis_type = 'HOURLY'
2692: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2693: FROM per_pay_bases pyb
2694: WHERE pyb.pay_basis = 'HOURLY'))
2695: OR (p_basis_type = 'SALARIED'
2696: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2697: FROM per_pay_bases pyb
2693: FROM per_pay_bases pyb
2694: WHERE pyb.pay_basis = 'HOURLY'))
2695: OR (p_basis_type = 'SALARIED'
2696: AND asg.pay_basis_id IN (SELECT pyb.pay_basis_id
2697: FROM per_pay_bases pyb
2698: WHERE pyb.pay_basis IN
2699: ('ANNUAL','MONTHLY','PERIOD')))
2700: OR (p_basis_type IS NULL))
2701: AND prb.effective_date BETWEEN p_start_date AND p_end_date