APPS.PSB_GL_INTERFACE_PVT dependencies on GL_PERIOD_STATUSES

Line 824: FROM GL_PERIOD_STATUSES

820: closing_status,
821: period_year,
822: period_num,
823: quarter_num
824: FROM GL_PERIOD_STATUSES
825: WHERE application_id = 101
826: AND set_of_books_id = g_set_of_books_id
827: AND NVL(adjustment_period_flag, 'N') = 'N'
828: AND p_start_date BETWEEN start_date AND end_date

Line 836: FROM gl_period_statuses

832: --commented the following CURSOR as it's NOT being used
833: /*
834: CURSOR c_next_period IS
835: SELECT period_name, start_date
836: FROM gl_period_statuses
837: WHERE application_id = 101
838: AND set_of_books_id = g_set_of_books_id
839: AND NVL(adjustment_period_flag,'N') = 'N'
840: AND p_period_end_date+1 BETWEEN start_date AND end_date;

Line 924: FROM GL_PERIOD_STATUSES

920: --
921: CURSOR c_period
922: IS
923: SELECT period_year
924: FROM GL_PERIOD_STATUSES
925: WHERE application_id = 101
926: AND set_of_books_id = g_set_of_books_id
927: AND p_year_end_date BETWEEN start_date AND end_date;
928:

Line 3410: gl_period_statuses gps,

3406: budget_balance x_amount
3407: FROM psb_budget_revisions br,
3408: psb_budget_revision_accounts bra,
3409: psb_budget_revision_lines brl,
3410: gl_period_statuses gps,
3411: psb_gl_budgets pgb
3412: WHERE br.budget_revision_id = p_budget_revision_id
3413: AND brl.budget_revision_id = p_budget_revision_id
3414: AND br.budget_revision_type = 'R'

Line 3718: GL_PERIOD_STATUSES gp

3714: CURSOR c_year
3715: IS
3716: SELECT MIN(gp.start_date) start_date, MAX(gp.end_date) end_date
3717: FROM PSB_BUDGET_REVISION_ACCOUNTS ac,
3718: GL_PERIOD_STATUSES gp
3719: WHERE ac.budget_revision_acct_line_id IN
3720: (SELECT budget_revision_acct_line_id
3721: FROM psb_budget_revision_lines
3722: WHERE budget_revision_id = p_budget_revision_id