APPS.PAAPIMP_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 890: FROM pa_expenditure_items_all ei

886: WHERE DIST.pa_addition_flag IN ('O','W')
887: AND DIST.posted_flag||''= 'Y'
888: AND DIST.project_id >0
889: AND NOT EXISTS ( SELECT 'X'
890: FROM pa_expenditure_items_all ei
891: WHERE ei.document_header_id = dist.invoice_id /*Added for bug 6327185 */
892: AND ei.document_distribution_id = dist.invoice_distribution_id
893: AND ei.transaction_source in ('AP INVOICE','AP VARIANCE','AP NRTAX','AP EXPENSE')) ;
894:

Line 909: FROM pa_expenditure_items_all ei

905: FROM ap_payment_history_all hist
906: WHERE hist.payment_history_id = dist.payment_history_id
907: AND hist.posted_flag = 'Y')
908: AND NOT EXISTS ( SELECT 'X'
909: FROM pa_expenditure_items_all ei
910: WHERE ei.document_distribution_id = dist.invoice_distribution_id
911: AND ei.document_payment_id = dist.invoice_payment_id
912: AND ei.transaction_source = 'AP DISCOUNTS') ;
913:

Line 927: FROM pa_expenditure_items_all ei

923: SET rcv_sub.pa_addition_flag = 'N'
924: ,rcv_sub.request_id = G_REQUEST_ID
925: WHERE rcv_sub.pa_addition_flag = 'O'
926: AND NOT EXISTS (SELECT 'X'
927: FROM pa_expenditure_items_all ei
928: WHERE ei.document_distribution_id = rcv_sub.rcv_transaction_id);
929:
930: If g_body_debug_mode = 'Y' Then
931: write_log(LOG, 'Number of rcv txn cleaned up from O:' || to_char(SQL%ROWCOUNT));

Line 954: FROM pa_expenditure_items_all ei

950: FROM ap_payment_history_all hist
951: WHERE hist.payment_history_id = dist.payment_history_id
952: AND hist.posted_flag = 'Y')
953: AND NOT EXISTS ( SELECT 'X'
954: FROM pa_expenditure_items_all ei
955: WHERE ei.document_distribution_id = dist.invoice_distribution_id
956: AND ei.document_payment_id = dist.invoice_payment_id
957: AND ei.transaction_source = 'AP INVOICE') ;
958:

Line 968: FROM pa_expenditure_items_all ei

964: SET dist.pa_addition_flag = 'N',
965: request_id = G_REQUEST_ID
966: WHERE dist.pa_addition_flag = 'O'
967: AND NOT EXISTS ( SELECT 'X'
968: FROM pa_expenditure_items_all ei
969: WHERE ei.document_distribution_id = dist.invoice_distribution_id
970: AND ei.document_payment_id = dist.prepay_app_dist_id
971: AND ei.transaction_source in ('AP INVOICE','AP VARIANCE','AP NRTAX','AP EXPENSE')) ;
972:

Line 4155: UPDATE pa_expenditure_items_all exp1

4151:
4152: /* Bug 5440548 fix to update expenditure data with historical flag for historical AP data */
4153: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
4154:
4155: UPDATE pa_expenditure_items_all exp1
4156: SET historical_flag = 'Y'
4157: WHERE document_header_id = l_sys_ref2_tbl(i)
4158: AND document_distribution_id = l_sys_ref5_tbl(i)
4159: AND exists (select 'exist'

Line 11064: pa_expenditure_items_all ei

11060: ,ei.document_payment_id
11061: ,ei.document_line_number
11062: ,cdl.system_reference5 cdl_sys_ref5 --to get the rcv_sub_leger_id of parent Rcv txn
11063: FROM pa_cost_distribution_lines_all cdl,
11064: pa_expenditure_items_all ei
11065: WHERE cdl.expenditure_item_id (+) = ei.expenditure_item_id
11066: AND nvl(cdl.reversed_flag, 'N') = 'N'
11067: AND ei.document_distribution_id = p_document_distribution_id /*Added this for 6945767 */
11068: AND ei.system_linkage_function in ('VI','ER')

Line 11296: FROM pa_expenditure_items_all ei

11292: write_log(LOG, 'Selecting the count of adjusted expenditures');
11293:
11294: SELECT sum(decode(ei.net_zero_adjustment_flag,'N',1,0)),count(*)
11295: INTO l_not_reversed_cnt,l_all_reversed_cnt
11296: FROM pa_expenditure_items_all ei
11297: /*Added this for 6945767 */
11298: WHERE ei.document_distribution_id = p_document_distribution_id
11299: AND ei.document_header_id = p_document_header_id /*Added this for 6945767 */
11300: AND (( p_record_type = 'AP_INVOICE'