DBA Data[Home] [Help]

APPS.AP_PMT_VALIDATIONS_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 85: FROM ap_system_parameters_all asp,

81: FROM iby_fd_payments_v pmts
82: WHERE pmts.completed_pmts_group_id = p_completed_pmts_group_id
83: AND NOT EXISTS
84: (SELECT 1
85: FROM ap_system_parameters_all asp,
86: gl_code_combinations gc,
87: gl_sets_of_books gsob,
88: fnd_currencies fndc
89: WHERE gc.code_combination_id(+) = asp.interest_code_combination_id

Line 416: ap_System_Parameters_All Asp

412: AND atd.invoice_id = si.invoice_id
413: and not exists
414: (SELECT 1
415: FROM gl_Period_Statuses gps,
416: ap_System_Parameters_All Asp
417: WHERE gps.Application_Id = 200
418: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
419: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
420: AND atd.accounting_date BETWEEN Trunc(gps.Start_Date)