DBA Data[Home] [Help]

APPS.PQH_BCE_SHD SQL Statements

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

Line: 60

    select
        bdgt_cmmtmnt_elmnt_id,
	budget_id,
        actual_commitment_type,
	element_type_id,
	salary_basis_flag,
	element_input_value_id,
        balance_type_id,
	frequency_input_value_id,
	formula_id,
	dflt_elmnt_frequency,
	overhead_percentage,
	object_version_number
    from	pqh_bdgt_cmmtmnt_elmnts
    where	bdgt_cmmtmnt_elmnt_id = p_bdgt_cmmtmnt_elmnt_id;
Line: 142

    select 	bdgt_cmmtmnt_elmnt_id,
	budget_id,
        actual_commitment_type,
	element_type_id,
	salary_basis_flag,
	element_input_value_id,
        balance_type_id,
	frequency_input_value_id,
	formula_id,
	dflt_elmnt_frequency,
	overhead_percentage,
	object_version_number
    from	pqh_bdgt_cmmtmnt_elmnts
    where	bdgt_cmmtmnt_elmnt_id = p_bdgt_cmmtmnt_elmnt_id
    for	update nowait;