APPS.PO_ACCOUNT_HELPER dependencies on PO_HEADERS_ALL

Line 546: FROM po_headers_all poh

542: IF (P_DIST_ID_TBL.count > 0) THEN
543: BEGIN
544: SELECT approved_flag
545: INTO l_approved_flag
546: FROM po_headers_all poh
547: WHERE poh.po_header_id = p_header_id;
548: IF l_approved_flag = 'Y' THEN
549: l_doc_type := 'MOD';
550: ELSE

Line 951: l_current_ou_id po_headers_all.org_id%TYPE;

947: l_osp_flag po_line_types_b.outside_operation_flag%TYPE;
948: l_expense_accrual_code po_system_parameters_all.EXPENSE_ACCRUAL_CODE%TYPE;
949: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
950: x_ou_id po_distributions_all.org_id%TYPE;
951: l_current_ou_id po_headers_all.org_id%TYPE;
952: l_old_code_combination_id po_distributions_all.CODE_COMBINATION_ID%TYPE;
953: l_dest_charge_account_id po_distributions_all.DEST_CHARGE_ACCOUNT_ID%TYPE;
954: l_dest_variance_account_id po_distributions_all.DEST_VARIANCE_ACCOUNT_ID%TYPE;
955: l_dest_charge_account_desc VARCHAR2(2000);

Line 1193: PO_HEADERS_ALL POH

1189: BEGIN
1190: IF NVL(p_draft_id,-1) = -1 THEN --bug 16628805
1191: SELECT NULL INTO l_dummy
1192: FROM
1193: PO_HEADERS_ALL POH
1194: WHERE POH.po_header_id = p_document_id
1195: FOR UPDATE
1196: NOWAIT;
1197: ELSE