DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on GL_SETS_OF_BOOKS

Line 6130: AND NOT EXISTS (SELECT 'Y' FROM hr_operating_units org,gl_sets_of_books sob

6126: l_cp_login_id)
6127: WHEN( (p_is_amendment <> 'Y' AND
6128: neg_header_record_data.currency_code IS NULL)
6129: or (neg_header_record_data.currency_code IS NOT NULL
6130: AND NOT EXISTS (SELECT 'Y' FROM hr_operating_units org,gl_sets_of_books sob
6131: WHERE org.organization_id = neg_header_record_data.org_id
6132: AND org.SET_OF_BOOKS_ID = sob.SET_OF_BOOKS_ID
6133: AND sob.currency_code = neg_header_record_data.currency_code
6134: AND neg_header_record_data.currency_code IS NOT NULL)))

Line 6739: , gl_sets_of_books sob

6735: from
6736: po_system_parameters_all psp
6737: , hr_all_organization_units_tl haou
6738: , financials_system_params_all fsp
6739: , gl_sets_of_books sob
6740: , hr_locations_all_tl bill_to
6741: , hr_locations_all_tl ship_to
6742: , ( SELECT po.org_id, po.security_level_code, pon.doctype_id
6743: FROM po_document_types_all po, pon_auc_doctypes pon