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 457: PSA_BC_APPLICATION_V PBA,

453: 'X' ERROR_SOURCE,
454: NULL CURRENT_FUNDS_AVAILABLE,
455: NULL DOCUMENT_STATUS
456: FROM PSA_BC_ACCOUNTING_ERRORS PAE,
457: PSA_BC_APPLICATION_V PBA,
458: GL_PERIOD_STATUSES PS
459: WHERE PBA.application_id = p_para_rec.application_id AND
460: PAE.ledger_id = p_para_rec.ledger_id AND
461: PS.ledger_id = p_para_rec.ledger_id AND

Line 3107: FROM psa_bc_application_v

3103: IF x_source = 'FORM' THEN
3104: IF p_para_rec.application_id IS NOT NULL THEN
3105: SELECT application_short_name
3106: INTO l_application_short_name
3107: FROM psa_bc_application_v
3108: WHERE application_id = p_para_rec.application_id;
3109: END IF;
3110:
3111: l_para_meaning_list :=