DBA Data[Home] [Help]

APPS.PSB_WS_POS3 dependencies on PSB_CONSTRAINT_ASSIGNMENTS_V

Line 4569: from PSB_CONSTRAINT_ASSIGNMENTS_V

4565: currency_code,
4566: severity_level,
4567: effective_start_date,
4568: effective_end_date
4569: from PSB_CONSTRAINT_ASSIGNMENTS_V
4570: where constraint_type = 'ELEMENT'
4571: and (((effective_start_date <= PSB_WS_ACCT1.g_end_est_date)
4572: and (effective_end_date is null))
4573: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)

Line 4766: from PSB_CONSTRAINT_ASSIGNMENTS_V

4762: fte_constraint,
4763: effective_start_date,
4764: effective_end_date,
4765: constraint_detailed_flag
4766: from PSB_CONSTRAINT_ASSIGNMENTS_V
4767: where constraint_type = 'POSITION'
4768: and (((effective_start_date <= Year_End_Date)
4769: and (effective_end_date is null))
4770: or ((effective_start_date between Year_Start_Date and Year_End_Date)