APPS.CN_SFP_GROUP_UTIL_PVT_W SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 165

    , p_selected_groups JTF_NUMBER_TABLE
    , p_effective_date  date
    , x_descendant_groups out nocopy JTF_NUMBER_TABLE
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;

Line: 185

    cn_sfp_group_util_pvt_w.rosetta_table_copy_in_p4(ddp_selected_groups, p_selected_groups);

Line: 198

      ddp_selected_groups,
      ddp_effective_date,
      ddx_descendant_groups,
      x_return_status,
      x_msg_count,
      x_msg_data);

Line: 222

    , p_selected_groups JTF_NUMBER_TABLE
    , p_status  VARCHAR2
    , p_effective_date  date
    , p7_a0 out nocopy JTF_NUMBER_TABLE
    , p7_a1 out nocopy JTF_NUMBER_TABLE
    , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;

Line: 245

    cn_sfp_group_util_pvt_w.rosetta_table_copy_in_p4(ddp_selected_groups, p_selected_groups);

Line: 259

      ddp_selected_groups,
      p_status,
      ddp_effective_date,
      ddx_salesrep_roles,
      x_return_status,
      x_msg_count,
      x_msg_data);