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.PA_PAY_INTERFACE dependencies on PA_PAY_REJECTIONS_ALL

Line 485: FROM PA_PAY_REJECTIONS_ALL PPR , PA_PAY_SOURCE_AMOUNTS PPS

481:
482: DELETE FROM pa_pay_dist_lines
483: WHERE interface_run_id = G_INTERFACE_RUN_ID AND
484: person_id IN (SELECT DISTINCT PPS.PERSON_ID
485: FROM PA_PAY_REJECTIONS_ALL PPR , PA_PAY_SOURCE_AMOUNTS PPS
486: WHERE PPR.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
487: AND PPR.PAY_SOURCE_ID = PPS.PAY_SOURCE_ID
488:
489: ) ;

Line 501: FROM PA_PAY_REJECTIONS_ALL PPR , PA_PAY_SOURCE_AMOUNTS PPS

497: SELECT DISTINCT PERSON_ID,ASSIGNMENT_ID
498: FROM PA_PAY_SOURCE_AMOUNTS
499: WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
500: AND PERSON_ID NOT IN ( SELECT DISTINCT PPS.PERSON_ID
501: FROM PA_PAY_REJECTIONS_ALL PPR , PA_PAY_SOURCE_AMOUNTS PPS
502: WHERE PPR.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
503: AND PPR.PAY_SOURCE_ID = PPS.PAY_SOURCE_ID
504:
505: )

Line 1073: PA_PAY_REJECTIONS_ALL

