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_ADJUSTMENTS dependencies on PA_TRANSACTION_SOURCES

Line 199: FROM pa_transaction_sources ts ,

195: -- then we already have the reversing item's
196: -- orig_transaction_reference, otherwise get the
197: -- reversing item's orig_transaction_reference
198: DECODE(X_reversed_orig_txn_reference,NULL, i.orig_transaction_reference, X_reversed_orig_txn_reference) orig_txn_reference
199: FROM pa_transaction_sources ts ,
200: pa_expenditure_items i ,
201: pa_expenditures e
202: WHERE i.expenditure_item_date = X_item_date
203: AND i.task_id = X_task_id

Line 1285: , pa_transaction_sources txs

1281: , trx_source_burden
1282: , system_linkage
1283: FROM
1284: pa_expenditure_items_all ei
1285: , pa_transaction_sources txs
1286: WHERE
1287: ei.transaction_source = txs.transaction_source(+)
1288: AND ei.expenditure_item_id = ItemsIdTab(i);
1289:

Line 1457: , pa_transaction_sources txs

1453: trx_source_burden,
1454: system_linkage
1455: FROM
1456: pa_expenditure_items_all ei
1457: , pa_transaction_sources txs
1458: WHERE
1459: ei.transaction_source = txs.transaction_source(+)
1460: AND ei.expenditure_item_id = ItemsIdTab(i);
1461:

Line 1670: , pa_transaction_sources txs

1666: , trx_source_burden
1667: , system_linkage
1668: FROM
1669: pa_expenditure_items_all ei
1670: , pa_transaction_sources txs
1671: WHERE
1672: ei.transaction_source = txs.transaction_source(+)
1673: AND ei.expenditure_item_id = ItemsIdTab(i);
1674:

Line 1847: , pa_transaction_sources txs

1843: trx_source_burden,
1844: system_linkage
1845: FROM
1846: pa_expenditure_items_all ei
1847: , pa_transaction_sources txs
1848: WHERE
1849: ei.transaction_source = txs.transaction_source(+)
1850: AND ei.expenditure_item_id = ItemsIdTab(i);
1851:

Line 2250: pa_transaction_sources tr

2246: l_projfunc_cost_rate_type,
2247: l_projfunc_cost_exchg_rate,
2248: l_work_type_id
2249: FROM pa_expenditure_items_all ei,
2250: pa_transaction_sources tr
2251: WHERE tr.transaction_source(+) = ei.transaction_source
2252: AND expenditure_item_id = p_exp_item_id;
2253:
2254: IF P_DEBUG_MODE THEN

Line 2366: ,pa_transaction_sources tr

2362: ,l_gl_accounted_flag
2363: ,l_proj_type_class_code
2364: ,l_old_billability
2365: FROM pa_expenditure_items_all EI
2366: ,pa_transaction_sources tr
2367: ,pa_project_types_all pt /** Bug fix 2262118 **/
2368: ,pa_projects_all pp
2369: -- ,pa_tasks t /* Bug 3457922 */
2370: WHERE tr.transaction_source(+) = ei.transaction_source

Line 2686: pa_transaction_sources tr

2682: l_projfunc_cost_rate_type,
2683: l_projfunc_cost_exchg_rate,
2684: l_work_type_id
2685: FROM pa_expenditure_items_all ei,
2686: pa_transaction_sources tr
2687: WHERE tr.transaction_source = ei.transaction_source
2688: AND expenditure_item_id = ItemsIdTab(i) ;
2689:
2690: -- Added to IF condition below: p_system_linkage_function <> 'VI' to resolve bug # 1764279

Line 2839: pa_transaction_sources tr

2835: l_projfunc_cost_rate_type,
2836: l_projfunc_cost_exchg_rate,
2837: l_work_type_id
2838: FROM pa_expenditure_items_all ei,
2839: pa_transaction_sources tr
2840: WHERE tr.transaction_source = ei.transaction_source
2841: AND expenditure_item_id = AdjustsIdTab(i) ;
2842:
2843: IF p_gl_accounted_flag = 'Y' THEN

Line 3712: , pa_transaction_sources ts

3708: FROM
3709: pa_expenditures_all e
3710: , pa_expenditure_items_all ei
3711: , pa_expenditure_items_all ei2
3712: , pa_transaction_sources ts
3713: , pa_expenditure_comments ec
3714: /* R12 changes - Removed table pa_cost_distribution_lines */
3715: WHERE
3716: e.expenditure_id = ei.expenditure_id

Line 5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;

5555: l_application_short_name varchar2(30);
5556: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5557: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;
5563: l_acct_currency_code PA_EXPENDITURE_ITEMS_ALL.ACCT_CURRENCY_CODE%TYPE;

Line 5570: l_transaction_source_cache PA_TRANSACTION_SOURCES.TRANSACTION_SOURCE%TYPE := 'NULL'; /* Bug 5441891 */

5566: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
5567: l_adjust_allowed BOOLEAN := TRUE;
5568: l_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE; /* Bug 5436420 */
5569: l_project_id_cache PA_PROJECTS_ALL.PROJECT_ID%TYPE := -1; /* Bug 5441891 */
5570: l_transaction_source_cache PA_TRANSACTION_SOURCES.TRANSACTION_SOURCE%TYPE := 'NULL'; /* Bug 5441891 */
5571: l_commit_count NUMBER := 0; /* Bug 5501593 */
5572: /* R12 Changes - End */
5573:
5574: /*rkuttiya added for 12.2 Payroll Integration Expenditure Adjustments */

Line 6420: FROM pa_transaction_sources tr

6416: SELECT tr.allow_adjustments_flag
6417: , tr.gl_accounted_flag
6418: INTO l_allow_adjustments_flag
6419: , l_gl_accounted
6420: FROM pa_transaction_sources tr
6421: WHERE tr.transaction_source = l_transaction_source;
6422: l_transaction_source_cache := l_transaction_source;
6423: END IF;
6424: END IF;

Line 9452: FROM pa_transaction_sources

9448: l_predefined_flag VARCHAR2(1);
9449:
9450: CURSOR allow_adjustment IS
9451: SELECT allow_adjustments_flag, predefined_flag
9452: FROM pa_transaction_sources
9453: WHERE transaction_source = p_transaction_source;
9454:
9455: CURSOR sst_adjustment IS
9456: SELECT net_zero_adjustment_flag_1,

Line 9650: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;

9646: , p_ei_date IN DATE default NULL /*Bugfix:2798742 */
9647: ) RETURN VARCHAR2 IS
9648:
9649: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9650: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9651: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9652: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9653: l_job_id pa_expenditure_items_all.job_id%TYPE;
9654: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;

Line 9651: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */

9647: ) RETURN VARCHAR2 IS
9648:
9649: l_return_currency_code pa_expenditure_items_all.denom_currency_code%type;
9650: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9651: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9652: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9653: l_job_id pa_expenditure_items_all.job_id%TYPE;
9654: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9655: l_cost_rate pa_bill_rates_all.rate%TYPE;

Line 9679: FROM pa_transaction_sources

9675: l_costed_flag := 'N';/* added bug 3142879 */
9676: ELSE
9677: SELECT gl_accounted_flag, costed_flag
9678: INTO l_gl_accounted_flag, l_costed_flag /* added costed flag bug 3142879 */
9679: FROM pa_transaction_sources
9680: WHERE transaction_source = p_transaction_source;
9681: END IF;
9682:
9683: /* Get the cost_rate_flag */