APPS.AP_INVOICES_UTILITY_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 557: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;

553: dist_var_hold NUMBER;
554: match_flag_cnt NUMBER;
555: self_match_flag_cnt NUMBER; --Bug8223290
556: l_validated_cnt NUMBER;
557: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
558: l_force_revalidation_flag VARCHAR2(1);
559: --Bugfix: 3854385
560: l_dist_variance VARCHAR2(20) := 'DIST VARIANCE';
561: l_line_variance VARCHAR2(20) := 'LINE VARIANCE';

Line 624: financials_system_params_all fsp

620: l_org_id,
621: l_force_revalidation_flag,
622: l_net_of_retainage_flag --9503673
623: FROM ap_invoices_all ai,
624: financials_system_params_all fsp
625: WHERE ai.invoice_id = l_invoice_id
626: AND ai.set_of_books_id = fsp.set_of_books_id
627: AND ai.org_id = fsp.org_id;
628:

Line 1579: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;

1575: l_purch_encumbrance_flag VARCHAR2(1) := '';
1576: l_encumbered_flag VARCHAR2(1) := '';
1577: l_distribution_count number := 0;
1578: l_encumbered_count number := 0;
1579: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
1580:
1581: CURSOR encumbrance_flag_cursor is
1582: SELECT nvl(encumbered_flag,'N')
1583: FROM ap_invoice_distributions

Line 1600: financials_system_params_all fsp

1596:
1597: SELECT NVL(fsp.purch_encumbrance_flag,'N'), ai.org_id
1598: INTO l_purch_encumbrance_flag, l_org_id
1599: FROM ap_invoices_all ai,
1600: financials_system_params_all fsp
1601: WHERE ai.invoice_id = l_invoice_id
1602: AND ai.org_id = fsp.org_id;
1603:
1604: IF (l_purch_encumbrance_flag = 'N') THEN