DBA Data[Home] [Help]

APPS.PAY_PWA_SHD SQL Statements

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

Line: 64

    select
		account_id,
	business_group_id,
	carrier_id,
	location_id,
	name,
	account_number,
	comments,
	object_version_number
    from	pay_wci_accounts
    where	account_id = p_account_id;
Line: 142

    select 	account_id,
	business_group_id,
	carrier_id,
	location_id,
	name,
	account_number,
	comments,
	object_version_number
    from	pay_wci_accounts
    where	account_id = p_account_id
    for	update nowait;