eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on PER_PAY_BASES

Line 309: FROM per_pay_bases pyb

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

Line 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

Line 351: FROM per_pay_bases pyb

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

Line 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:

Line 396: FROM per_pay_bases pyb

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

Line 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:

Line 442: FROM per_pay_bases pyb

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

Line 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:

Line 625: FROM per_pay_bases pyb

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

Line 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

Line 665: FROM per_pay_bases pyb

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

Line 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:

Line 709: FROM per_pay_bases pyb

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

Line 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:

Line 757: FROM per_pay_bases pyb

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

Line 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:

Line 1064: FROM per_pay_bases pyb

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

Line 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'

Line 1110: FROM per_pay_bases pyb

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

Line 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:

Line 1156: FROM per_pay_bases pyb

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

Line 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:

Line 1203: FROM per_pay_bases pyb

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

Line 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:

Line 1607: FROM per_pay_bases pyb

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

Line 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'

Line 1650: FROM per_pay_bases pyb

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

Line 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:

Line 1696: FROM per_pay_bases pyb

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

Line 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:

Line 1744: FROM per_pay_bases pyb

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

Line 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:

Line 2097: FROM per_pay_bases pyb

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

Line 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;

Line 2172: FROM per_pay_bases pyb

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

Line 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

Line 2635: FROM per_pay_bases pyb

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

Line 2640: 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
2640: FROM per_pay_bases pyb
2641: WHERE pyb.pay_basis IN
2642: ('ANNUAL','MONTHLY','PERIOD'))
2643: )
2644: OR (p_basis_type IS NULL)

Line 2693: FROM per_pay_bases pyb

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

Line 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