APPS.IBE_JTA_INTEGRATION_GRP SQL Statements

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

Line: 17

|    		-  ibe_party_v2pvt.Update_Party_Status
|	  	-  PRM_USER_PVT.INACTIVATEPARTNERUSER
+======================================================================*/

FUNCTION postRejection(
                       p_subscription_guid      IN RAW,
                       p_event                  IN OUT NOCOPY wf_event_t)
RETURN VARCHAR2
IS

    l_key		VARCHAR2(240) := p_event.GetEventKey();

Line: 49

	select fu.customer_id from
	fnd_user fu, jtf_um_usertype_reg jureg
	where jureg.usertype_reg_id=c_reg_id
	and jureg.user_id=fu.user_id;

Line: 56

    	select usr.user_id from
    	fnd_user usr, jtf_um_usertype_reg jureg
    	where jureg.usertype_reg_id=c_reg_id
    	and usr.user_id = jureg.user_id;

Line: 63

     SELECT 1 FROM FND_LOOKUPS
	 WHERE LOOKUP_TYPE='IBE_UM_PRIMARY_USER_TYPES'
	 AND LOOKUP_CODE=b_usertype_key;

Line: 130

			ibe_party_v2pvt.Update_Party_Status(
				p_party_id=>l_party_id,
				p_party_status=>'I',
				p_change_org_status=>l_change_org_status,
				p_commit=>FND_API.G_TRUE,
				x_return_status=>l_return_status,
				x_msg_count=>l_msg_count,
				x_msg_data=>l_msg_data
			) ;

Line: 235

	select count(*) into l_company_rel_count from
	hz_relationships hr
	where hr.object_id in(
		  		select object_id from hz_relationships
				where party_id=p_contact_party_id
				and relationship_code='EMPLOYEE_OF'
			     )
	and status<>'I';

Line: 278

	select ut.usertype_key
	from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv
	where ut.usertype_id=ureg.usertype_id
	and ureg.usertype_reg_id=p_user_reg_id
	and flv.lookup_type=c_lookup_type
	and ut.usertype_key=flv.lookup_code;

Line: 329

	select ut.usertype_key
	from jtf_um_usertypes_b ut, jtf_um_usertype_reg ureg, fnd_lookup_values flv
	where ut.usertype_id=ureg.usertype_id
	and ureg.usertype_reg_id=p_user_reg_id
	and flv.lookup_type=c_lookup_type
	and ut.usertype_key=flv.lookup_code;