APPS.GHR_PDI_SHD SQL Statements

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

Line: 73

    select
	position_description_id,
	routing_group_id,
	date_from,
	date_to,
	opm_cert_num,
	flsa,
	financial_statement,
	subject_to_ia_action,
	position_status,
	position_is,
	position_sensitivity,
	competitive_level,
	pd_remarks,
	position_class_std,
	category,
	career_ladder,
        supervisor_name,
        supervisor_title,
        supervisor_date,
        manager_name,
        manager_title,
        manager_date,
        classifier_name,
        classifier_title,
        classifier_date,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
        business_group_id,
	object_version_number
    from	ghr_position_descriptions
    where	position_description_id = p_position_description_id;

Line: 191

    select 	position_description_id,
	routing_group_id,
	date_from,
	date_to,
	opm_cert_num,
	flsa,
	financial_statement,
	subject_to_ia_action,
	position_status,
	position_is,
	position_sensitivity,
	competitive_level,
	pd_remarks,
	position_class_std,
	category,
	career_ladder,
        supervisor_name,
        supervisor_title,
        supervisor_date,
        manager_name,
        manager_title,
        manager_date,
        classifier_name,
        classifier_title,
        classifier_date,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
        business_group_id,
	object_version_number
    from	ghr_position_descriptions
    where	position_description_id = p_position_description_id
    for	update nowait;