APPS.PA_BGT_BASELINE_PKG dependencies on GL_PERIOD_STATUSES

Line 759: gl_period_STATUSES gl,

755: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
756: from pa_expenditure_items_all ei,
757: -- pa_expenditures_all exp, -- 7531681
758: pa_cost_distribution_lines_all cdl,
759: gl_period_STATUSES gl,
760: pa_tasks pt
761: where cdl.project_id = p_project_id
762: and pt.task_id = ei.task_id
763: -- and ei.expenditure_id = exp.expenditure_id -- 7531681

Line 956: gl_period_STATUSES gl,

952: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
953: from pa_expenditure_items_all ei,
954: -- pa_expenditures_all exp, -- 7531681
955: pa_cost_distribution_lines_all cdl,
956: gl_period_STATUSES gl,
957: pa_tasks pt
958: where cdl.project_id = p_project_id
959: and pt.task_id = ei.task_id
960: -- and ei.expenditure_id = exp.expenditure_id -- 7531681

Line 1651: from gl_period_statuses gl

1647: ,l_pktReference2Tab(i)
1648: ,l_pktReference3Tab(i)
1649: -- R12 Funds Management Uptake
1650: ,l_BurMethodcodeTab(i)
1651: from gl_period_statuses gl
1652: where l_DocTypTab(i) in ('CC_C_CO', 'CC_P_CO')
1653: --and l_GlDateTab(i) = gl.end_date
1654: and trunc(l_GlDateTab(i)) between trunc(gl.start_date) and trunc(gl.end_date)
1655: and gl.application_id = 101

Line 1903: from gl_period_statuses gl

1899: ,l_pktReference2Tab(k)
1900: ,l_pktReference3Tab(k)
1901: -- R12 Funds Management Uptake
1902: ,l_BurMethodcodeTab(k)
1903: from gl_period_statuses gl
1904: where l_DocTypTab(k) in ('AP','PO','REQ','CC_C_PAY','CC_P_PAY')
1905: --and l_GlDateTab(k) = gl.end_date
1906: and trunc(l_GlDateTab(k)) between trunc(gl.start_date) and trunc(gl.end_date)
1907: and gl.application_id = 101