1069:
1070: /*RC10 Project Costing required */
1071: INSERT
1072: INTO
1073: PA_PAY_REJECTIONS_ALL
1074: (
1075: PAY_REJECTION_ID ,
1076: INTERFACE_RUN_ID ,
1077: PERSON_ID ,

Line 1111: PA_PAY_REJECTIONS_ALL

1107:
1108: /*RC-15 Distribution Method NONE - Project/Task information missing */
1109: INSERT
1110: INTO
1111: PA_PAY_REJECTIONS_ALL
1112: (
1113: PAY_REJECTION_ID ,
1114: INTERFACE_RUN_ID ,
1115: PERSON_ID ,

Line 1153: PA_PAY_REJECTIONS_ALL

1149: /*RC-24 Negative pay amount */ /*Start changes for bug# 13579969*/
1150:
1151: INSERT
1152: INTO
1153: PA_PAY_REJECTIONS_ALL
1154: (
1155: PAY_REJECTION_ID ,
1156: INTERFACE_RUN_ID ,
1157: PERSON_ID ,

Line 1194: PA_PAY_REJECTIONS_ALL

1190:
1191: /*RC-70 Invalid Project and Task values */
1192: INSERT
1193: INTO
1194: PA_PAY_REJECTIONS_ALL
1195: (
1196: PAY_REJECTION_ID ,
1197: INTERFACE_RUN_ID ,
1198: PERSON_ID ,

Line 1267: PA_PAY_REJECTIONS_ALL

1263: write_log(Log,'Checking uncosted payroll amounts in ' || X.START_DATE || '-' || X.END_DATE);
1264:
1265: INSERT
1266: INTO
1267: PA_PAY_REJECTIONS_ALL
1268: (
1269: PAY_REJECTION_ID ,
1270: INTERFACE_RUN_ID ,
1271: PERSON_ID ,

Line 1334: PA_PAY_REJECTIONS_ALL

1330: -- RC 20
1331:
1332: INSERT
1333: INTO
1334: PA_PAY_REJECTIONS_ALL
1335: (
1336: PAY_REJECTION_ID ,
1337: INTERFACE_RUN_ID ,
1338: PERSON_ID ,

Line 1399: PA_PAY_REJECTIONS_ALL

1395: --RC45
1396:
1397: INSERT
1398: INTO
1399: PA_PAY_REJECTIONS_ALL
1400: (
1401: PAY_REJECTION_ID ,
1402: INTERFACE_RUN_ID ,
1403: PERSON_ID ,

Line 1463: PA_PAY_REJECTIONS_ALL

1459: --RC50
1460:
1461: INSERT
1462: INTO
1463: PA_PAY_REJECTIONS_ALL
1464: (
1465: PAY_REJECTION_ID ,
1466: INTERFACE_RUN_ID ,
1467: PERSON_ID ,

Line 1541: PA_PAY_REJECTIONS_ALL

1537: /*RC55 Invalid Expenditure Organization
1538: Needs to eb tuned further
1539: INSERT
1540: INTO
1541: PA_PAY_REJECTIONS_ALL
1542: (
1543: INTERFACE_RUN_ID ,
1544: PERSON_ID ,
1545: ASSIGNMENT_ID ,

Line 1588: FROM PA_PAY_REJECTIONS_ALL PPR

1584:
1585: UPDATE PA_PAY_SOURCE_AMOUNTS PPS
1586: SET PAY_REJECTION_ID =
1587: ( SELECT MAX(PAY_REJECTION_ID)
1588: FROM PA_PAY_REJECTIONS_ALL PPR
1589: WHERE PPR.PAY_SOURCE_ID = PPS.PAY_SOURCE_ID
1590: )
1591: WHERE REQUEST_ID = G_REQUEST_ID
1592: AND PAY_SOURCE_ID IN

Line 1594: FROM PA_PAY_REJECTIONS_ALL

1590: )
1591: WHERE REQUEST_ID = G_REQUEST_ID
1592: AND PAY_SOURCE_ID IN
1593: (SELECT PAY_SOURCE_ID
1594: FROM PA_PAY_REJECTIONS_ALL
1595: WHERE REQUEST_ID = G_REQUEST_ID
1596: ) ;
1597:
1598: write_log(Log, 'Stamp Stage 1 rejection ids back on Pay Source - ' || SQL%rowcount);

Line 2130: PA_PAY_REJECTIONS_ALL

2126:
2127:
2128: INSERT
2129: INTO
2130: PA_PAY_REJECTIONS_ALL
2131: (
2132: PAY_REJECTION_ID ,
2133: INTERFACE_RUN_ID ,
2134: PERSON_ID ,

Line 2316: INTO PA_PAY_REJECTIONS_ALL

2312:
2313: write_log(Log, ' Processing Rejections on TC - Yes - No TC Found - Misc enabled' );
2314:
2315: INSERT
2316: INTO PA_PAY_REJECTIONS_ALL
2317: (
2318: PAY_REJECTION_ID ,
2319: INTERFACE_RUN_ID ,
2320: PERSON_ID ,

Line 2630: INTO PA_PAY_REJECTIONS_ALL

2626: WHERE hours_total.pay_source_id = source.pay_source_id;
2627:
2628:
2629: INSERT
2630: INTO PA_PAY_REJECTIONS_ALL
2631: (
2632: PAY_REJECTION_ID
2633: , INTERFACE_RUN_ID
2634: , PERSON_ID

Line 2848: INTO PA_PAY_REJECTIONS_ALL

2844: , project_id
2845: , task_id ) SUMM_AMOUNTS , pa_Pay_source_amounts SOURCE WHERE SUMM_AMOUNTS.PAY_SOURCE_ID = SOURCE.PAY_SOURCE_ID ;
2846:
2847: INSERT
2848: INTO PA_PAY_REJECTIONS_ALL
2849: (
2850: PAY_REJECTION_ID
2851: , INTERFACE_RUN_ID
2852: , PERSON_ID

Line 3056: INTO PA_PAY_REJECTIONS_ALL

3052: SUMM_AMOUNTS.PAY_SOURCE_ID = SOURCE.PAY_SOURCE_ID ;
3053:
3054:
3055: INSERT
3056: INTO PA_PAY_REJECTIONS_ALL
3057: (
3058: PAY_REJECTION_ID
3059: , INTERFACE_RUN_ID
3060: , PERSON_ID

Line 3539: Reject a pay element and makes an entry in PA_PAY_REJECTIONS_ALL.

3535: /*
3536: Procedure : REJECT_PAY_ELEMENT
3537: Type : Private
3538: Purpose :
3539: Reject a pay element and makes an entry in PA_PAY_REJECTIONS_ALL.
3540: This is called internally from other procedures which do the distribution.
3541: */
3542:
3543:

Line 3559: PA_PAY_REJECTIONS_ALL

3555: BEGIN
3556:
3557: INSERT
3558: INTO
3559: PA_PAY_REJECTIONS_ALL
3560: (
3561: PAY_REJECTION_ID ,
3562: INTERFACE_RUN_ID ,
3563: PERSON_ID ,

Line 3600: Reject a pay element and makes an entry in PA_PAY_REJECTIONS_ALL.

3596: /*
3597: Procedure : REJECT_PAY_ELEMENT1
3598: Type : Private
3599: Purpose :
3600: Reject a pay element and makes an entry in PA_PAY_REJECTIONS_ALL.
3601: This is called internally from other procedures which do the distribution.
3602: */
3603:
3604: PROCEDURE reject_pay_element1

Line 3617: PA_PAY_REJECTIONS_ALL

3613: BEGIN
3614:
3615: INSERT
3616: INTO
3617: PA_PAY_REJECTIONS_ALL
3618: (
3619: PAY_REJECTION_ID ,
3620: INTERFACE_RUN_ID ,
3621: PERSON_ID ,

Line 3672: PA_PAY_REJECTIONS_ALL

3668: MIN(PAY_REJECTION_ID)
3669: INTO
3670: L_PARENT_REJECTION_ID
3671: FROM
3672: PA_PAY_REJECTIONS_ALL
3673: WHERE
3674: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
3675: PERSON_ID = G_PERSON_ID ;
3676:

Line 3681: FROM PA_PAY_REJECTIONS_ALL PPR , PA_PAY_SOURCE_AMOUNTS PPS

3677: */
3678:
3679: FOR X IN (
3680: SELECT PPS.PERSON_ID , Min(PPR.PAY_REJECTION_ID) PARENT_REJECTION_ID
3681: FROM PA_PAY_REJECTIONS_ALL PPR , PA_PAY_SOURCE_AMOUNTS PPS
3682: WHERE PPR.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3683: AND PPR.INTERFACE_RUN_ID = PPS.INTERFACE_RUN_ID
3684: AND PPR.PAY_SOURCE_ID = PPS.PAY_SOURCE_ID
3685: GROUP BY PPS.PERSON_ID

Line 3692: PA_PAY_REJECTIONS_ALL

3688: LOOP
3689:
3690: INSERT
3691: INTO
3692: PA_PAY_REJECTIONS_ALL
3693: (
3694: PAY_REJECTION_ID ,
3695: INTERFACE_RUN_ID ,
3696: PERSON_ID ,

Line 3732: PA_PAY_REJECTIONS_ALL

3728: (
3729: SELECT DISTINCT
3730: PAY_source_id
3731: FROM
3732: PA_PAY_REJECTIONS_ALL
3733: WHERE
3734: PERSON_ID = X.PERSON_ID AND
3735: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3736: ) ;

Line 3771: PA_PAY_REJECTIONS_ALL

3767: IF l_int_ext_flag = 'INT' THEN
3768:
3769: INSERT
3770: INTO
3771: PA_PAY_REJECTIONS_ALL
3772: (PAY_REJECTION_ID ,
3773: INTERFACE_RUN_ID ,
3774: PERSON_ID ,
3775: ASSIGNMENT_ID ,

Line 3818: PA_PAY_REJECTIONS_ALL

3814: (
3815: SELECT
3816: PAY_SOURCE_ID
3817: FROM
3818: PA_PAY_REJECTIONS_ALL
3819: WHERE
3820: PERSON_ID = G_PERSON_ID AND
3821: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3822: )*/

Line 3832: PA_PAY_REJECTIONS_ALL

3828:
3829: -- For third party payroll
3830: INSERT
3831: INTO
3832: PA_PAY_REJECTIONS_ALL
3833: (PAY_REJECTION_ID ,
3834: INTERFACE_RUN_ID ,
3835: PERSON_ID ,
3836: ASSIGNMENT_ID ,

Line 5753: PA_PAY_REJECTIONS_ALL ppr ,

5749: WHERE PRIORITY = (
5750: SELECT
5751: MIN(pprp.priority)
5752: FROM
5753: PA_PAY_REJECTIONS_ALL ppr ,
5754: pa_pay_rejection_priority pprp
5755: WHERE
5756: ppr.interface_run_id = p_interface_run_id AND
5757: ppr.person_id = p_person_id AND

Line 5799: PA_PAY_REJECTIONS_ALL PPR ,

5795: SELECT
5796: PPR.REJECTION_CODE,
5797: MAX(PPRP.PRIORITY) PRTY
5798: FROM
5799: PA_PAY_REJECTIONS_ALL PPR ,
5800: PA_PAY_REJECTION_PRIORITY PPRP
5801: WHERE
5802: PPR.INTERFACE_RUN_ID = P_INTERFACE_RUN_ID AND
5803: PPR.PERSON_ID = P_PERSON_ID AND