APPS.PSB_POSITIONS_PVT dependencies on PSB_ATTRIBUTES

Line 4693: psb_attributes pat

4689: WHERE exists
4690: (SELECT 1
4691: FROM psb_attribute_values patv,
4692: psb_position_assignments pass,
4693: psb_attributes pat
4694: WHERE patv.attribute_value_id = pass.attribute_value_id
4695: AND (pass.worksheet_id is NULL OR pass.worksheet_id = p_worksheet_id)
4696: AND pass.attribute_id = pat.attribute_id
4697: AND pass.position_id = p_position_id

Line 4757: FROM psb_attributes pat,

4753: SELECT 'Default Weekly Hours Exists'
4754: FROM dual
4755: WHERE exists
4756: (SELECT 1
4757: FROM psb_attributes pat,
4758: psb_position_assignments pass
4759: WHERE pat.attribute_id = pass.attribute_id
4760: AND pat.system_attribute_type = 'DEFAULT_WEEKLY_HOURS'
4761: AND (pass.worksheet_id is NULL OR pass.worksheet_id = p_worksheet_id)

Line 5925: (SELECT 1 FROM psb_attributes pat

5921: AND pava.position_id = p_position_id
5922: AND patv.data_extract_id = p_data_extract_id
5923: AND rownum=1
5924: AND EXISTS
5925: (SELECT 1 FROM psb_attributes pat
5926: WHERE pat.attribute_id = pava.attribute_id
5927: AND pat.system_attribute_type = 'JOB_CLASS')
5928: AND pava.worksheet_id IS NULL
5929: ORDER BY pava.effective_start_date DESC;

Line 5940: AND exists (SELECT 1 from psb_attributes pat

5936: WHERE patv.attribute_value_id = pava.attribute_value_id
5937: AND pava.position_id = p_position_id
5938: AND patv.data_extract_id = p_data_extract_id
5939: AND rownum=1
5940: AND exists (SELECT 1 from psb_attributes pat
5941: WHERE pat.attribute_id = pava.attribute_id
5942: AND pat.system_attribute_type = 'JOB_CLASS')
5943: AND (pava.worksheet_id = p_worksheet_id
5944: OR pava.worksheet_id IS NULL)