274: select position_id,
275: name,
276: effective_start_date,
277: effective_end_date
278: from PSB_POSITIONS
279: where (((effective_start_date <= PSB_WS_ACCT1.g_end_est_date)
280: and (effective_end_date is null))
281: or ((effective_start_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
282: or (effective_end_date between PSB_WS_ACCT1.g_startdate_cy and PSB_WS_ACCT1.g_end_est_date)
575: select a.position_id,
576: a.name,
577: a.effective_start_date,
578: a.effective_end_date
579: from PSB_POSITIONS a,
580: PSB_WS_POSITION_LINES b
581: where a.position_id = b.position_id
582: and b.position_line_id = p_position_line_id;
583: