DBA Data[Home] [Help]

APPS.FUN_REPORT_PVT dependencies on GL_LEDGERS

Line 140: GL_LEDGERS GL,

136: FND_LOOKUP_VALUES LKUP,
137: HZ_PARTIES INIT_P,
138: FUN_TRX_TYPES_VL FTTVL,
139: FND_CURRENCIES_VL FCV,
140: GL_LEDGERS GL,
141: FUN_TRX_BATCHES FTB_ORIG,
142: FUN_TRX_BATCHES FTB_REV,
143: GL_LEDGERS GL1,
144: FUN_TRX_HEADERS FTH_ORIG,

Line 143: GL_LEDGERS GL1,

139: FND_CURRENCIES_VL FCV,
140: GL_LEDGERS GL,
141: FUN_TRX_BATCHES FTB_ORIG,
142: FUN_TRX_BATCHES FTB_REV,
143: GL_LEDGERS GL1,
144: FUN_TRX_HEADERS FTH_ORIG,
145: FUN_TRX_HEADERS FTH_REV,
146: HZ_PARTIES RECI_P,
147: XLE_ENTITY_PROFILES XLE1,

Line 463: GL_LEDGERS GL0,

459: FUN_TRX_TYPES_VL FTTVL,
460: GL_PERIODS GLP,
461: FND_CURRENCIES_VL FCV,
462: FUN_TRX_LINES FTL,
463: GL_LEDGERS GL0,
464: GL_LEDGERS GL1,
465: XLE_ENTITY_PROFILES XLE,
466: XLE_ENTITY_PROFILES XLE1,
467: FND_GRANTS FG,

Line 464: GL_LEDGERS GL1,

460: GL_PERIODS GLP,
461: FND_CURRENCIES_VL FCV,
462: FUN_TRX_LINES FTL,
463: GL_LEDGERS GL0,
464: GL_LEDGERS GL1,
465: XLE_ENTITY_PROFILES XLE,
466: XLE_ENTITY_PROFILES XLE1,
467: FND_GRANTS FG,
468: FND_OBJECT_INSTANCE_SETS FOIS,

Line 803: GL_LEDGERS GL,

799: FND_LOOKUP_VALUES LKUP,
800: HZ_PARTIES INIT_P,
801: FUN_TRX_TYPES_VL FTTVL,
802: FND_CURRENCIES_VL FCV,
803: GL_LEDGERS GL,
804: FUN_TRX_BATCHES FTB_ORIG,
805: FUN_TRX_BATCHES FTB_REV,
806: GL_LEDGERS GL1,
807: FUN_TRX_HEADERS FTH_ORIG,

Line 806: GL_LEDGERS GL1,

802: FND_CURRENCIES_VL FCV,
803: GL_LEDGERS GL,
804: FUN_TRX_BATCHES FTB_ORIG,
805: FUN_TRX_BATCHES FTB_REV,
806: GL_LEDGERS GL1,
807: FUN_TRX_HEADERS FTH_ORIG,
808: FUN_TRX_HEADERS FTH_REV,
809: HZ_PARTIES RECI_P,
810: XLE_ENTITY_PROFILES XLE1,

Line 1109: GL_LEDGERS GL0,

1105: FUN_TRX_TYPES_VL FTTVL,
1106: GL_PERIODS GLP,
1107: FND_CURRENCIES_VL FCV,
1108: FUN_TRX_LINES FTL,
1109: GL_LEDGERS GL0,
1110: GL_LEDGERS GL1,
1111: XLE_ENTITY_PROFILES XLE,
1112: XLE_ENTITY_PROFILES XLE1,
1113: FND_GRANTS FG,

Line 1110: GL_LEDGERS GL1,

1106: GL_PERIODS GLP,
1107: FND_CURRENCIES_VL FCV,
1108: FUN_TRX_LINES FTL,
1109: GL_LEDGERS GL0,
1110: GL_LEDGERS GL1,
1111: XLE_ENTITY_PROFILES XLE,
1112: XLE_ENTITY_PROFILES XLE1,
1113: FND_GRANTS FG,
1114: FND_OBJECT_INSTANCE_SETS FOIS

Line 1639: l_transact_ledger GL_LEDGERS.name%TYPE;

1635: l_trx_status FND_LOOKUPS.meaning%TYPE;
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1638: l_currency FND_CURRENCIES_VL.name%TYPE;
1639: l_transact_ledger GL_LEDGERS.name%TYPE;
1640: l_trading_ledger GL_LEDGERS.name%TYPE;
1641: l_encoding VARCHAR2(20);
1642: l_offset INTEGER;
1643: BEGIN

Line 1640: l_trading_ledger GL_LEDGERS.name%TYPE;

1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1638: l_currency FND_CURRENCIES_VL.name%TYPE;
1639: l_transact_ledger GL_LEDGERS.name%TYPE;
1640: l_trading_ledger GL_LEDGERS.name%TYPE;
1641: l_encoding VARCHAR2(20);
1642: l_offset INTEGER;
1643: BEGIN
1644: l_api_name := 'construct_account_output';

Line 1700: FROM gl_ledgers

1696: END IF;
1697: IF p_para_rec.transact_ledger IS NOT NULL THEN
1698: SELECT name
1699: INTO l_transact_ledger
1700: FROM gl_ledgers
1701: WHERE ledger_id = p_para_rec.transact_ledger;
1702: END IF;
1703: IF p_para_rec.trading_ledger IS NOT NULL THEN
1704: SELECT name

Line 1706: FROM gl_ledgers

1702: END IF;
1703: IF p_para_rec.trading_ledger IS NOT NULL THEN
1704: SELECT name
1705: INTO l_trading_ledger
1706: FROM gl_ledgers
1707: WHERE ledger_id = p_para_rec.trading_ledger;
1708: END IF;
1709: EXCEPTION
1710: WHEN OTHERS THEN