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_EXPENDITURES

Line 1302: PA_EXPENDITURES EXP

1298: SELECT
1299: EXP.INCURRED_BY_PERSON_ID
1300: FROM
1301: PA_EXPENDITURE_ITEMS ITEM,
1302: PA_EXPENDITURES EXP
1303: WHERE
1304: EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID AND
1305: ITEM.SYSTEM_LINKAGE_FUNCTION IN ('OT', 'ST') AND
1306: EXP.INCURRED_BY_PERSON_ID IN

Line 1369: PA_EXPENDITURES EXP

1365: SELECT
1366: EXP.INCURRED_BY_PERSON_ID
1367: FROM
1368: PA_EXPENDITURE_ITEMS ITEM,
1369: PA_EXPENDITURES EXP
1370: WHERE
1371: EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID AND
1372: EXP.EXPENDITURE_STATUS_CODE = 'APPROVED' AND
1373: ITEM.SYSTEM_LINKAGE_FUNCTION IN ('OT', 'ST') AND

Line 1434: PA_EXPENDITURES EXP

1430: SELECT
1431: EXP.INCURRED_BY_PERSON_ID
1432: FROM
1433: PA_EXPENDITURE_ITEMS ITEM,
1434: PA_EXPENDITURES EXP
1435: WHERE
1436: EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID AND
1437: EXP.EXPENDITURE_STATUS_CODE = 'APPROVED' AND
1438: ITEM.SYSTEM_LINKAGE_FUNCTION IN ('OT', 'ST') AND

Line 1498: PA_EXPENDITURES EXP

1494: SELECT
1495: EXP.INCURRED_BY_PERSON_ID
1496: FROM
1497: PA_EXPENDITURE_ITEMS ITEM,
1498: PA_EXPENDITURES EXP
1499: WHERE
1500: EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID AND
1501: EXP.EXPENDITURE_STATUS_CODE = 'APPROVED' AND
1502: ITEM.SYSTEM_LINKAGE_FUNCTION IN ('OT', 'ST') AND

Line 1828: PA_EXPENDITURES EI

1824: EII.INTERFACE_RUN_ID,
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

Line 3128: ,pa_expenditures exp

3124: ,detail.acct_exchange_rate
3125: ,detail.base_hours
3126: from pa_compensation_details detail
3127: -- ,pa_expenditure_items ei
3128: ,pa_expenditures exp
3129: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
3130: and trunc(nvl(detail.end_date_active,p_exp_item_date))
3131: and detail.person_id = exp.incurred_by_person_id
3132: and exp.expenditure_id = x_exp_id

Line 3302: ,pa_expenditures exp

3298: ,detail.acct_exchange_rate
3299: ,detail.base_hours
3300: from pa_compensation_details detail
3301: ,pa_expenditure_items ei
3302: ,pa_expenditures exp
3303: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
3304: and trunc(nvl(detail.end_date_active,p_exp_item_date))
3305: and detail.person_id = exp.incurred_by_person_id
3306: and exp.expenditure_id = ei.expenditure_id

Line 3893: l_expenditure_id pa_expenditures_all.expenditure_id%type;

3889: */
3890:
3891: PROCEDURE process_burden IS
3892: l_exp_group pa_expenditure_groups_all.expenditure_group%type;
3893: l_expenditure_id pa_expenditures_all.expenditure_id%type;
3894: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
3895: i PLS_INTEGER;
3896: l_status VARCHAR2(100);
3897: l_msg_application VARCHAR2(10);

Line 3950: select pa_expenditures_s.nextval

3946: AND INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
3947: AND PERSON_ID = G_PERSON_ID
3948: )
3949: LOOP
3950: select pa_expenditures_s.nextval
3951: into l_expenditure_id from dual;
3952:
3953: write_log(LOG,'Calling InsertExp' );
3954:

Line 4363: l_expenditure_id pa_expenditures_all.expenditure_id%type;

4359: */
4360:
4361: PROCEDURE process_misc IS
4362: l_exp_group pa_expenditure_groups_all.expenditure_group%type;
4363: l_expenditure_id pa_expenditures_all.expenditure_id%type;
4364: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
4365: i PLS_INTEGER;
4366: l_status VARCHAR2(100);
4367: l_msg_application VARCHAR2(10);

Line 4432: select pa_expenditures_s.nextval

4428: AND PERSON_ID = G_PERSON_ID
4429: )
4430: LOOP
4431:
4432: select pa_expenditures_s.nextval
4433: into l_expenditure_id from dual;
4434:
4435: write_log(LOG,'Calling InsertExp for ' || X.organization_id || ' - ' || x.denom_currency_code );
4436:

Line 5574: PA_EXPENDITURES_ALL E,

5570: EI2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5571: WHERE EI2.EXPENDITURE_ITEM_ID IN
5572: ( SELECT EI.EXPENDITURE_ITEM_ID
5573: FROM PA_EXPENDITURE_ITEMS_ALL EI ,
5574: PA_EXPENDITURES_ALL E,
5575: PA_PAY_AUDIT AUD
5576: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5577: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5578: AND EI.EXPENDITURE_ID = E.EXPENDITURE_ID

Line 5598: PA_EXPENDITURES E,

5594: COSTING_METHOD,Ei2.PAYROLL_ACCRUAL_FLAG,Ei2.REQUEST_ID) = (SELECT
5595: NVL((-1*EI.DENOM_RAW_COST),0),
5596: G_INTERFACE_RUN_ID,'ACTUAL',NVL(EI.PAYROLL_ACCRUAL_FLAG,'N'),G_REQUEST_ID FROM
5597: PA_EXPENDITURE_ITEMS Ei,
5598: PA_EXPENDITURES E,
5599: PA_PAY_AUDIT AUD
5600: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5601: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5602: AND EI2.EXPENDITURE_ID = E.EXPENDITURE_ID

Line 5628: PA_EXPENDITURES E,

5624: /* Start changes for bug#12975007*/
5625:
5626: FOR X IN (SELECT EI2.EXPENDITURE_ITEM_ID,EI2.TRANSACTION_SOURCE,EI2.ADJUSTED_EXPENDITURE_ITEM_ID
5627: FROM PA_EXPENDITURE_ITEMS EI2 ,
5628: PA_EXPENDITURES E,
5629: PA_PAY_AUDIT AUD
5630: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5631: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5632: AND EI2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID

Line 5662: ,PA_EXPENDITURES E,

5658: EI1.EXPENDITURE_ITEM_ID=NVL(EI2.ADJUSTED_EXPENDITURE_ITEM_ID,EI2.EXPENDITURE_ITEM_ID))
5659: WHERE EI2.EXPENDITURE_ITEM_ID IN
5660: (SELECT EXPENDITURE_ITEM_ID
5661: FROM PA_EXPENDITURE_ITEMS Ei3
5662: ,PA_EXPENDITURES E,
5663: PA_PAY_AUDIT AUD
5664: WHERE EI3.EXPENDITURE_ITEM_ID IN
5665: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID
5666: CONNECT BY PRIOR TRANSFERRED_FROM_EXP_ITEM_ID=EXPENDITURE_ITEM_ID