DBA Data[Home] [Help]

APPS.PA_BUDGET_PVT dependencies on GL_LEDGERS

Line 8969: ,x_latest_encumbrance_year OUT NOCOPY gl_ledgers.Latest_Encumbrance_Year%TYPE

8965:
8966:
8967: PROCEDURE Get_Latest_BC_Year
8968: ( p_pa_project_id IN pa_projects_all.project_id%TYPE
8969: ,x_latest_encumbrance_year OUT NOCOPY gl_ledgers.Latest_Encumbrance_Year%TYPE
8970: ,x_return_status OUT NOCOPY VARCHAR2
8971: ,x_msg_count OUT NOCOPY NUMBER
8972: ,x_msg_data OUT NOCOPY VARCHAR2
8973: )

Line 8997: FROM GL_ledgers l

8993:
8994:
8995: SELECT l.Latest_Encumbrance_Year
8996: INTO x_latest_encumbrance_year
8997: FROM GL_ledgers l
8998: , pa_implementations_all i
8999: , pa_projects_all p
9000: WHERE l.LEDGER_ID = i.set_of_books_id
9001: AND i.org_id = p.org_id