APPS.PA_DATE_RANGE_PKG dependencies on GL_PERIODS

Line 105: ,gl_periods gl

101: ,c_period_set_name gl_sets_of_books.period_set_name%type) is
102: select 'Y' from dual
103: where exists ( select 'Y'
104: from pa_budget_lines bl
105: ,gl_periods gl
106: where bl.budget_version_id = c_budget_version_id
107: and gl.period_type = c_period_type
108: and gl.period_set_name = c_period_set_name
109: and gl.ADJUSTMENT_PERIOD_FLAG = 'N'

Line 213: from pa_budget_lines bl,gl_periods gl, pa_resource_assignments ra

209: --for a planning txn
210: DECODE(least(bl.start_date, gl.start_date),
211: gl.start_date,1,
212: 0) tot_amt_factor
213: from pa_budget_lines bl,gl_periods gl, pa_resource_assignments ra
214: where bl.budget_version_id = l_budget_version_id
215: and ra.resource_assignment_id = l_res_assign_id
216: and bl.resource_assignment_id = l_res_assign_id
217: and gl.period_type = l_per_type

Line 600: FROM gl_periods gl

596: begin
597:
598: SELECT gl.PERIOD_NAME
599: INTO l_curr_plan_period
600: FROM gl_periods gl
601: WHERE gl.period_type = l_accounted_per_type
602: and l_project_start_date between gl.START_DATE and gl.END_DATE
603: AND gl.period_set_name = l_sob_period_set_name
604: AND gl.ADJUSTMENT_PERIOD_FLAG = 'N';

Line 628: FROM gl_periods gl

624: begin
625:
626: SELECT gl.PERIOD_NAME
627: INTO l_curr_plan_period
628: FROM gl_periods gl
629: WHERE gl.period_type = l_PA_period_type
630: and l_project_start_date between gl.START_DATE and gl.END_DATE
631: AND gl.period_set_name = l_sob_period_set_name
632: AND gl.ADJUSTMENT_PERIOD_FLAG = 'N';

Line 1667: CURSOR c_derive_time_phase_csr(c_period_type gl_periods.period_type%TYPE)

1663: ,p_org_id IN pa_projects_all.org_id%TYPE) RETURN VARCHAR2
1664: IS
1665: --Bug 4174789. In the expression to derive factor, replaced the division with substraction to nullify
1666: --errors because of infinite digits after decimal point
1667: CURSOR c_derive_time_phase_csr(c_period_type gl_periods.period_type%TYPE)
1668: IS
1669: SELECT 1
1670: FROM dual
1671: WHERE EXISTS

Line 1686: FROM gl_periods gl, pa_implementations_all pi, gl_sets_of_books sob

1682: FROM pa_budget_lines bl,
1683: (SELECT gl.start_date start_date,
1684: gl.end_date end_date,
1685: gl.period_name period_name
1686: FROM gl_periods gl, pa_implementations_all pi, gl_sets_of_books sob
1687: WHERE gl.period_type=c_period_type
1688: AND sob.set_of_books_id=pi.set_of_books_id
1689: AND nvl(pi.org_id,-99)=nvl(p_org_id,-99)
1690: AND gl.adjustment_period_flag='N'

Line 1731: --GL periods are defined in the system. The budget version can be upgraded succesfully to GL

1727: END IF;
1728:
1729: IF l_exists IS NULL THEN
1730:
1731: --GL periods are defined in the system. The budget version can be upgraded succesfully to GL
1732: RETURN 'G';
1733:
1734: ELSE
1735: