APPS.PER_PYP_SHD SQL Statements

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

Line: 79

    select
        pay_proposal_id,
        assignment_id,
        business_group_id,
        change_date,
        comments,
        last_change_date,
        next_sal_review_date,
        proposal_reason,
        proposed_salary_n,
        forced_ranking,
	date_to,
        performance_review_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        attribute16,
        attribute17,
        attribute18,
        attribute19,
        attribute20,
        object_version_number,
        multiple_components,
        approved

    from        per_pay_proposals
    where        pay_proposal_id = p_pay_proposal_id;

Line: 186

    select         pay_proposal_id,
        assignment_id,
        business_group_id,
        change_date,
        comments,
        last_change_date,
        next_sal_review_date,
        proposal_reason,
        proposed_salary_n,
        forced_ranking,
	date_to,
        performance_review_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        attribute16,
        attribute17,
        attribute18,
        attribute19,
        attribute20,
        object_version_number,
        multiple_components,
        approved
    from        per_pay_proposals
    where        pay_proposal_id = p_pay_proposal_id
    for        update nowait;