DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on HR_OPERATING_UNITS

Line 5093: NOT EXISTS(SELECT 'Y' FROM hr_operating_units WHERE organization_id = l_org_id))

5089:
5090:
5091: INSERT ALL
5092: WHEN (l_org_id IS NULL OR
5093: NOT EXISTS(SELECT 'Y' FROM hr_operating_units WHERE organization_id = l_org_id))
5094: THEN INTO PON_INTERFACE_ERRORS
5095: (
5096: INTERFACE_TYPE ,
5097: ERROR_MESSAGE_NAME,

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)))