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_sla_uptake_prod VARCHAR2(1);
288: l_gl_balancing_segment NUMBER;

Line 294: FROM gl_ledgers

290: l_meaning VARCHAR2(240);
291:
292: CURSOR get_coaid (p_ledgerid IN NUMBER) IS
293: SELECT chart_of_accounts_id
294: FROM gl_ledgers
295: WHERE ledger_id = p_ledgerid;
296:
297: CURSOR get_period_num (p_period_name IN VARCHAR2) IS
298: SELECT period_num

Line 333: FROM gl_ledgers

329: WHERE id_flex_num =
330: (
331: SELECT
332: chart_of_accounts_id
333: FROM gl_ledgers
334: WHERE ledger_id = p_ledger_id
335: )
336: AND id_flex_code = 'GL#'
337: AND application_id = 101

Line 3047: l_ledger_name GL_LEDGERS.name%TYPE;

3043: p_trxs IN CLOB
3044: ) IS
3045: l_api_name VARCHAR2(240);
3046: l_para_meaning_list VARCHAR2(2000);
3047: l_ledger_name GL_LEDGERS.name%TYPE;
3048: l_application_short_name VARCHAR2(8);
3049: l_funds_check_status PSA_LOOKUP_CODES.meaning%TYPE;
3050: l_funds_check_order_by PSA_LOOKUP_CODES.meaning%TYPE;
3051: l_offset INTEGER;

Line 3070: FROM gl_ledgers

3066: IF x_source = 'CP' THEN
3067: IF p_para_rec.ledger_id IS NOT NULL THEN
3068: SELECT name
3069: INTO l_ledger_name
3070: FROM gl_ledgers
3071: WHERE ledger_id = p_para_rec.ledger_id;
3072: END IF;
3073: IF p_para_rec.bc_funds_check_status IS NOT NULL THEN
3074: SELECT meaning