APPS.PA_BGT_BASELINE_PKG dependencies on GL_PERIOD_STATUSES

Line 757: gl_period_STATUSES gl,

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

Line 871: gl_period_STATUSES gl,

867: ,decode(ei.system_linkage_function, 'BTC', decode(nvl(ei.po_line_id,-99), -99, null, -99), null)
868: from pa_expenditure_items_all ei,
869: pa_expenditures_all exp,
870: pa_cost_distribution_lines_all cdl,
871: gl_period_STATUSES gl,
872: pa_tasks pt
873: where cdl.project_id = p_project_id
874: and pt.task_id = ei.task_id
875: and ei.expenditure_id = exp.expenditure_id

Line 1485: from gl_period_statuses gl

1481: ,l_pktReference2Tab(i)
1482: ,l_pktReference3Tab(i)
1483: -- R12 Funds Management Uptake
1484: ,l_BurMethodcodeTab(i)
1485: from gl_period_statuses gl
1486: where l_DocTypTab(i) in ('CC_C_CO', 'CC_P_CO')
1487: --and l_GlDateTab(i) = gl.end_date
1488: and trunc(l_GlDateTab(i)) between trunc(gl.start_date) and trunc(gl.end_date)
1489: and gl.application_id = 101

Line 1737: from gl_period_statuses gl

1733: ,l_pktReference2Tab(k)
1734: ,l_pktReference3Tab(k)
1735: -- R12 Funds Management Uptake
1736: ,l_BurMethodcodeTab(k)
1737: from gl_period_statuses gl
1738: where l_DocTypTab(k) in ('AP','PO','REQ','CC_C_PAY','CC_P_PAY')
1739: --and l_GlDateTab(k) = gl.end_date
1740: and trunc(l_GlDateTab(k)) between trunc(gl.start_date) and trunc(gl.end_date)
1741: and gl.application_id = 101