894:
895: begin
896: select b.period_set_name
897: into l_period_Set_name
898: from gmf_fiscal_policies a,
899: gl_ledgers b
900: where a.legal_entity_id = p_le_id
901: and b.ledger_id = a.ledger_id;
902: exception
910: BEGIN
911:
912: SELECT glp.end_date
913: INTO l_period_end_date
914: FROM GL_PERIODS GLP,GL_PERIOD_STATUSES STS, GL_SETS_OF_BOOKS SOB,GMF_FISCAL_POLICIES GFP
915: where sob.set_of_books_id = GFP.LEDGER_ID
916: AND GFP.LEGAL_ENTITY_ID = p_le_id
917: AND glp.period_set_name = sob.period_set_name
918: AND glp.period_type = sob.accounted_period_type