APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_AWARDS_ALL

Line 4263: fcl_a gms_awards_all.fund_control_level_award%type;

4259: ----------------------------------------------------------------------------------------------------------
4260: PROCEDURE funds_ctrl_level_code (
4261: x_packet_id IN NUMBER) IS
4262:
4263: fcl_a gms_awards_all.fund_control_level_award%type;
4264: fcl_t gms_awards_all.fund_control_level_task%type;
4265: fcl_r_grp gms_awards_all.fund_control_level_res_grp%type;
4266: fcl_r gms_awards_all.fund_control_level_res%type;
4267:

Line 4264: fcl_t gms_awards_all.fund_control_level_task%type;

4260: PROCEDURE funds_ctrl_level_code (
4261: x_packet_id IN NUMBER) IS
4262:
4263: fcl_a gms_awards_all.fund_control_level_award%type;
4264: fcl_t gms_awards_all.fund_control_level_task%type;
4265: fcl_r_grp gms_awards_all.fund_control_level_res_grp%type;
4266: fcl_r gms_awards_all.fund_control_level_res%type;
4267:
4268: /* 12649316 */

Line 4265: fcl_r_grp gms_awards_all.fund_control_level_res_grp%type;

4261: x_packet_id IN NUMBER) IS
4262:
4263: fcl_a gms_awards_all.fund_control_level_award%type;
4264: fcl_t gms_awards_all.fund_control_level_task%type;
4265: fcl_r_grp gms_awards_all.fund_control_level_res_grp%type;
4266: fcl_r gms_awards_all.fund_control_level_res%type;
4267:
4268: /* 12649316 */
4269: /* 13410272 added distinct to the select query */

Line 4266: fcl_r gms_awards_all.fund_control_level_res%type;

4262:
4263: fcl_a gms_awards_all.fund_control_level_award%type;
4264: fcl_t gms_awards_all.fund_control_level_task%type;
4265: fcl_r_grp gms_awards_all.fund_control_level_res_grp%type;
4266: fcl_r gms_awards_all.fund_control_level_res%type;
4267:
4268: /* 12649316 */
4269: /* 13410272 added distinct to the select query */
4270: CURSOR award_csr (p_packet_id number) is

Line 4396: from gms_awards_all

4392: fcl_a,
4393: fcl_t,
4394: fcl_r_grp,
4395: fcl_r
4396: from gms_awards_all
4397: where award_id = award_rec.award_id;
4398: /* 12649316 (select award_id
4399: from gms_bc_packets
4400: WHERE packet_id = x_packet_id ); */ /* added for bug 12432376 for debugging*/