APPS.FV_TREASURY_PAYMENTS_PKG dependencies on GL_PERIOD_STATUSES

Line 625: v_status gl_period_statuses.closing_status%type;

621: END do_backout_process;
622:
623: PROCEDURE GET_OPEN_PERIOD(p_accounting_date IN OUT NOCOPY DATE)
624: IS
625: v_status gl_period_statuses.closing_status%type;
626: v_pyear gl_period_statuses.period_year%type;
627: l_module_name VARCHAR2(200);
628: v_pnum gl_period_statuses.effective_period_num%type;
629: BEGIN

Line 626: v_pyear gl_period_statuses.period_year%type;

622:
623: PROCEDURE GET_OPEN_PERIOD(p_accounting_date IN OUT NOCOPY DATE)
624: IS
625: v_status gl_period_statuses.closing_status%type;
626: v_pyear gl_period_statuses.period_year%type;
627: l_module_name VARCHAR2(200);
628: v_pnum gl_period_statuses.effective_period_num%type;
629: BEGIN
630:

Line 628: v_pnum gl_period_statuses.effective_period_num%type;

624: IS
625: v_status gl_period_statuses.closing_status%type;
626: v_pyear gl_period_statuses.period_year%type;
627: l_module_name VARCHAR2(200);
628: v_pnum gl_period_statuses.effective_period_num%type;
629: BEGIN
630:
631: /* To find out whether period is open for particular gl_accounting_date */
632: l_module_name := g_module_name ||' get_open_period';

Line 636: FROM gl_period_statuses gps

632: l_module_name := g_module_name ||' get_open_period';
633:
634: SELECT closing_status,period_year,effective_period_num
635: INTO v_status,v_pyear,v_pnum
636: FROM gl_period_statuses gps
637: WHERE gps.ledger_id = g_ledger_id
638: AND gps.application_id = 101
639: AND p_accounting_date BETWEEN gps.start_date AND gps.end_date;
640:

Line 648: FROM gl_period_statuses gps

644: BEGIN
645:
646: SELECT start_date
647: INTO p_accounting_date
648: FROM gl_period_statuses gps
649: WHERE gps.ledger_id = g_ledger_id
650: AND gps.application_id = 101
651: AND gps.period_year >= v_pyear
652: AND effective_period_num > v_pnum