DBA Data[Home] [Help]

APPS.PSA_BC_XML_REPORT_PUB dependencies on PSA_BC_APPLICATION_V

Line 63: FROM psa_bc_application_v

59:
60: -- Get the Application Id for the Application Short Name paramater
61: IF p_application_short_name <> 'ALL' THEN
62: SELECT application_id INTO l_application_id
63: FROM psa_bc_application_v
64: WHERE application_short_name = p_application_short_name;
65: ELSE
66: l_application_id := 999999;
67: END IF;

Line 474: PSA_BC_APPLICATION_V PBA,

470: NULL CURRENT_FUNDS_AVAILABLE,
471: NULL DOCUMENT_STATUS
472: FROM
473: PSA_XLA_ACCOUNTING_ERRORS XAE,
474: PSA_BC_APPLICATION_V PBA,
475: GL_PERIOD_STATUSES PS
476: WHERE PBA.application_id = p_para_rec.application_id AND
477: XAE.ledger_id = p_para_rec.ledger_id AND
478: PS.ledger_id = p_para_rec.ledger_id AND

Line 3194: FROM psa_bc_application_v

3190: IF x_source = 'FORM' THEN
3191: IF p_para_rec.application_id IS NOT NULL THEN
3192: SELECT application_short_name
3193: INTO l_application_short_name
3194: FROM psa_bc_application_v
3195: WHERE application_id = p_para_rec.application_id;
3196: END IF;
3197:
3198: l_para_meaning_list :=