APPS.PSA_BC_XML_REPORT_PUB dependencies on GL_LEDGERS

Line 284: l_coaid GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;

280: x_report_query OUT NOCOPY VARCHAR2
281: ) IS
282:
283: l_api_name VARCHAR2(240);
284: l_coaid GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;
285: l_period_start_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
286: l_period_end_num GL_PERIOD_STATUSES.PERIOD_NUM%TYPE;
287: l_period_year GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506
288: l_period_year_temp GL_PERIOD_STATUSES.PERIOD_YEAR%TYPE; -- Bug 8966506

Line 307: FROM gl_ledgers

303: FROM psa_bc_report_events_gt;
304:
305: CURSOR get_coaid (p_ledgerid IN NUMBER) IS
306: SELECT chart_of_accounts_id
307: FROM gl_ledgers
308: WHERE ledger_id = p_ledgerid;
309:
310: -- Bug 8966506 : Modified get_period_num to fetch the period_year
311: CURSOR get_period_num (p_period_name IN VARCHAR2) IS

Line 348: FROM gl_ledgers

344: WHERE id_flex_num =
345: (
346: SELECT
347: chart_of_accounts_id
348: FROM gl_ledgers
349: WHERE ledger_id = p_ledger_id
350: )
351: AND id_flex_code = 'GL#'
352: AND application_id = 101

Line 3134: l_ledger_name GL_LEDGERS.name%TYPE;

3130: p_trxs IN CLOB
3131: ) IS
3132: l_api_name VARCHAR2(240);
3133: l_para_meaning_list VARCHAR2(2000);
3134: l_ledger_name GL_LEDGERS.name%TYPE;
3135: l_application_short_name VARCHAR2(8);
3136: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;
3137: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;
3138: l_offset INTEGER;

Line 3157: FROM gl_ledgers

3153: IF x_source = 'CP' THEN
3154: IF p_para_rec.ledger_id IS NOT NULL THEN
3155: SELECT name
3156: INTO l_ledger_name
3157: FROM gl_ledgers
3158: WHERE ledger_id = p_para_rec.ledger_id;
3159: END IF;
3160: IF p_para_rec.bc_funds_check_status IS NOT NULL THEN
3161: SELECT meaning