DBA Data[Home] [Help]

APPS.PSB_WS_POS2 dependencies on PSB_POSITIONS

Line 278: from PSB_POSITIONS

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)

Line 579: from PSB_POSITIONS a,

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: