DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on FND_PROFILE

Line 51: WHERE GASNA.access_set_id = FND_PROFILE.VALUE('GL_ACCESS_SET_ID')

47: SELECT GLL.ledger_id
48: INTO gn_ledger_id
49: FROM gl_ledgers GLL
50: ,gl_access_set_norm_assign GASNA
51: WHERE GASNA.access_set_id = FND_PROFILE.VALUE('GL_ACCESS_SET_ID')
52: AND GLL.ledger_id = GASNA.ledger_id
53: AND GLL.ledger_category_code = 'PRIMARY';
54: END;
55: /*Query to get the Start date for a given Period From parameter */

Line 112: WHERE GAS.access_set_id = FND_PROFILE.value('GL_ACCESS_SET_ID'))

108: AND FSEG.flex_value_set_id = FFV.flex_value_set_id
109: AND FFS.id_flex_code = 'GL#'
110: AND GCC.chart_of_accounts_id = (SELECT GAS.chart_of_accounts_id
111: FROM gl_access_sets GAS
112: WHERE GAS.access_set_id = FND_PROFILE.value('GL_ACCESS_SET_ID'))
113: AND FFV.flex_value = p_value;
114: ELSE
115: /* Query to get the Descriptions of the Attribute values. */
116: SELECT FFV.description