DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2751: financials_system_params_all fp,

2747: p_purch_enc_type_id,
2748: p_receipt_acc_days,
2749: p_gl_date_from_receipt_flag
2750: FROM ap_system_parameters_all sp,
2751: financials_system_params_all fp,
2752: gl_sets_of_books gls
2753: WHERE sp.org_id = p_org_id
2754: AND fp.org_id = sp.org_id
2755: AND sp.set_of_books_id = gls.set_of_books_id;

Line 9811: FINANCIALS_SYSTEM_PARAMS_ALL FSP

9807: WHERE AI.FORCE_REVALIDATION_FLAG = ''Y''
9808: UNION ALL
9809: SELECT 1
9810: FROM AP_INVOICE_DISTRIBUTIONS_ALL D,
9811: FINANCIALS_SYSTEM_PARAMS_ALL FSP
9812: WHERE D.INVOICE_ID = AI.INVOICE_ID
9813: AND FSP.ORG_ID = AI.ORG_ID
9814: AND FSP.SET_OF_BOOKS_ID = AI.SET_OF_BOOKS_ID
9815: AND (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,''N'') = ''Y'' AND NVL(D.MATCH_STATUS_FLAG,''N'') <> ''A'' OR

Line 9820: FINANCIALS_SYSTEM_PARAMS_ALL FSP

9816: (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,''N'') = ''N'' AND NVL(D.MATCH_STATUS_FLAG,''N'') NOT IN (''A'',''T'')))
9817: UNION ALL
9818: SELECT 1
9819: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D,
9820: FINANCIALS_SYSTEM_PARAMS_ALL FSP
9821: WHERE D.INVOICE_ID = AI.INVOICE_ID
9822: AND FSP.ORG_ID = AI.ORG_ID
9823: AND FSP.SET_OF_BOOKS_ID = AI.SET_OF_BOOKS_ID
9824: AND (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,''N'') = ''Y'' AND NVL(D.MATCH_STATUS_FLAG,''N'') <> ''A'' OR

Line 11245: financials_system_params_all fp,

11241: fp.org_id org_id,
11242: 5 System_User,
11243: fnd_global.user_id User_Id
11244: FROM ap_system_parameters_all sp,
11245: financials_system_params_all fp,
11246: gl_sets_of_books gls,
11247: Mo_Glob_Org_Access_Tmp mo
11248: WHERE sp.set_of_books_id = gls.set_of_books_id
11249: AND sp.org_id = fp.org_id