VIEW: APPS.HXT_ADD_ASSIGN_INFO_D

Source

View Text - Preformatted

SELECT aai.id ,aai.effective_start_date ,aai.effective_end_date ,asg.assignment_number ,hrk1.meaning Autogen_hours_YN ,rot.name rotation_plan_name ,erp.name earning_policy_name ,sdp.name shift_differential_policy_name ,hdp.name hour_deduction_policy_name ,aai.last_update_date , fuser.user_name last_updated_by FROM hxt_hour_deduct_policies hdp, hxt_shift_diff_policies sdp, hxt_earning_policies erp, hxt_rotation_plans rot, per_assignments_f asg, hxt_add_assign_info_f aai, fnd_user fuser, hr_lookups hrk1 WHERE aai.assignment_id = asg.assignment_id AND aai.effective_start_date between nvl(asg.effective_start_date, aai.effective_start_date) and nvl(asg.effective_end_date, aai.effective_end_date) AND aai.effective_start_date between nvl(hrk1.start_date_active(+), aai.effective_start_date) and nvl(hrk1.end_date_active(+), aai.effective_end_date) AND hrk1.lookup_type = 'YES_NO' AND hrk1.enabled_flag = 'Y' AND hrk1.application_id = 800 AND hrk1.lookup_code = aai.autogen_hours_yn AND aai.rotation_plan = rot.id AND aai.earning_policy = erp.id AND aai.shift_differential_policy = sdp.id(+) AND aai.hour_deduction_policy = hdp.id(+) AND aai.last_updated_by = fuser.user_id(+)

View Text - HTML Formatted

SELECT AAI.ID
, AAI.EFFECTIVE_START_DATE
, AAI.EFFECTIVE_END_DATE
, ASG.ASSIGNMENT_NUMBER
, HRK1.MEANING AUTOGEN_HOURS_YN
, ROT.NAME ROTATION_PLAN_NAME
, ERP.NAME EARNING_POLICY_NAME
, SDP.NAME SHIFT_DIFFERENTIAL_POLICY_NAME
, HDP.NAME HOUR_DEDUCTION_POLICY_NAME
, AAI.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM HXT_HOUR_DEDUCT_POLICIES HDP
, HXT_SHIFT_DIFF_POLICIES SDP
, HXT_EARNING_POLICIES ERP
, HXT_ROTATION_PLANS ROT
, PER_ASSIGNMENTS_F ASG
, HXT_ADD_ASSIGN_INFO_F AAI
, FND_USER FUSER
, HR_LOOKUPS HRK1
WHERE AAI.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND AAI.EFFECTIVE_START_DATE BETWEEN NVL(ASG.EFFECTIVE_START_DATE
, AAI.EFFECTIVE_START_DATE)
AND NVL(ASG.EFFECTIVE_END_DATE
, AAI.EFFECTIVE_END_DATE)
AND AAI.EFFECTIVE_START_DATE BETWEEN NVL(HRK1.START_DATE_ACTIVE(+)
, AAI.EFFECTIVE_START_DATE)
AND NVL(HRK1.END_DATE_ACTIVE(+)
, AAI.EFFECTIVE_END_DATE)
AND HRK1.LOOKUP_TYPE = 'YES_NO'
AND HRK1.ENABLED_FLAG = 'Y'
AND HRK1.APPLICATION_ID = 800
AND HRK1.LOOKUP_CODE = AAI.AUTOGEN_HOURS_YN
AND AAI.ROTATION_PLAN = ROT.ID
AND AAI.EARNING_POLICY = ERP.ID
AND AAI.SHIFT_DIFFERENTIAL_POLICY = SDP.ID(+)
AND AAI.HOUR_DEDUCTION_POLICY = HDP.ID(+)
AND AAI.LAST_UPDATED_BY = FUSER.USER_ID(+)