APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on GL_PERIOD_STATUSES

Line 4419: l_period_name gl_period_statuses.period_name%TYPE;

4415: l_module_version VARCHAR2(1);
4416: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
4417: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
4418: l_org_id NUMBER;
4419: l_period_name gl_period_statuses.period_name%TYPE;
4420: l_auction_status pon_auction_headers_all.AUCTION_STATUS%TYPE;
4421: l_document_num pon_auction_headers_all.document_number%TYPE;
4422: BEGIN
4423:

Line 4514: FROM gl_period_statuses

4510: IF (p_transaction_type_code = G_EMD_REFUND) THEN
4511: BEGIN
4512: SELECT period_name
4513: INTO l_period_name
4514: FROM gl_period_statuses
4515: WHERE application_id = 200
4516: AND set_of_books_id = ARP_GLOBAL.sysparam.set_of_books_id
4517: AND trunc(p_emd_transaction_rec.transaction_date)
4518: between start_date and END_date