DBA Data[Home] [Help]

APPS.PSB_CONCURRENCY_CONTROL_PVT SQL Statements

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

Line: 95

    select worksheet_id,
	   budget_group_id,
	   budget_calendar_id,
	   nvl(parameter_set_id, global_parameter_set_id) parameter_set_id,
	   nvl(constraint_set_id, global_constraint_set_id) constraint_set_id,
	   nvl(allocrule_set_id, global_allocrule_set_id) allocrule_set_id,
	   nvl(data_extract_id, global_data_extract_id) data_extract_id
      from PSB_WORKSHEETS_V
     where worksheet_id = p_concurrency_entity_id;
Line: 106

    select budget_revision_id,
	   budget_group_id,
	   parameter_set_id,
	   constraint_set_id
      from psb_budget_revisions_v
     where budget_revision_id = p_concurrency_entity_id;
Line: 681

    select worksheet_id,
	   budget_group_id,
	   budget_calendar_id,
	   nvl(parameter_set_id, global_parameter_set_id) parameter_set_id,
	   nvl(constraint_set_id, global_constraint_set_id) constraint_set_id,
	   nvl(allocrule_set_id, global_allocrule_set_id) allocrule_set_id,
	   nvl(data_extract_id, global_data_extract_id) data_extract_id
      from PSB_WORKSHEETS_V
     where worksheet_id = p_concurrency_entity_id;