DBA Data[Home] [Help]

APPS.PQH_BGT_SHD SQL Statements

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

Line: 80

    select
		budget_id,
	business_group_id,
	start_organization_id,
	org_structure_version_id,
	budgeted_entity_cd,
	budget_style_cd,
	budget_name,
	period_set_name,
	budget_start_date,
	budget_end_date,
        gl_budget_name,
        psb_budget_flag,
	transfer_to_gl_flag,
	transfer_to_grants_flag,
	status,
	object_version_number,
	budget_unit1_id,
	budget_unit2_id,
	budget_unit3_id,
	gl_set_of_books_id,
        budget_unit1_aggregate,
        budget_unit2_aggregate,
        budget_unit3_aggregate,
        position_control_flag ,
        valid_grade_reqd_flag ,
        currency_code,
        dflt_budget_set_id
    from	pqh_budgets
    where	budget_id = p_budget_id;
Line: 177

    select 	budget_id,
	business_group_id,
	start_organization_id,
	org_structure_version_id,
	budgeted_entity_cd,
	budget_style_cd,
	budget_name,
	period_set_name,
	budget_start_date,
	budget_end_date,
        gl_budget_name,
        psb_budget_flag,
	transfer_to_gl_flag,
	transfer_to_grants_flag,
	status,
	object_version_number,
	budget_unit1_id,
	budget_unit2_id,
	budget_unit3_id,
	gl_set_of_books_id,
        budget_unit1_aggregate,
        budget_unit2_aggregate,
        budget_unit3_aggregate,
        position_control_flag ,
        valid_grade_reqd_flag ,
        currency_code,
        dflt_budget_set_id
    from	pqh_budgets
    where	budget_id = p_budget_id
    for	update nowait;