DBA Data[Home] [Help]

APPS.PAY_PWO_SHD SQL Statements

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

Line: 54

    select
		occupation_id,
	business_group_id,
	rate_id,
	job_id,
	comments,
	object_version_number
    from	pay_wci_occupations
    where	occupation_id = p_occupation_id;
Line: 130

    select 	occupation_id,
	business_group_id,
	rate_id,
	job_id,
	comments,
	object_version_number
    from	pay_wci_occupations
    where	occupation_id = p_occupation_id
    for	update nowait;