APPS.FV_TREASURY_PAYMENTS_PKG dependencies on GL_PERIOD_STATUSES

Line 565: v_status gl_period_statuses.closing_status%type;

561: END do_backout_process;
562:
563: PROCEDURE GET_OPEN_PERIOD(p_accounting_date IN OUT NOCOPY DATE)
564: IS
565: v_status gl_period_statuses.closing_status%type;
566: v_pyear gl_period_statuses.period_year%type;
567: l_module_name VARCHAR2(200);
568: v_pnum gl_period_statuses.effective_period_num%type;
569: BEGIN

Line 566: v_pyear gl_period_statuses.period_year%type;

562:
563: PROCEDURE GET_OPEN_PERIOD(p_accounting_date IN OUT NOCOPY DATE)
564: IS
565: v_status gl_period_statuses.closing_status%type;
566: v_pyear gl_period_statuses.period_year%type;
567: l_module_name VARCHAR2(200);
568: v_pnum gl_period_statuses.effective_period_num%type;
569: BEGIN
570:

Line 568: v_pnum gl_period_statuses.effective_period_num%type;

564: IS
565: v_status gl_period_statuses.closing_status%type;
566: v_pyear gl_period_statuses.period_year%type;
567: l_module_name VARCHAR2(200);
568: v_pnum gl_period_statuses.effective_period_num%type;
569: BEGIN
570:
571: /* To find out whether period is open for particular gl_accounting_date */
572: l_module_name := g_module_name ||' get_open_period';

Line 576: FROM gl_period_statuses gps

572: l_module_name := g_module_name ||' get_open_period';
573:
574: SELECT closing_status,period_year,effective_period_num
575: INTO v_status,v_pyear,v_pnum
576: FROM gl_period_statuses gps
577: WHERE gps.ledger_id = g_ledger_id
578: AND gps.application_id = 101
579: AND p_accounting_date BETWEEN gps.start_date AND gps.end_date
580: AND gps.adjustment_period_flag = 'N';

Line 589: FROM gl_period_statuses gps

585: BEGIN
586:
587: SELECT start_date
588: INTO p_accounting_date
589: FROM gl_period_statuses gps
590: WHERE gps.ledger_id = g_ledger_id
591: AND gps.application_id = 101
592: AND gps.period_year >= v_pyear
593: AND effective_period_num > v_pnum