APPS.FV_FUNDS_AVAILABLE_PKG dependencies on GL_PERIOD_STATUSES

Line 34: x_period_num gl_period_statuses.period_num%TYPE;

30: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
31: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
32: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
33: spd_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
34: x_period_num gl_period_statuses.period_num%TYPE;
35: v_segment_low_name number;
36: v_segment_num number;
37: v_segment_low_value varchar2(25);
38: v_segment_high_name number;

Line 81: v_period_year gl_period_statuses.period_year%TYPE;

77: --sob_id gl_balances.set_of_books_id%TYPE;
78: sob_id gl_balances.ledger_id%TYPE;
79: curr_code gl_balances.currency_code%TYPE;
80: pd_name gl_balances.period_name%TYPE;
81: v_period_year gl_period_statuses.period_year%TYPE;
82: v_period_status gl_period_statuses.closing_status%TYPE;
83: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;
84:
85:

Line 82: v_period_status gl_period_statuses.closing_status%TYPE;

78: sob_id gl_balances.ledger_id%TYPE;
79: curr_code gl_balances.currency_code%TYPE;
80: pd_name gl_balances.period_name%TYPE;
81: v_period_year gl_period_statuses.period_year%TYPE;
82: v_period_status gl_period_statuses.closing_status%TYPE;
83: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;
84:
85:
86: g_curr_code gl_balances.currency_code%TYPE;

Line 83: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;

79: curr_code gl_balances.currency_code%TYPE;
80: pd_name gl_balances.period_name%TYPE;
81: v_period_year gl_period_statuses.period_year%TYPE;
82: v_period_status gl_period_statuses.closing_status%TYPE;
83: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;
84:
85:
86: g_curr_code gl_balances.currency_code%TYPE;
87:

Line 612: from gl_period_statuses

608: into x_period_num,
609: v_period_year,
610: v_period_status,
611: v_effective_period_num
612: from gl_period_statuses
613: where period_name = x_period_name
614: and ledger_id = sob_id
615: and application_id = 101;
616:

Line 621: from gl_period_statuses gps1

617: v_statement := 'A.A';
618: if (v_period_status = 'F') THEN
619: select gps1.period_name
620: into pd_name
621: from gl_period_statuses gps1
622: where gps1.application_id=101
623: and gps1.ledger_id=sob_id
624: and effective_period_num = (select max(effective_period_num)
625: from gl_period_statuses gps2

Line 625: from gl_period_statuses gps2

621: from gl_period_statuses gps1
622: where gps1.application_id=101
623: and gps1.ledger_id=sob_id
624: and effective_period_num = (select max(effective_period_num)
625: from gl_period_statuses gps2
626: where gps2.application_id = gps1.application_id
627: and gps2.ledger_id = gps1.ledger_id
628: and gps2.closing_status <> 'F'
629: and gps2.effective_period_num <= v_effective_period_num);