DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 6204: FINANCIALS_SYSTEM_PARAMS_ALL F

6200: PER_ALL_PEOPLE_F P,
6201: PER_ALL_ASSIGNMENTS_F A,
6202: PER_ALL_POSITIONS S,
6203: PON_AUCTION_HEADERS_ALL AH,
6204: FINANCIALS_SYSTEM_PARAMS_ALL F
6205: WHERE U.USER_ID = PNTM.USER_ID
6206: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
6207: AND AH.AUCTION_HEADER_ID = PNTM.AUCTION_HEADER_ID
6208: AND NVL(F.ORG_ID, -9999) = NVL(AH.ORG_ID, -9999)

Line 10220: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

10216: INTO
10217: l_default_rate_type,
10218: l_default_currency_code
10219: FROM PO_SYSTEM_PARAMETERS_ALL PSP,
10220: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
10221: GL_SETS_OF_BOOKS SOB
10222: WHERE PSP.ORG_ID = FSP.ORG_ID (+)
10223: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID (+)
10224: AND PSP.ORG_ID = FND_PROFILE.VALUE('ORG_ID');