APPS.PSB_POSITIONS_I_PVT dependencies on PSB_POSITION_PAY_DISTRIBUTIONS

Line 295: FROM PSB_POSITION_PAY_DISTRIBUTIONS

291:
292: CURSOR l_distribution_id_csr
293: IS
294: SELECT *
295: FROM PSB_POSITION_PAY_DISTRIBUTIONS
296: WHERE (((p_position_end_date IS NOT NULL)
297: AND (((effective_start_date <= p_position_end_date)
298: AND (effective_end_date IS NULL))
299: OR ((effective_start_date BETWEEN p_position_start_date AND p_position_end_date)

Line 309: (SELECT 1 FROM psb_position_pay_distributions

305: AND data_extract_id = p_data_extract_id
306: AND position_id = p_position_id
307: AND ((worksheet_id IS NULL AND NOT EXISTS
308: /* Bug 4545909 Start */
309: (SELECT 1 FROM psb_position_pay_distributions
310: WHERE worksheet_id = p_worksheet_id
311: AND position_id = p_position_id))
312: OR worksheet_id = p_worksheet_id
313: OR (worksheet_id IS NULL AND p_worksheet_id IS NULL));