APPS.AML_SALES_LEADS_V2_PUB SQL Statements

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

Line: 69

    SELECT JS.RESOURCE_ID
    FROM   JTF_RS_RESOURCE_EXTNS JS
    WHERE  JS.USER_ID = C_User_Id;

Line: 75

     SELECT MAX(grp.group_id) salesgroup_id
     FROM   JTF_RS_GROUP_MEMBERS mem,
            JTF_RS_ROLE_RELATIONS rrel,
            JTF_RS_ROLES_B role,
            JTF_RS_GROUP_USAGES u,
            JTF_RS_GROUPS_B grp
     WHERE  mem.group_member_id     = rrel.role_resource_id AND
            rrel.role_resource_type = 'RS_GROUP_MEMBER' AND
            rrel.role_id            = role.role_id AND
            role.role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM') AND
            mem.delete_flag         <> 'Y' AND
            rrel.delete_flag        <> 'Y' AND
            sysdate BETWEEN rrel.start_date_active AND
               NVL(rrel.end_date_active, SYSDATE) AND
            mem.group_id            = u.group_id AND
            u.usage                 in ('SALES','PRM') AND
            mem.group_id            = grp.group_id AND
            sysdate BETWEEN grp.start_date_active AND
               NVL(grp.end_date_active,sysdate) AND
            mem.resource_id         = c_resource_id;

Line: 98

        SELECT party_type
	FROM   hz_parties
	WHERE  party_id = p_customer_id;

Line: 104

        SELECT org_contact_id
	FROM   hz_org_contacts hzoc, hz_relationships hzr
        WHERE  hzoc.party_relationship_id = hzr.relationship_id
        AND    subject_id = p_customer_id
        AND    object_id  = p_contact_id;

Line: 263

	l_note_context_rec.LAST_UPDATE_DATE     := SYSDATE;

Line: 264

	l_note_context_rec.LAST_UPDATED_BY      := FND_GLOBAL.USER_ID;

Line: 267

	l_note_context_rec.LAST_UPDATE_LOGIN    := FND_GLOBAL.USER_ID;

Line: 273

	l_note_context_rec.LAST_UPDATE_DATE     := SYSDATE;

Line: 274

	l_note_context_rec.LAST_UPDATED_BY      := FND_GLOBAL.USER_ID;

Line: 277

	l_note_context_rec.LAST_UPDATE_LOGIN    := FND_GLOBAL.USER_ID;

Line: 302

	, p_last_update_date    => SYSDATE
	, p_last_updated_by     => FND_GLOBAL.USER_ID
	, p_creation_date       => SYSDATE
	, p_created_by          => FND_GLOBAL.USER_ID
	, p_last_update_login   => FND_GLOBAL.USER_ID
	, p_attribute1          => NULL
	, p_attribute2          => NULL
	, p_attribute3          => NULL
	, p_attribute4          => NULL
	, p_attribute5          => NULL
	, p_attribute6          => NULL
	, p_attribute7          => NULL
	, p_attribute8          => NULL
	, p_attribute9          => NULL
	, p_attribute10         => NULL
	, p_attribute11         => NULL
	, p_attribute12         => NULL
	, p_attribute13         => NULL
	, p_attribute14         => NULL
	, p_attribute15         => NULL
	, p_context             => NULL
	, p_note_type           => NVL(p_note_type,'AS_USER')
	, p_jtf_note_contexts_tab => l_note_context_rec_tbl
	);