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_DIST_LINES

Line 482: DELETE FROM pa_pay_dist_lines

478: convert_to_fc;
479: process_total_raw; /*Process pay elements where distribution is based on Total Raw Cost*/
480:
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

Line 1612: Entry made in PA_PAY_DIST_LINES.

1608: Procedure : PROCESS_NONE
1609: Type : Private
1610: Purpose : Pay element with distribution method of 'NONE'
1611: are processed here .
1612: Entry made in PA_PAY_DIST_LINES.
1613: */
1614:
1615:
1616: PROCEDURE PROCESS_NONE IS

Line 1622: INTO PA_PAY_DIST_LINES

1618:
1619: write_log(Log, 'Processing NONE ');
1620:
1621: INSERT
1622: INTO PA_PAY_DIST_LINES
1623: ( PAY_DIST_ID,
1624: PAY_SOURCE_ID,
1625: INTERFACE_RUN_ID,
1626: PERSON_ID,

Line 2029: PA_PAY_DIST_LINES

2025: )
2026: LOOP
2027: INSERT
2028: INTO
2029: PA_PAY_DIST_LINES
2030: (
2031: PAY_DIST_ID ,
2032: PAY_SOURCE_ID ,
2033: INTERFACE_RUN_ID ,

Line 2167: SELECT 1 FROM PA_PAY_DIST_LINES PPD

2163: PAY_CURRENCY_CODE = Z.PAY_CURRENCY_CODE AND
2164: Nvl(PS.ALLOW_MISC_FLAG,'NO') = 'NO' AND
2165: NOT EXISTS
2166: (
2167: SELECT 1 FROM PA_PAY_DIST_LINES PPD
2168: WHERE
2169: PPD.PAY_SOURCE_ID = PS.PAY_SOURCE_ID
2170: )
2171: ;

Line 2180: PA_PAY_DIST_LINES

2176: write_log(Log, ' Processing TC - Yes - No TC Found - Misc enabled' );
2177:
2178: INSERT
2179: INTO
2180: PA_PAY_DIST_LINES
2181: (
2182: PAY_DIST_ID ,
2183: PAY_SOURCE_ID ,
2184: INTERFACE_RUN_ID ,

Line 2260: PA_PAY_DIST_LINES PPD

2256: PPSA.PAY_SOURCE_ID NOT IN
2257: ( SELECT
2258: PAY_SOURCE_ID
2259: FROM
2260: PA_PAY_DIST_LINES PPD
2261: WHERE
2262: PPD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2263: )AND
2264: NVL(PPSA.ALLOW_MISC_FLAG,'NO') = 'YES' AND

Line 2350: FROM PA_PAY_DIST_LINES PPD

2346: AND PAY_CURRENCY_CODE = Z.PAY_CURRENCY_CODE
2347: AND NVL(PS.ALLOW_MISC_FLAG,'NO') = 'YES'
2348: AND PS.PAY_SOURCE_ID NOT IN
2349: ( SELECT PAY_SOURCE_ID
2350: FROM PA_PAY_DIST_LINES PPD
2351: WHERE PPD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2352: ) ;
2353:
2354: write_log(Log, ' Rejected Record count for Enable Misc processing ' || SQL%RowCount );

Line 2362: FROM PA_PAY_DIST_LINES DIST,

2358: UPDATE PA_PAY_EXP_TEMP
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

Line 2412: INTO PA_PAY_DIST_LINES

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,
2414: PAY_SOURCE_ID,
2415: INTERFACE_RUN_ID ,
2416: PERSON_ID ,

Line 2516: PJ/BTC record in PA_PAY_DIST_LINES

2512: Purpose :
2513: Process the pay elements with distribution method of ST HOURS / OT HOURS / ALL HOURS .
2514: when set up says that it should not go on a timecard .
2515: This procedure distributes the pay elements based on hours and finally creates a
2516: PJ/BTC record in PA_PAY_DIST_LINES
2517: */
2518:
2519:
2520: PROCEDURE process_non_tc_elements

Line 2529: PA_PAY_DIST_LINES

2525: write_log(LOG , 'Processing Hour based , TC Element -NO');
2526:
2527:
2528: INSERT INTO
2529: PA_PAY_DIST_LINES
2530: ( PAY_DIST_ID,
2531: PAY_SOURCE_ID,
2532: INTERFACE_RUN_ID ,
2533: PERSON_ID ,

Line 2664: FROM PA_PAY_DIST_LINES PPD

2660: , 'OTHOURS'
2661: , 'TOTAL_HOURS')
2662: AND NVL(TIMECARD_ELEMENT,'NO') = 'NO'
2663: AND PS.PAY_SOURCE_ID NOT IN ( SELECT PAY_SOURCE_ID
2664: FROM PA_PAY_DIST_LINES PPD
2665: WHERE PPD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2666: ) ;
2667:
2668:

Line 2701: INTO PA_PAY_DIST_LINES

2697:
2698: BEGIN
2699:
2700: INSERT
2701: INTO PA_PAY_DIST_LINES
2702: (
2703: PAY_DIST_ID
2704: , PAY_SOURCE_ID
2705: , INTERFACE_RUN_ID

Line 2763: FROM PA_PAY_DIST_LINES DIST

2759: , NVL(organization_id ,OVERRIDE_TO_ORGANIZATION_ID) organization_id
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'

Line 2881: FROM PA_PAY_DIST_LINES PPD

2877: AND DISTRIBUTION_BASIS_CODE IN ('ST_AMT'
2878: ,'OT_AMT'
2879: , 'ST_OT_AMT')
2880: AND PS.PAY_SOURCE_ID NOT IN ( SELECT PAY_SOURCE_ID
2881: FROM PA_PAY_DIST_LINES PPD
2882: WHERE PPD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
2883: ) ;
2884:
2885: EXCEPTION

Line 2898: Here the difference is that the amounts in PA_PAY_DIST_LINES

2894: Type : Private
2895: Purpose :
2896: Process the pay elements with distribution method of Total Raw .
2897: This procedure distributes the pay element based on amounts .
2898: Here the difference is that the amounts in PA_PAY_DIST_LINES
2899: from the current run is also considered.
2900: */
2901:
2902:

Line 2913: PA_PAY_DIST_LINES

2909:
2910:
2911: INSERT
2912: INTO
2913: PA_PAY_DIST_LINES
2914: (
2915: PAY_DIST_ID ,
2916: PAY_SOURCE_ID ,
2917: INTERFACE_RUN_ID ,

Line 2980: PA_PAY_DIST_LINES DIST ,

2976: PROJECT_ID ,
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

Line 3087: FROM PA_PAY_DIST_LINES PPD

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
3088: WHERE PPD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3089: ) ;
3090: END process_total_raw;
3091:

Line 3435: pa_pay_dist_lines

3431: CURR_ATTR_NOT_FOUND EXCEPTION;
3432: BEGIN
3433:
3434: UPDATE
3435: pa_pay_dist_lines
3436: SET
3437: ACCT_RAW_COST = DENOM_RAW_COST ,
3438: ACCT_CURRENCY_CODE = DENOM_CURRENCY_CODE
3439: WHERE

Line 3459: pa_pay_dist_lines

3455: TRUNC(expenditure_item_date)expenditure_item_date,
3456: denom_currency_code ,
3457: denom_raw_cost
3458: FROM
3459: pa_pay_dist_lines
3460: WHERE
3461: interface_run_id = G_INTERFACE_RUN_ID AND
3462: /* person_id = G_PERSON_ID AND */
3463: DENOM_CURRENCY_CODE <> G_FUNC_CURR_CODE

Line 3512: pa_pay_dist_lines

3508: RAISE CURR_ATTR_NOT_FOUND;
3509: END IF ;
3510:
3511: UPDATE
3512: pa_pay_dist_lines
3513: SET
3514: ACCT_RAW_COST = l_acct_pay_amount ,
3515: ACCT_CURRENCY_CODE = G_FUNC_CURR_CODE ,
3516: ACCT_EXCHANGE_RATE = l_acct_exch_rate ,

Line 3888: Creates BTC expenditure items from distributions created in PA_PAY_DIST_LINES

3884: /*
3885: Procedure : PROCESS_BURDEN
3886: Type : Private
3887: Purpose :
3888: Creates BTC expenditure items from distributions created in PA_PAY_DIST_LINES
3889: */
3890:
3891: PROCEDURE process_burden IS
3892: l_exp_group pa_expenditure_groups_all.expenditure_group%type;

Line 3913: FROM pa_pay_dist_lines

3909: BEGIN
3910:
3911: SELECT 'Y' INTO l_burden_exists FROM dual
3912: WHERE EXISTS (SELECT 1
3913: FROM pa_pay_dist_lines
3914: WHERE SYSTEM_LINKAGE_FUNCTION = 'BTC'
3915: AND INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3916: AND PERSON_ID = G_PERSON_ID ) ;
3917:

Line 3944: FROM pa_pay_dist_lines

3940: -- For each organization and denom currency , create a expenditure
3941: FOR X IN
3942: (SELECT DISTINCT organization_id ,
3943: denom_currency_code
3944: FROM pa_pay_dist_lines
3945: WHERE SYSTEM_LINKAGE_FUNCTION = 'BTC'
3946: AND INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3947: AND PERSON_ID = G_PERSON_ID
3948: )

Line 4007: PA_PAY_DIST_LINES DIST ,

4003: DIST.DENOM_CURRENCY_CODE ,
4004: DIST.ACCT_CURRENCY_CODE ,
4005: SUM(DIST.DENOM_BURDEN_COST) DENOM_BURDEN_COST
4006: FROM
4007: PA_PAY_DIST_LINES DIST ,
4008: PA_PROJECTS_ALL PA
4009: WHERE
4010: DIST.PROJECT_ID = PA.PROJECT_ID AND
4011: SYSTEM_LINKAGE_FUNCTION = 'BTC' AND

Line 4106: PA_PAY_DIST_LINES

4102:
4103: FOR X IN (SELECT DISTINCT
4104: PAY_SOURCE_ID,PAY_ELEMENT_TYPE_ID,PAY_ELEMENT_TYPE_CODE
4105: FROM
4106: PA_PAY_DIST_LINES
4107: WHERE
4108: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
4109: PERSON_ID = G_PERSON_ID AND
4110: PROJECT_ID = Y.PROJECT_ID AND

Line 4127: PA_PAY_DIST_LINES

4123:
4124: FOR X IN (SELECT DISTINCT
4125: PAY_SOURCE_ID,PAY_ELEMENT_TYPE_ID,PAY_ELEMENT_TYPE_CODE
4126: FROM
4127: PA_PAY_DIST_LINES
4128: WHERE
4129: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
4130: PERSON_ID = G_PERSON_ID AND
4131: PROJECT_ID = Y.PROJECT_ID AND

Line 4313: UPDATE PA_PAY_DIST_LINES

4309: ) ;
4310:
4311: /*Added for bug#12975007*/
4312: /*PAPAY_REP*/
4313: UPDATE PA_PAY_DIST_LINES
4314: SET TARGET_EXPENDITURE_ITEM_ID = l_exp_item_id
4315: WHERE ORGANIZATION_ID = Y. ORGANIZATION_ID
4316: AND PROJECT_ID = Y.PROJECT_ID
4317: AND TASK_ID = Y.TASK_ID

Line 4358: Creates PJ expenditure items from distributions created in PA_PAY_DIST_LINES

4354: /*
4355: Procedure : PROCESS_MISC
4356: Type : Private
4357: Purpose :
4358: Creates PJ expenditure items from distributions created in PA_PAY_DIST_LINES
4359: */
4360:
4361: PROCEDURE process_misc IS
4362: l_exp_group pa_expenditure_groups_all.expenditure_group%type;

Line 4384: FROM pa_pay_dist_lines

4380:
4381: BEGIN
4382: SELECT 'Y' INTO l_misc_exists FROM dual
4383: WHERE EXISTS (SELECT 1
4384: FROM pa_pay_dist_lines
4385: WHERE SYSTEM_LINKAGE_FUNCTION = 'PJ'
4386: AND INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
4387: AND PERSON_ID = G_PERSON_ID ) ;
4388:

Line 4425: FROM pa_pay_dist_lines

4421: -- For each organization and denom currency , create a expenditure
4422: FOR X IN
4423: (SELECT DISTINCT organization_id ,
4424: denom_currency_code
4425: FROM pa_pay_dist_lines
4426: WHERE SYSTEM_LINKAGE_FUNCTION = 'PJ'
4427: AND INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
4428: AND PERSON_ID = G_PERSON_ID
4429: )

Line 4491: PA_PAY_DIST_LINES DIST,

4487: DIST.DENOM_CURRENCY_CODE ,
4488: DIST.acct_currency_code,
4489: SUM(DIST.DENOM_RAW_COST) DENOM_RAW_COST
4490: FROM
4491: PA_PAY_DIST_LINES DIST,
4492: PA_PROJECTS_ALL PA
4493: WHERE
4494: DIST.PROJECT_ID = PA.PROJECT_ID AND
4495: SYSTEM_LINKAGE_FUNCTION = 'PJ' AND

Line 4589: PA_PAY_DIST_LINES

4585:
4586: FOR X IN (SELECT DISTINCT
4587: PAY_SOURCE_ID,PAY_ELEMENT_TYPE_ID,PAY_ELEMENT_TYPE_CODE
4588: FROM
4589: PA_PAY_DIST_LINES
4590: WHERE
4591: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
4592: PERSON_ID = G_PERSON_ID AND
4593: PROJECT_ID = Y.PROJECT_ID AND

Line 4611: PA_PAY_DIST_LINES

4607:
4608: FOR X IN (SELECT DISTINCT
4609: PAY_SOURCE_ID,PAY_ELEMENT_TYPE_ID,PAY_ELEMENT_TYPE_CODE
4610: FROM
4611: PA_PAY_DIST_LINES
4612: WHERE
4613: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
4614: PERSON_ID = G_PERSON_ID AND
4615: PROJECT_ID = Y.PROJECT_ID AND

Line 4799: UPDATE PA_PAY_DIST_LINES

4795: );
4796:
4797: /*Added for bug#12975007*/
4798: /*PAPAY_REP*/
4799: UPDATE PA_PAY_DIST_LINES
4800: SET TARGET_EXPENDITURE_ITEM_ID = l_exp_item_id
4801: WHERE ORGANIZATION_ID = Y. ORGANIZATION_ID
4802: AND PROJECT_ID = Y.PROJECT_ID
4803: AND TASK_ID = Y.TASK_ID

Line 4877: PA_PAY_DIST_LINES DIST , PA_PAY_EXP_TEMP EI

4873: ORIG_CURR_CODE ,
4874: Sum(ORIG_AMOUNT) ORIG_AMOUNT ,
4875: SUM(DENOM_RAW_COST) DENOM_RAW_COST
4876: FROM
4877: PA_PAY_DIST_LINES DIST , PA_PAY_EXP_TEMP EI
4878: WHERE
4879: DIST.SOURCE_EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID AND
4880: DIST.SOURCE_EXPENDITURE_ITEM_ID IS NOT NULL AND
4881: DIST.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND

Line 4941: UPDATE PA_PAY_DIST_LINES

4937: EXPENDITURE_ITEM_ID = X.SOURCE_EXPENDITURE_ITEM_ID;
4938:
4939: /*Added for bug#12975007*/
4940: /*PAPAY_REP*/
4941: UPDATE PA_PAY_DIST_LINES
4942: SET TARGET_EXPENDITURE_ITEM_ID = SOURCE_EXPENDITURE_ITEM_ID
4943: WHERE SOURCE_EXPENDITURE_ITEM_ID = X.SOURCE_EXPENDITURE_ITEM_ID;
4944:
4945: write_log(LOG,'Case of uncosted EIs .. updated expendture item '|| X.SOURCE_EXPENDITURE_ITEM_ID);

Line 4955: PA_PAY_DIST_LINES DIST , PA_PAY_EXP_TEMP TEMP

4951: DIST.SOURCE_EXPENDITURE_ITEM_ID,DIST.DENOM_CURRENCY_CODE,
4952: TEMP.COST_DISTRIBUTED_FLAG,TEMP.PAYROLL_ACCRUAL_FLAG , TEMP.ORIG_CURR_CODE,
4953: TEMP.ORIG_AMOUNT,TEMP.EXPENDITURE_ITEM_DATE
4954: FROM
4955: PA_PAY_DIST_LINES DIST , PA_PAY_EXP_TEMP TEMP
4956: WHERE
4957:
4958: DIST.SOURCE_EXPENDITURE_ITEM_ID IS NOT NULL AND
4959: DIST.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND

Line 5499: pa_pay_dist_lines

5495: G_INTERFACE_RUN_ID
5496: FROM
5497: PA_EXPENDITURE_ITEMS_ALL ei,
5498: ( SELECT source_expenditure_item_id seid ,denom_CURRENCY_CODE,Sum(denom_raw_cost) denom_raw_cost, Sum(denom_raw_cost) acct_raw_cost FROM
5499: pa_pay_dist_lines
5500: WHERE
5501: source_expenditure_item_id IS NOT NULL
5502: AND interface_run_id = G_INTERFACE_RUN_ID
5503: AND person_id = G_PERSON_ID

Line 5513: UPDATE PA_PAY_DIST_LINES

5509: write_log(Log, 'New item inserted ' || l_transfer_id);
5510:
5511: /*Added for bug#12975007*/
5512: /*PAPAY_REP*/
5513: UPDATE PA_PAY_DIST_LINES
5514: SET TARGET_EXPENDITURE_ITEM_ID = l_transfer_id
5515: WHERE SOURCE_EXPENDITURE_ITEM_ID = X.SOURCE_EXPENDITURE_ITEM_ID;
5516:
5517: -- Copy the comments

Line 5718: DELETE FROM pa_pay_dist_lines

5714: /* Not used any more
5715: PROCEDURE cleanup_distributions IS
5716: BEGIN
5717:
5718: DELETE FROM pa_pay_dist_lines
5719: WHERE interface_run_id = G_INTERFACE_RUN_ID AND
5720: person_id = G_PERSON_ID ;
5721:
5722: END cleanup_distributions;

Line 6460: PA_PAY_DIST_LINES

6456: PAY_SOURCE_ID ,
6457: PAY_ELEMENT_TYPE_ID,
6458: PAY_ELEMENT_TYPE_CODE
6459: FROM
6460: PA_PAY_DIST_LINES
6461: WHERE
6462: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
6463: PERSON_ID = G_PERSON_ID AND
6464: SOURCE_EXPENDITURE_ITEM_ID = P_SOURCE_EXPENDITURE_ITEM_ID

Line 6503: PA_PAY_DIST_LINES

6499: PAY_SOURCE_ID ,
6500: PAY_ELEMENT_TYPE_ID,
6501: PAY_ELEMENT_TYPE_CODE
6502: FROM
6503: PA_PAY_DIST_LINES
6504: WHERE
6505: INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
6506: PERSON_ID = G_PERSON_ID AND
6507: SOURCE_EXPENDITURE_ITEM_ID = P_SOURCE_EXPENDITURE_ITEM_ID