APPS.PON_OPEN_INTERFACE_PVT dependencies on HR_GENERAL

Line 5555: AND NVL(L.BUSINESS_GROUP_ID, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) ) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99)

5551:
5552: WHEN ((neg_header_record_data.bill_to_location_id IS NOT NULL AND neg_header_record_data.bill_to_location_id <> -1
5553: AND NOT EXISTS(SELECT 'Y' from HR_LOCATIONS_ALL L
5554: where L.LOCATION_ID = neg_header_record_data.bill_to_location_id
5555: AND NVL(L.BUSINESS_GROUP_ID, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) ) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99)
5556: AND SYSDATE < NVL(L.INACTIVE_DATE, SYSDATE + 1) AND NVL(L.BILL_TO_SITE_FLAG,'N') = 'Y'))
5557: OR (p_is_amendment<>'Y' AND neg_header_record_data.bill_to_location_id IS NULL))
5558: THEN INTO PON_INTERFACE_ERRORS
5559: (

Line 6716: AND NVL(L.BUSINESS_GROUP_ID, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) ) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99)

6712: INTO neg_header_record_data.bill_to_location_id
6713: from HR_LOCATIONS_ALL L
6714: where L.LOCATION_CODE = neg_header_record_data.bill_to_location_code
6715: AND neg_header_record_data.bill_to_location_code IS NOT NULL
6716: AND NVL(L.BUSINESS_GROUP_ID, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) ) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99)
6717: AND SYSDATE < NVL(L.INACTIVE_DATE, SYSDATE + 1) AND NVL(L.BILL_TO_SITE_FLAG,'N') = 'Y';
6718: EXCEPTION
6719: WHEN No_Data_Found THEN
6720: NULL;