APPS.AS_SALES_ORG_MANAGER_PVT SQL Statements

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

Line: 19

Function get_sales_group_gen_select return Varchar2 IS

    l_select_cl Varchar2(500);

Line: 24

    l_select_cl := 'Select ' ||
                   'Sales_Group_id, Name, Start_Date_Active, End_Date_Active, ' ||
                   'Description, Parent_Sales_Group_ID, Manager_Person_Id, ' ||
                   'Manager_Salesforce_Id, Accounting_Code ' ||
                   'From AS_SALES_GROUPS_V ' ||
                   'Where 1=1 ';

Line: 30

    return l_select_cl;

Line: 33

  End get_sales_group_gen_select;

Line: 133

  Function get_salesmem_gen_select return Varchar2 IS

    l_select_cl Varchar2(500);

Line: 138

    l_select_cl := 'Select ' ||
                   'force.salesforce_id, force.type, force.start_date_active, force.end_date_active, ' ||
                   'force.employee_person_id, null, force.Partner_address_id, ' ||
-- remove partner_contact_id
--                   'force.partner_customer_id, force.partner_contact_id, people.last_name, ' ||
                   'force.partner_customer_id, people.last_name, ' ||
-- remove job.name and replace it by null so don't need to change everything
--                   'people.first_name, people.full_name, people.email_address, job.name, ' ||
                   'people.first_name, people.full_name, people.email_address, null, ' ||
                   'sales_group.name, manage_group.sales_group_id, manage_group.name ';

Line: 148

    return l_select_cl;

Line: 151

  End get_salesmem_gen_select;

Line: 153

  Function get_salesmem_gen_select_w_grp return Varchar2 IS

    l_select_cl Varchar2(500);

Line: 158

    l_select_cl := 'Select ' ||
                   'force.salesforce_id, force.type, force.start_date_active, force.end_date_active, ' ||
                   'force.employee_person_id, force.sales_group_id, force.Partner_address_id, ' ||
                   'force.partner_customer_id, people.last_name, ' ||
                   'people.first_name, people.full_name, people.email_address, null, ' ||
                   'sales_group.name, manage_group.sales_group_id, manage_group.name ';

Line: 164

    return l_select_cl;

Line: 166

  End get_salesmem_gen_select_w_grp;

Line: 437

    l_select_cl           Varchar2(500);

Line: 489

           	AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Select');

Line: 493

      l_select_cl := get_sales_group_gen_select;

Line: 510

                     l_select_cl || l_where_cl, DBMS_SQL.native);

Line: 674

              Select     force.resource_id,
                         force.category,
                         force.start_date_active,
                         force.end_date_active,
                         decode(force.category,'EMPLOYEE',force.source_id,null),
                         null,
                         null,
                         decode(force.category,'PARTY',force.source_id,null)
              From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel
			   ,JTF_RS_ROLES_B roleb, FND_User fnd_user
              Where force.user_id = fnd_user.user_id
              and fnd_user.user_id = p_user_id
	         and force.category in ('EMPLOYEE','PARTY')
		    and force.resource_id = rrel.role_resource_id
		    and rrel.role_resource_type = 'RS_INDIVIDUAL'
		    and rrel.role_id = roleb.role_id
		    and roleb.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')
		    and rownum = 1;

Line: 694

              Select     force.salesforce_id,
                         force.Type,
                         force.start_date_active,
                         force.end_date_active,
                         force.employee_person_id,
                   --      force.sales_group_id,
                         force.partner_address_id,
                         force.partner_customer_id,
                         force.partner_contact_id
              From AS_SALESFORCE_V force
              Where salesforce_id = p_salesforce_id
		    and rownum = 1;

Line: 708

		    Select 1
		    from dual
		    where exists(select 1 from AS_FC_SALESFORCE_V force
		                 where salesforce_id = p_salesforce_id
					  and sales_group_id = p_sales_group_id);

Line: 954

	  select 1
	  from dual
	  where exists(select 1 from AS_FC_SALESFORCE_V sale
	               where sale.salesforce_id = p_salesforce_id);

Line: 962

    l_select_cl           Varchar2(500);

Line: 1014

          	AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,  'AS_SALES_ORG_MANAGER_PVT - Generate Select');

Line: 1021

         l_select_cl := get_salesmem_gen_select;

Line: 1023

         l_select_cl := get_salesmem_gen_select_w_grp;

Line: 1050

                     l_select_cl || l_where_cl, DBMS_SQL.native);

Line: 1232

    SELECT rm.reports_to_flag reports_to_flag
    FROM as_rep_managers_v rm, as_salesforce_v sf1, as_salesforce_v sf2
    WHERE rm.manager_person_id = sf1.employee_person_id
	AND rm.person_id = sf2.employee_person_id
	AND sf1.salesforce_id = c_manager_id
	AND sf2.salesforce_id = c_sales_id;

Line: 1240

    SELECT rm.reports_to_flag reports_to_flag
    FROM as_rep_managers_v rm, as_salesforce_v sf
    WHERE rm.manager_person_id = sf.employee_person_id
	AND rm.person_id <> sf.employee_person_id
	AND sf.salesforce_id = c_manager_id;

Line: 1292

		SELECT 'Y'
		FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role
		WHERE rrel.role_id = role.role_id
		and role.member_flag = 'Y'
		and rrel.role_resource_id = mem.group_member_id
		and mem.resource_id = c_salesforce_id
		and group_id IN
		   (SELECT  parent_group_id
		    FROM jtf_rs_groups_denorm
		    WHERE group_id = c_sales_group_id);

Line: 1305

		SELECT 'Y'
		FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role
		WHERE rrel.role_id = role.role_id
		and role.manager_flag = 'Y'
		and rrel.role_resource_id = mem.group_member_id
		and mem.resource_id = c_salesforce_id
		and group_id IN
		   (SELECT  parent_group_id
		    FROM jtf_rs_groups_denorm
		    WHERE group_id = c_sales_group_id);

Line: 1317

		SELECT 'Y'
		FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role
		WHERE rrel.role_id = role.role_id
		and role.admin_flag = 'Y'
		and rrel.role_resource_id = mem.group_member_id
		and mem.resource_id = c_salesforce_id
		and group_id IN
		   (SELECT  parent_group_id
		    FROM jtf_rs_groups_denorm
		    WHERE group_id = c_sales_group_id);