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_SOURCE_AMOUNTS

Line 81: PROCEDURE process_tc_misc( p_pay_source_id pa_pay_source_amounts.pay_source_id%TYPE);

77: --PROCEDURE cleanup_distributions;
78: PROCEDURE mark_processed;
79: PROCEDURE ins_pay_proj;
80:
81: PROCEDURE process_tc_misc( p_pay_source_id pa_pay_source_amounts.pay_source_id%TYPE);
82:
83:
84: PROCEDURE get_fc_rates(
85: X_ACCT_RATE_TYPE OUT NOCOPY VARCHAR2 ,

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 498: FROM PA_PAY_SOURCE_AMOUNTS

494:
495: FOR PPL IN
496: (
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

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 767: Purpose : Below procedure loads the EBS payroll data to PA_PAY_SOURCE_AMOUNTS.

763:
764: /*
765: Procedure : LOAD_SOURCE_AMOUNTS
766: Type : Private
767: Purpose : Below procedure loads the EBS payroll data to PA_PAY_SOURCE_AMOUNTS.
768: Payroll data will be grouped as per the Pay Element Rule setups in PA_PAY_ELEMENT_MAPPING
769: and the org/project/task segment values coming from Payroll
770: Dynamic SQL is built and executed for each pay element
771: Note : Applicable only for EBS Payroll.

Line 772: : PA_PAY_SOURCE_AMOUNTS will show the amount associates with each

768: Payroll data will be grouped as per the Pay Element Rule setups in PA_PAY_ELEMENT_MAPPING
769: and the org/project/task segment values coming from Payroll
770: Dynamic SQL is built and executed for each pay element
771: Note : Applicable only for EBS Payroll.
772: : PA_PAY_SOURCE_AMOUNTS will show the amount associates with each
773: pay element and the status of the setups in PA_PAY_ELEMENT_MAPPING
774: at that time when distribution was run.
775: */
776:

Line 801: INTO PA_PAY_SOURCE_AMOUNTS

797:
798:
799: l_insert_fixed :=
800: 'INSERT
801: INTO PA_PAY_SOURCE_AMOUNTS
802: ( PAY_SOURCE_ID,
803: INTERFACE_RUN_ID,
804: PERSON_ID,
805: ASSIGNMENT_ID,

Line 941: Below procedure loads the Third Party payroll data to PA_PAY_SOURCE_AMOUNTS.

937: /*
938: Procedure : LOAD_SOURCE_AMOUNTS_EXT
939: Type : Private
940: Purpose :
941: Below procedure loads the Third Party payroll data to PA_PAY_SOURCE_AMOUNTS.
942: Payroll data will be grouped as per the Pay Element Rule set-ups in PA_PAY_ELEMENT_MAPPING
943: and the org/project/task segment values
944: Note : Applicable only for External Payroll.
945:

Line 954: PA_PAY_SOURCE_AMOUNTS

950: BEGIN
951:
952: INSERT
953: INTO
954: PA_PAY_SOURCE_AMOUNTS
955: (
956: PAY_SOURCE_ID ,
957: INTERFACE_RUN_ID ,
958: PERSON_ID ,

Line 1100: PA_PAY_SOURCE_AMOUNTS

1096: G_USER_ID ,
1097: G_RUN_DATE ,
1098: G_USER_ID
1099: FROM
1100: PA_PAY_SOURCE_AMOUNTS
1101: WHERE
1102: PROJ_COST_REQD = 'YES' AND
1103: /* PAYROLL_PROJ_SEGMENT IS NULL AND Bug 12678472 */
1104: PAY_SOURCE_PROJECT_ID IS NULL AND

Line 1138: PA_PAY_SOURCE_AMOUNTS

1134: G_USER_ID ,
1135: G_RUN_DATE ,
1136: G_USER_ID
1137: FROM
1138: PA_PAY_SOURCE_AMOUNTS
1139: WHERE
1140: DISTRIBUTION_BASIS_CODE = 'NONE' AND
1141: (
1142: PAY_SOURCE_PROJECT_ID IS NULL OR

Line 1180: PA_PAY_SOURCE_AMOUNTS PPS, PA_PAY_AUDIT PPA

1176: G_USER_ID ,
1177: G_RUN_DATE ,
1178: G_USER_ID
1179: FROM
1180: PA_PAY_SOURCE_AMOUNTS PPS, PA_PAY_AUDIT PPA
1181: WHERE
1182: PPS.INTERFACE_RUN_ID = PPA.INTERFACE_RUN_ID AND
1183: PPA.SOURCE_START_DATE IS NULL AND
1184: PPS.PAY_AMOUNT < 0 AND

Line 1221: PA_PAY_SOURCE_AMOUNTS PPSA

1217: G_USER_ID ,
1218: G_RUN_DATE ,
1219: G_USER_ID
1220: FROM
1221: PA_PAY_SOURCE_AMOUNTS PPSA
1222: WHERE
1223: PAY_SOURCE_PROJECT_ID IS NOT NULL AND
1224: PAY_SOURCE_TASK_ID IS NOT NULL AND
1225: NOT EXISTS

Line 1294: PA_PAY_SOURCE_AMOUNTS

1290: G_USER_ID ,
1291: G_RUN_DATE ,
1292: G_USER_ID
1293: FROM
1294: PA_PAY_SOURCE_AMOUNTS
1295: WHERE
1296: PERSON_ID IN
1297: (
1298: SELECT

Line 1311: PA_PAY_SOURCE_AMOUNTS

1307: (
1308: SELECT DISTINCT
1309: PERSON_ID
1310: FROM
1311: PA_PAY_SOURCE_AMOUNTS
1312: WHERE
1313: INTERFACE_RUN_ID = X.INTERFACE_RUN_ID
1314: )
1315: AND

Line 1361: PA_PAY_SOURCE_AMOUNTS

1357: G_USER_ID ,
1358: G_RUN_DATE ,
1359: G_USER_ID
1360: FROM
1361: PA_PAY_SOURCE_AMOUNTS
1362: WHERE
1363: PERSON_ID IN
1364: (
1365: SELECT

Line 1381: PA_PAY_SOURCE_AMOUNTS

1377: (
1378: SELECT DISTINCT
1379: PERSON_ID
1380: FROM
1381: PA_PAY_SOURCE_AMOUNTS
1382: WHERE
1383: INTERFACE_RUN_ID = X.INTERFACE_RUN_ID
1384: )
1385: AND

Line 1426: PA_PAY_SOURCE_AMOUNTS

1422: G_USER_ID ,
1423: G_RUN_DATE ,
1424: G_USER_ID
1425: FROM
1426: PA_PAY_SOURCE_AMOUNTS
1427: WHERE
1428: PERSON_ID IN
1429: (
1430: SELECT

Line 1445: PA_PAY_SOURCE_AMOUNTS

1441: (
1442: SELECT DISTINCT
1443: PERSON_ID
1444: FROM
1445: PA_PAY_SOURCE_AMOUNTS
1446: WHERE
1447: INTERFACE_RUN_ID = X.INTERFACE_RUN_ID
1448: )
1449: AND

Line 1490: PA_PAY_SOURCE_AMOUNTS

1486: G_USER_ID ,
1487: G_RUN_DATE ,
1488: G_USER_ID
1489: FROM
1490: PA_PAY_SOURCE_AMOUNTS
1491: WHERE
1492: PERSON_ID IN
1493: (
1494: SELECT

Line 1509: PA_PAY_SOURCE_AMOUNTS

1505: (
1506: SELECT DISTINCT
1507: PERSON_ID
1508: FROM
1509: PA_PAY_SOURCE_AMOUNTS
1510: WHERE
1511: INTERFACE_RUN_ID = X.INTERFACE_RUN_ID
1512: )
1513: AND

Line 1566: PA_PAY_SOURCE_AMOUNTS PPSA,

1562: G_USER_ID ,
1563: G_RUN_DATE ,
1564: G_USER_ID
1565: FROM
1566: PA_PAY_SOURCE_AMOUNTS PPSA,
1567: PA_PAY_AUDIT PPA
1568: WHERE
1569: PPSA.INTERFACE_RUN_ID = PPA.INTERFACE_RUN_ID AND
1570: PAY_SOURCE_ORGANIZATION_ID IS NOT NULL AND

Line 1585: UPDATE PA_PAY_SOURCE_AMOUNTS PPS

1581: organization_id = PPSA.PAY_SOURCE_ORGANIZATION_ID AND
1582: AND PPA.PAY_PERIOD_END_DATE between paev.date_from and paev.date_to )
1583: REQUEST_ID = p_request_id; */
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

Line 1670: from PA_PAY_SOURCE_AMOUNTS

1666: trunc(sysdate),
1667: fnd_global.user_id,
1668: trunc(sysdate),
1669: fnd_global.user_id
1670: from PA_PAY_SOURCE_AMOUNTS
1671: WHERE PAY_REJECTION_ID IS NULL
1672: AND DISTRIBUTION_BASIS_CODE = 'NONE'
1673: AND PAY_SOURCE_PROJECT_ID >0
1674: AND PAY_SOURCE_TASK_ID > 0

Line 1699: UPDATE PA_PAY_SOURCE_AMOUNTS

1695:
1696: write_log(Log, 'Deriving priorities for request Id' || G_REQUEST_ID);
1697:
1698: /* Bug 12804239
1699: UPDATE PA_PAY_SOURCE_AMOUNTS
1700: SET PRIORITY =
1701: ( Decode(PAY_CURRENCY_CODE,G_FUNC_CURR_CODE,10000,0)+
1702: (Decode(PAY_SOURCE_PROJECT_ID,NULL , 0,1)*1000) +
1703: (Decode(PAY_SOURCE_TASK_ID,NULL , 0,1)*100) +

Line 1711: UPDATE PA_PAY_SOURCE_AMOUNTS

1707: Upper(TIMECARD_ELEMENT) = 'YES'
1708: AND REQUEST_ID = G_REQUEST_ID;
1709: */
1710:
1711: UPDATE PA_PAY_SOURCE_AMOUNTS
1712: SET PRIORITY =
1713: (
1714:
1715: (Decode(PAY_SOURCE_PROJECT_ID,NULL , 0,1)*10000) +

Line 1728: UPDATE PA_PAY_SOURCE_AMOUNTS

1724: Upper(TIMECARD_ELEMENT) = 'YES'
1725: AND REQUEST_ID = G_REQUEST_ID;
1726:
1727: /* Added for bug#12975007 */
1728: UPDATE PA_PAY_SOURCE_AMOUNTS
1729: SET PRIORITY =
1730: (
1731:
1732: (Decode(PAY_SOURCE_PROJECT_ID,NULL , 0,1)*20000) +

Line 1743: UPDATE PA_PAY_SOURCE_AMOUNTS

1739: AND REQUEST_ID = G_REQUEST_ID;
1740:
1741:
1742:
1743: UPDATE PA_PAY_SOURCE_AMOUNTS
1744: SET PRIORITY =
1745: (
1746:
1747: (Decode(PAY_SOURCE_PROJECT_ID,NULL , 0,1)*30000) +

Line 1829: WHERE EI.INCURRED_BY_PERSON_ID IN (SELECT DISTINCT PERSON_ID FROM PA_PAY_SOURCE_AMOUNTS

1825: EII.PAYROLL_ACCRUAL_FLAG,
1826: EII.TRANSFERRED_FROM_EXP_ITEM_ID
1827: FROM PA_EXPENDITURE_ITEMS EII,
1828: PA_EXPENDITURES EI
1829: WHERE EI.INCURRED_BY_PERSON_ID IN (SELECT DISTINCT PERSON_ID FROM PA_PAY_SOURCE_AMOUNTS
1830: WHERE
1831: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID)
1832: AND EI.EXPENDITURE_ID = EII.EXPENDITURE_ID
1833: AND EII.expenditure_item_date BETWEEN P_START_DATE AND P_END_DATE

Line 2016: PA_PAY_SOURCE_AMOUNTS

2012: SELECT DISTINCT
2013: PRIORITY ,
2014: PAY_CURRENCY_CODE
2015: FROM
2016: PA_PAY_SOURCE_AMOUNTS
2017: WHERE
2018: DISTRIBUTION_BASIS_CODE IN ('STHOURS', 'OTHOURS', 'TOTAL_HOURS')
2019: AND
2020: TIMECARD_ELEMENT = 'YES' AND

Line 2081: PA_PAY_SOURCE_AMOUNTS PSA

2077: G_LOGIN_ID ,
2078: G_REQUEST_ID
2079: FROM
2080: PA_PAY_EXP_TEMP EII , -- change to PA_PAY_EXP_TEMP danger
2081: PA_PAY_SOURCE_AMOUNTS PSA
2082: WHERE
2083: PSA.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
2084: PSA.PRIORITY = Z.PRIORITY AND
2085: PSA.PAY_CURRENCY_CODE = Z.PAY_CURRENCY_CODE AND

Line 2159: PA_PAY_SOURCE_AMOUNTS PS

2155: G_USER_ID ,
2156: G_RUN_DATE ,
2157: G_USER_ID
2158: FROM
2159: PA_PAY_SOURCE_AMOUNTS PS
2160: Where
2161: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
2162: PRIORITY = Z.PRIORITY AND
2163: PAY_CURRENCY_CODE = Z.PAY_CURRENCY_CODE AND

Line 2249: PA_PAY_SOURCE_AMOUNTS PPSA

2245: PAY_AMOUNT,
2246: SUM(QUANTITY) AS HOURS
2247: FROM
2248: PA_PAY_EXP_TEMP EI,
2249: PA_PAY_SOURCE_AMOUNTS PPSA
2250: WHERE
2251: PPSA.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
2252: PPSA.PRIORITY = Z.PRIORITY AND
2253: PPSA.PAY_CURRENCY_CODE = Z.PAY_CURRENCY_CODE AND

Line 2343: FROM PA_PAY_SOURCE_AMOUNTS PS

2339: G_RUN_DATE ,
2340: G_USER_ID ,
2341: G_RUN_DATE ,
2342: G_USER_ID
2343: FROM PA_PAY_SOURCE_AMOUNTS PS
2344: WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2345: AND PRIORITY = Z.PRIORITY
2346: AND PAY_CURRENCY_CODE = Z.PAY_CURRENCY_CODE
2347: AND NVL(PS.ALLOW_MISC_FLAG,'NO') = 'YES'

Line 2363: PA_PAY_SOURCE_AMOUNTS SOURCE

2359: SET PROCESSED_FLAG = 'Y'
2360: WHERE EXPENDITURE_ITEM_ID IN
2361: (SELECT DIST.SOURCE_EXPENDITURE_ITEM_ID
2362: FROM PA_PAY_DIST_LINES DIST,
2363: PA_PAY_SOURCE_AMOUNTS SOURCE
2364: WHERE SOURCE.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2365: AND SOURCE.PRIORITY = Z.PRIORITY
2366: AND SOURCE.PAY_CURRENCY_CODE = Z.PAY_CURRENCY_CODE
2367: AND DIST.PAY_SOURCE_ID = SOURCE.PAY_SOURCE_ID

Line 2397: p_pay_source_id pa_pay_source_amounts.pay_source_id%TYPE

2393:
2394:
2395: PROCEDURE process_tc_misc
2396: (
2397: p_pay_source_id pa_pay_source_amounts.pay_source_id%TYPE
2398: )
2399: IS
2400: l_row_count PLS_INTEGER := 0;
2401: ALLOW_MISC_TC_NOT_FOUND EXCEPTION;

Line 2409: FOR X IN ( SELECT * FROM pa_pay_source_amounts WHERE pay_source_id =p_pay_source_id )

2405: write_log(Log, 'p_pay_source_id' || p_pay_source_id);
2406:
2407:
2408:
2409: FOR X IN ( SELECT * FROM pa_pay_source_amounts WHERE pay_source_id =p_pay_source_id )
2410: Loop
2411: INSERT
2412: INTO PA_PAY_DIST_LINES
2413: ( PAY_DIST_ID,

Line 2590: , PA_PAY_SOURCE_AMOUNTS S2

2586: , project_id
2587: , task_id
2588: , SUM(NVL(quantity,0)) AS hours
2589: FROM PA_PAY_EXP_TEMP TEMP
2590: , PA_PAY_SOURCE_AMOUNTS S2
2591: WHERE S2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2592: AND DISTRIBUTION_BASIS_CODE IN ('STHOURS'
2593: , 'OTHOURS'
2594: , 'TOTAL_HOURS')

Line 2625: , PA_PAY_SOURCE_AMOUNTS SOURCE

2621: , project_id
2622: , task_id
2623: )
2624: Hours_total
2625: , PA_PAY_SOURCE_AMOUNTS SOURCE
2626: WHERE hours_total.pay_source_id = source.pay_source_id;
2627:
2628:
2629: INSERT

Line 2657: FROM PA_PAY_SOURCE_AMOUNTS PS

2653: , G_RUN_DATE
2654: , G_USER_ID
2655: , G_RUN_DATE
2656: , G_USER_ID
2657: FROM PA_PAY_SOURCE_AMOUNTS PS
2658: WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2659: AND DISTRIBUTION_BASIS_CODE IN ('STHOURS'
2660: , 'OTHOURS'
2661: , 'TOTAL_HOURS')

Line 2764: ,PA_PAY_SOURCE_AMOUNTS S1

2760: , project_id
2761: , task_id
2762: , SUM(ACCT_RAW_COST) AS amount
2763: FROM PA_PAY_DIST_LINES DIST
2764: ,PA_PAY_SOURCE_AMOUNTS S1
2765: WHERE S1.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2766: AND DISTRIBUTION_BASIS_CODE IN ('ST_AMT'
2767: ,'OT_AMT'
2768: , 'ST_OT_AMT')

Line 2806: , PA_PAY_SOURCE_AMOUNTS S2

2802: , project_id
2803: , task_id
2804: , SUM(acct_raw_cost) AS amount
2805: FROM PA_PAY_EXP_TEMP TEMP
2806: , PA_PAY_SOURCE_AMOUNTS S2
2807: WHERE S2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2808: AND DISTRIBUTION_BASIS_CODE IN ('ST_AMT'
2809: ,'OT_AMT'
2810: , 'ST_OT_AMT')

Line 2845: , task_id ) SUMM_AMOUNTS , pa_Pay_source_amounts SOURCE WHERE SUMM_AMOUNTS.PAY_SOURCE_ID = SOURCE.PAY_SOURCE_ID ;

2841: GROUP BY
2842: pay_source_id
2843: , organization_id
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: (

Line 2875: FROM PA_PAY_SOURCE_AMOUNTS PS

2871: , G_RUN_DATE
2872: , G_USER_ID
2873: , G_RUN_DATE
2874: , G_USER_ID
2875: FROM PA_PAY_SOURCE_AMOUNTS PS
2876: WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2877: AND DISTRIBUTION_BASIS_CODE IN ('ST_AMT'
2878: ,'OT_AMT'
2879: , 'ST_OT_AMT')

Line 2981: PA_PAY_SOURCE_AMOUNTS S1

2977: TASK_ID ,
2978: SUM(ACCT_RAW_COST) AS AMOUNT
2979: FROM
2980: PA_PAY_DIST_LINES DIST ,
2981: PA_PAY_SOURCE_AMOUNTS S1
2982: WHERE
2983: S1.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
2984: DISTRIBUTION_BASIS_CODE = 'TOTAL_RAW' AND
2985: DIST.PERSON_ID = S1.PERSON_ID AND

Line 3016: PA_PAY_SOURCE_AMOUNTS S2

3012: TASK_ID ,
3013: SUM(ACCT_RAW_COST) AS AMOUNT
3014: FROM
3015: PA_PAY_EXP_TEMP TEMP ,
3016: PA_PAY_SOURCE_AMOUNTS S2
3017: WHERE
3018: S2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
3019: DISTRIBUTION_BASIS_CODE = 'TOTAL_RAW' AND
3020: S2.PERSON_ID = TEMP.INCURRED_BY_PERSON_ID AND

Line 3050: PA_PAY_SOURCE_AMOUNTS SOURCE

3046: PROJECT_ID ,
3047: TASK_ID
3048: )
3049: SUMM_AMOUNTS ,
3050: PA_PAY_SOURCE_AMOUNTS SOURCE
3051: WHERE
3052: SUMM_AMOUNTS.PAY_SOURCE_ID = SOURCE.PAY_SOURCE_ID ;
3053:
3054:

Line 3083: FROM PA_PAY_SOURCE_AMOUNTS PS

3079: , G_RUN_DATE
3080: , G_USER_ID
3081: , G_RUN_DATE
3082: , G_USER_ID
3083: FROM PA_PAY_SOURCE_AMOUNTS PS
3084: WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3085: AND DISTRIBUTION_BASIS_CODE = 'TOTAL_RAW'
3086: AND PS.PAY_SOURCE_ID NOT IN ( SELECT PAY_SOURCE_ID
3087: FROM PA_PAY_DIST_LINES PPD

Line 3644: from pa_pay_source_amounts where pay_source_id = P_PAY_SOURCE_ID;

3640: G_RUN_DATE ,
3641: G_USER_ID ,
3642: G_RUN_DATE ,
3643: G_USER_ID
3644: from pa_pay_source_amounts where pay_source_id = P_PAY_SOURCE_ID;
3645:
3646: write_log (LOG, 'Reject pay Element Count' || SQL%rowcount);
3647: COMMIT;
3648: END reject_pay_element1;

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 3723: PA_PAY_SOURCE_AMOUNTS

3719: G_USER_ID ,
3720: G_RUN_DATE ,
3721: G_USER_ID
3722: FROM
3723: PA_PAY_SOURCE_AMOUNTS
3724: WHERE
3725: PERSON_ID = X.PERSON_ID AND
3726: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
3727: PAY_source_id NOT IN

Line 3809: PA_PAY_SOURCE_AMOUNTS PSA

3805: (
3806: SELECT
3807: PAY_ELEMENT_TYPE_ID
3808: FROM
3809: PA_PAY_SOURCE_AMOUNTS PSA
3810: WHERE
3811: PSA.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
3812: PSA.PERSON_ID = G_PERSON_ID /*AND
3813: PAY_SOURCE_ID IN

Line 3868: PA_PAY_SOURCE_AMOUNTS PSA

3864: (
3865: SELECT
3866: PAY_ELEMENT_TYPE_CODE
3867: FROM
3868: PA_PAY_SOURCE_AMOUNTS PSA
3869: WHERE
3870: PSA.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
3871: PSA.PERSON_ID = G_PERSON_ID
3872: ))rej ;

Line 5868: PA_PAY_SOURCE_AMOUNTS SRC

5864: 'Y' STATUS
5865: FROM
5866: PA_PAY_AUDIT AUD ,
5867: PA_PAY_INTERFACE_TEMP TEMP ,
5868: PA_PAY_SOURCE_AMOUNTS SRC
5869: WHERE
5870: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
5871: AUD.INTERFACE_RUN_ID = SRC.INTERFACE_RUN_ID AND
5872: TEMP.PERSON_ID = SRC.PERSON_ID AND

Line 5897: PA_PAY_SOURCE_AMOUNTS PPSA

5893: (
5894: SELECT
5895: 'Y'
5896: FROM
5897: PA_PAY_SOURCE_AMOUNTS PPSA
5898: WHERE
5899: PPSA.PERSON_ID = G_PERSON_ID AND
5900: PPSA.ASSIGNMENT_ID = G_ASSIGNMENT_ID AND
5901: PPSA.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND

Line 5925: PA_PAY_SOURCE_AMOUNTS SRC

5921: EXT.INTERFACE_LINE_ID
5922: FROM
5923: PA_PAY_AUDIT AUD ,
5924: PA_PAY_EXT_INTERAFACE_V EXT ,
5925: PA_PAY_SOURCE_AMOUNTS SRC
5926: WHERE
5927: AUD.INT_EXT_INDICATOR = 'EXT' AND
5928: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
5929: AUD.INTERFACE_RUN_ID = SRC.INTERFACE_RUN_ID AND

Line 5962: PA_PAY_SOURCE_AMOUNTS SRC

5958: (
5959: SELECT
5960: PAY_ELEMENT_TYPE_CODE
5961: FROM
5962: PA_PAY_SOURCE_AMOUNTS SRC
5963: WHERE
5964: SRC.INTERFACE_RUN_ID = AUD.INTERFACE_RUN_ID AND
5965: SRC.PERSON_ID = G_PERSON_ID AND
5966: SRC.ASSIGNMENT_ID = G_ASSIGNMENT_ID AND