APPS.PA_FUNDS_CONTROL_PKG1 dependencies on GL_PERIOD_STATUSES

Line 2243: FROM gl_period_statuses gl

2239:
2240: CURSOR c_get_gl_start_date (p_period_name VARCHAR2,
2241: p_sob_id NUMBER ) IS
2242: SELECT gl.start_date
2243: FROM gl_period_statuses gl
2244: WHERE gl.application_id = 101
2245: AND gl.set_of_books_id = p_sob_id
2246: AND gl.period_name = p_period_name;
2247:

Line 7633: FROM gl_period_statuses gps

7629: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'Year Start and End Date');
7630:
7631: SELECT gps.year_start_date
7632: INTO l_year_start_date
7633: FROM gl_period_statuses gps
7634: WHERE gps.application_id = 101
7635: AND gps.set_of_books_id = p_set_of_books_id
7636: AND p_expenditure_item_date BETWEEN gps.start_date AND gps.end_date
7637: AND gps.adjustment_period_flag = 'N';

Line 7654: FROM gl_period_statuses gps

7650: SELECT TRUNC ( gps.start_date ),
7651: TRUNC ( gps.end_date )
7652: INTO l_gl_period_start_date,
7653: l_gl_period_end_date
7654: FROM gl_period_statuses gps
7655: WHERE gps.application_id = 101
7656: AND gps.set_of_books_id = p_set_of_books_id
7657: AND p_expenditure_item_date BETWEEN gps.start_date AND gps.end_date
7658: AND gps.adjustment_period_flag = 'N';

Line 7749: FROM gl_period_statuses gps

7745: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD-G');
7746: BEGIN
7747: SELECT TRUNC ( gps.start_date )
7748: INTO l_gs_start_date
7749: FROM gl_period_statuses gps
7750: WHERE gps.application_id = 101
7751: AND gps.set_of_books_id = p_set_of_books_id
7752: AND l_project_start_date BETWEEN gps.start_date AND gps.end_date
7753: AND gps.adjustment_period_flag = 'N';

Line 7816: FROM gl_period_statuses gps

7812: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD_J-G');
7813: BEGIN
7814: SELECT TRUNC ( gps.end_date )
7815: INTO l_gs_end_date
7816: FROM gl_period_statuses gps
7817: WHERE gps.application_id = 101
7818: AND gps.set_of_books_id = p_set_of_books_id
7819: AND l_project_end_date BETWEEN gps.start_date AND gps.end_date
7820: AND gps.adjustment_period_flag = 'N';

Line 8427: FROM gl_period_statuses gl

8423: bv.budget_version_id,
8424: pbc.budget_line_id,
8425: pm.entry_level_code,
8426: (SELECT gl.start_date
8427: FROM gl_period_statuses gl
8428: WHERE gl.application_id = 101
8429: AND gl.set_of_books_id = pbc.set_of_books_id
8430: AND gl.period_name = pbc.period_name) gl_start_date,
8431: pbc.exp_item_id,

Line 9179: gl_period_statuses glp

9175: NULL
9176: FROM igc_cc_interface igc,
9177: igc_cc_headers_all igchead,
9178: psa_bc_xla_events_gt pbgt,
9179: gl_period_statuses glp
9180: WHERE pbgt.event_id = igc.event_id
9181: and igc.cc_header_id = igchead.cc_header_id
9182: and igc.budget_dest_flag = 'S'
9183: and glp.application_id = 101

Line 9433: gl_period_statuses gl,

9429: pa_projects_all pp,
9430: igc_cc_interface igci,
9431: igc_cc_acct_lines igc,
9432: igc_cc_headers_all igchead,
9433: gl_period_statuses gl,
9434: pa_implementations_all imp
9435: WHERE igc.cc_header_id = p_reference2
9436: AND p_reference1 = 'CC'
9437: AND igchead.cc_header_id = igc.cc_header_id