DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_CONSTRAINT_ASSIGNMENTS_V

Line 8115: from PSB_CONSTRAINT_ASSIGNMENTS_V

8111: severity_level,
8112: effective_start_date,
8113: effective_end_date,
8114: constraint_detailed_flag
8115: from PSB_CONSTRAINT_ASSIGNMENTS_V
8116: where constraint_type = 'ACCOUNT'
8117: and constraint_set_id = g_constraint_set_id
8118: and currency_code = g_currency_code -- Bug 3029168
8119: order by severity_level desc;

Line 8235: from PSB_CONSTRAINT_ASSIGNMENTS_V

8231: currency_code,
8232: severity_level,
8233: effective_start_date,
8234: effective_end_date
8235: from PSB_CONSTRAINT_ASSIGNMENTS_V
8236: where constraint_type = 'ELEMENT'
8237: and (((effective_start_date <= g_effective_end_date)
8238: and (effective_end_date is null))
8239: or ((effective_start_date between g_effective_start_date and g_effective_end_date)

Line 9124: from PSB_CONSTRAINT_ASSIGNMENTS_V

9120: fte_constraint,
9121: effective_start_date,
9122: effective_end_date,
9123: constraint_detailed_flag
9124: from PSB_CONSTRAINT_ASSIGNMENTS_V
9125: where constraint_type = 'POSITION'
9126: and constraint_set_id = g_constraint_set_id
9127: order by severity_level desc;
9128: