DBA Data[Home] [Help]

APPS.LNS_LOAN_HEADER_ALL_PKG dependencies on LNS_LOAN_NUMBER_S

Line 244: ,DECODE( X_LOAN_NUMBER, FND_API.G_MISS_CHAR, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), NULL, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), X_LOAN_NUMBER )

240: ,LNS_UTILITY_PUB.PROGRAM_ID
241: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
242: ,LNS_UTILITY_PUB.REQUEST_ID
243: ,DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
244: ,DECODE( X_LOAN_NUMBER, FND_API.G_MISS_CHAR, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), NULL, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), X_LOAN_NUMBER )
245: ,DECODE( X_LOAN_APPLICATION_DATE, FND_API.G_MISS_DATE, NULL, X_LOAN_APPLICATION_DATE )
246: ,DECODE( X_END_DATE, FND_API.G_MISS_DATE, NULL, X_END_DATE )
247: ,DECODE( X_INITIAL_LOAN_BALANCE, FND_API.G_MISS_NUM, NULL, X_INITIAL_LOAN_BALANCE )
248: ,DECODE( X_LAST_PAYMENT_DATE, FND_API.G_MISS_DATE, NULL, X_LAST_PAYMENT_DATE )