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_OUTPUT_TAX dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 534: from PA_CUST_REV_DIST_LINES_ALL a,

530:
531: CURSOR c_reversal_rdl (p_exp_item_id number,
532: p_line number) IS
533: select b.expenditure_item_id, b.line_num
534: from PA_CUST_REV_DIST_LINES_ALL a,
535: PA_CUST_REV_DIST_LINES_ALL b
536: where a.expenditure_item_id = p_exp_item_id
537: and a.line_num = p_line
538: and a.line_num_reversed is not null

Line 535: PA_CUST_REV_DIST_LINES_ALL b

531: CURSOR c_reversal_rdl (p_exp_item_id number,
532: p_line number) IS
533: select b.expenditure_item_id, b.line_num
534: from PA_CUST_REV_DIST_LINES_ALL a,
535: PA_CUST_REV_DIST_LINES_ALL b
536: where a.expenditure_item_id = p_exp_item_id
537: and a.line_num = p_line
538: and a.line_num_reversed is not null
539: and a.expenditure_item_id = b.expenditure_item_id

Line 551: PA_CUST_REV_DIST_LINES_ALL b

547: CURSOR c_reversal_ei (p_exp_item_id number) IS
548: select b.expenditure_item_id, max(b.line_num ) line_num
549: from pa_expenditure_items_all e1,
550: pa_expenditure_items_all e2,
551: PA_CUST_REV_DIST_LINES_ALL b
552: where e1.expenditure_item_id = p_exp_item_id
553: and e1.adjusted_expenditure_item_id is not null
554: and e1.adjusted_expenditure_item_id = e2.expenditure_item_id
555: and e2.expenditure_item_id = b.expenditure_item_id

Line 584: FROM PA_CUST_REV_DIST_LINES_ALL

580: output_tax_classification_code,
581: output_tax_exempt_flag,
582: output_tax_exempt_reason_code,
583: output_tax_exempt_number
584: FROM PA_CUST_REV_DIST_LINES_ALL
585: WHERE EXPENDITURE_ITEM_ID = p_exp_item_id
586: AND LINE_NUM = p_line;
587:
588: l_exp_item_id NUMBER := NULL;

Line 1182: Update PA_CUST_REV_DIST_LINES_ALL

1178: /* Added for Payroll Billing ER #11847630 - Start */
1179: end if ; -- l_reversal_flag if statement
1180: /* Added for Payroll Billing ER #11847630 - End */
1181:
1182: Update PA_CUST_REV_DIST_LINES_ALL
1183: Set
1184: -- invoice_eligible_flag = tmp_invoice_eligible_flag, for bug 2649243, 2645634
1185: -- output_vat_tax_id = l_Output_vat_tax_id, --commented by hsiu
1186: output_tax_classification_code = l_output_tax_code,