APPS.PSB_WS_POS1 dependencies on PSB_POSITION_ASSIGNMENTS

Line 815: from PSB_POSITION_ASSIGNMENTS

811: /*cursor c_Attributes is
812: select attribute_id,
813: attribute_value,
814: attribute_value_id
815: from PSB_POSITION_ASSIGNMENTS
816: where attribute_id in (g_hiredate_id, g_adjdate_id)
817: and worksheet_id is null
818: and assignment_type = 'ATTRIBUTE'
819: and position_id = p_position_id;*/

Line 827: FROM PSB_POSITION_ASSIGNMENTS po1

823: IS
824: SELECT attribute_id,
825: attribute_value,
826: attribute_value_id
827: FROM PSB_POSITION_ASSIGNMENTS po1
828: WHERE attribute_id IN (g_hiredate_id, g_adjdate_id)
829: AND ( (worksheet_id = p_worksheet_id
830: AND (p_local_parameter_flag = 'Y'))
831: OR ( worksheet_id IS NULL

Line 833: FROM psb_position_assignments po2

829: AND ( (worksheet_id = p_worksheet_id
830: AND (p_local_parameter_flag = 'Y'))
831: OR ( worksheet_id IS NULL
832: AND ( (NOT EXISTS ( SELECT 1
833: FROM psb_position_assignments po2
834: WHERE po1.position_id = po2.position_id
835: AND po1.attribute_id = po2.attribute_id
836: AND po2.worksheet_id = p_worksheet_id))
837: OR ( p_local_parameter_flag = 'N'))))