eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_POSITIONS_PVT dependencies on PSB_ATTRIBUTE_VALUES

Line 4691: FROM psb_attribute_values patv,

4687: SELECT 'Job Exists'
4688: FROM dual
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)

Line 5918: FROM psb_attribute_values patv,

5914: IF p_worksheet_id IS NULL THEN
5915:
5916: SELECT patv.attribute_value
5917: INTO l_job_name
5918: FROM psb_attribute_values patv,
5919: psb_position_assignments pava
5920: WHERE patv.attribute_value_id = pava.attribute_value_id
5921: AND pava.position_id = p_position_id
5922: AND patv.data_extract_id = p_data_extract_id

Line 5934: FROM psb_attribute_values patv,

5930: ELSE
5931:
5932: SELECT patv.attribute_value
5933: INTO l_job_name
5934: FROM psb_attribute_values patv,
5935: psb_position_assignments pava
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