DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on GL_PERIOD_STATUSES

Line 501: FROM gl_period_statuses

497: BEGIN
498: psa_utils.debug_other_string(g_state_level,l_path_name, 'Check if GL period is open');
499: SELECT start_date
500: INTO l_accounting_date
501: FROM gl_period_statuses
502: WHERE application_id = 101
503: AND ledger_id = p_ledger_id
504: AND orphan_event_rec.ACCOUNTING_DATE BETWEEN start_date AND end_date
505: AND closing_status='O';

Line 513: FROM gl_period_statuses

509: BEGIN
510: psa_utils.debug_other_string(g_state_level,l_path_name, 'Get the latest open GL period');
511: SELECT max(start_date)
512: INTO l_accounting_date
513: FROM gl_period_statuses
514: WHERE application_id = 101
515: AND ledger_id = p_ledger_id
516: AND closing_status ='O';
517: EXCEPTION

Line 1717: gl_period_statuses PER,

1713: po_line_locations PLL,
1714: po_headers PH,
1715: rcv_transactions RTXN,
1716: rcv_shipment_lines RSL,
1717: gl_period_statuses PER,
1718: po_vendors V,
1719: ap_system_parameters SP
1720: WHERE D.invoice_id = I.invoice_id
1721: AND D.invoice_line_number = L.line_number