APPS.FV_FUNDS_AVAILABLE_PKG dependencies on GL_PERIOD_STATUSES

Line 33: x_period_num gl_period_statuses.period_num%TYPE;

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

Line 78: v_period_year gl_period_statuses.period_year%TYPE;

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

Line 79: v_period_status gl_period_statuses.closing_status%TYPE;

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

Line 80: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;

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

Line 596: from gl_period_statuses

592: into x_period_num,
593: v_period_year,
594: v_period_status,
595: v_effective_period_num
596: from gl_period_statuses
597: where period_name = x_period_name
598: and ledger_id = sob_id
599: and application_id = 101;
600:

Line 605: from gl_period_statuses gps1

601: v_statement := 'A.A';
602: if (v_period_status = 'F') THEN
603: select gps1.period_name
604: into pd_name
605: from gl_period_statuses gps1
606: where gps1.application_id=101
607: and gps1.ledger_id=sob_id
608: and effective_period_num = (select max(effective_period_num)
609: from gl_period_statuses gps2

Line 609: from gl_period_statuses gps2

605: from gl_period_statuses gps1
606: where gps1.application_id=101
607: and gps1.ledger_id=sob_id
608: and effective_period_num = (select max(effective_period_num)
609: from gl_period_statuses gps2
610: where gps2.application_id = gps1.application_id
611: and gps2.ledger_id = gps1.ledger_id
612: and gps2.closing_status <> 'F'
613: and gps2.effective_period_num <= v_effective_period_num);