DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 7350: FINANCIALS_SYSTEM_PARAMS_ALL F

7346: PER_ALL_PEOPLE_F P,
7347: PER_ALL_ASSIGNMENTS_F A,
7348: PER_ALL_POSITIONS S,
7349: PON_AUCTION_HEADERS_ALL AH,
7350: FINANCIALS_SYSTEM_PARAMS_ALL F
7351: WHERE U.USER_ID = PNTM.USER_ID
7352: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
7353: AND AH.AUCTION_HEADER_ID = PNTM.AUCTION_HEADER_ID
7354: AND NVL(F.ORG_ID, -9999) = NVL(AH.ORG_ID, -9999)

Line 11559: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

11555: INTO
11556: l_default_rate_type,
11557: l_default_currency_code
11558: FROM PO_SYSTEM_PARAMETERS_ALL PSP,
11559: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
11560: GL_SETS_OF_BOOKS SOB
11561: WHERE PSP.ORG_ID = FSP.ORG_ID (+)
11562: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID (+)
11563: AND PSP.ORG_ID = FND_PROFILE.VALUE('ORG_ID');