APPS.PA_FUNDS_CONTROL_PKG1 dependencies on GL_PERIOD_STATUSES

Line 2197: FROM gl_period_statuses gl

2193:
2194: CURSOR c_get_gl_start_date (p_period_name VARCHAR2,
2195: p_sob_id NUMBER ) IS
2196: SELECT gl.start_date
2197: FROM gl_period_statuses gl
2198: WHERE gl.application_id = 101
2199: AND gl.set_of_books_id = p_sob_id
2200: AND gl.period_name = p_period_name;
2201:

Line 7286: FROM gl_period_statuses gps

7282: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'Year Start and End Date');
7283:
7284: SELECT gps.year_start_date
7285: INTO l_year_start_date
7286: FROM gl_period_statuses gps
7287: WHERE gps.application_id = 101
7288: AND gps.set_of_books_id = p_set_of_books_id
7289: AND p_expenditure_item_date BETWEEN gps.start_date AND gps.end_date
7290: AND gps.adjustment_period_flag = 'N';

Line 7306: FROM gl_period_statuses gps

7302: SELECT TRUNC ( gps.start_date ),
7303: TRUNC ( gps.end_date )
7304: INTO l_gl_period_start_date,
7305: l_gl_period_end_date
7306: FROM gl_period_statuses gps
7307: WHERE gps.application_id = 101
7308: AND gps.set_of_books_id = p_set_of_books_id
7309: AND p_expenditure_item_date BETWEEN gps.start_date AND gps.end_date
7310: AND gps.adjustment_period_flag = 'N';

Line 7387: FROM gl_period_statuses gps

7383: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD-G');
7384: BEGIN
7385: SELECT TRUNC ( gps.start_date )
7386: INTO l_gs_start_date
7387: FROM gl_period_statuses gps
7388: WHERE gps.application_id = 101
7389: AND gps.set_of_books_id = p_set_of_books_id
7390: AND l_project_start_date BETWEEN gps.start_date AND gps.end_date
7391: AND gps.adjustment_period_flag = 'N';

Line 7450: FROM gl_period_statuses gps

7446: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD_J-G');
7447: BEGIN
7448: SELECT TRUNC ( gps.end_date )
7449: INTO l_gs_end_date
7450: FROM gl_period_statuses gps
7451: WHERE gps.application_id = 101
7452: AND gps.set_of_books_id = p_set_of_books_id
7453: AND l_project_end_date BETWEEN gps.start_date AND gps.end_date
7454: AND gps.adjustment_period_flag = 'N';

Line 8053: FROM gl_period_statuses gl

8049: bv.budget_version_id,
8050: pbc.budget_line_id,
8051: pm.entry_level_code,
8052: (SELECT gl.start_date
8053: FROM gl_period_statuses gl
8054: WHERE gl.application_id = 101
8055: AND gl.set_of_books_id = pbc.set_of_books_id
8056: AND gl.period_name = pbc.period_name) gl_start_date,
8057: pbc.exp_item_id,

Line 8794: gl_period_statuses glp

8790: NULL
8791: FROM igc_cc_interface igc,
8792: igc_cc_headers_all igchead,
8793: psa_bc_xla_events_gt pbgt,
8794: gl_period_statuses glp
8795: WHERE pbgt.event_id = igc.event_id
8796: and igc.cc_header_id = igchead.cc_header_id
8797: and igc.budget_dest_flag = 'S'
8798: and glp.application_id = 101

Line 9045: gl_period_statuses gl,

9041: pa_projects_all pp,
9042: igc_cc_interface igci,
9043: igc_cc_acct_lines igc,
9044: igc_cc_headers_all igchead,
9045: gl_period_statuses gl,
9046: pa_implementations_all imp
9047: WHERE igc.cc_header_id = p_reference2
9048: AND p_reference1 = 'CC'
9049: AND igchead.cc_header_id = igc.cc_header_id