VIEW: APPS.HXTFV_EARNING_RULES

Source

View Text - Preformatted

SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ bgrT.name business_group_name ,peo.full_name person_name ,1 person_count ,epl.name earning_policy ,erl.name earning_rule ,erl.seq_no sequence_number ,hr_general.decode_lookup('HXT_EARN_RULE_TYPE',erl.egr_type) overtime_type ,erl.hours hours ,erl.days days ,pet.element_name earning_code /********/ /* Ids */ /********/ ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,epl.id earning_policy_id ,erl.id earning_rule_id ,erl.element_type_id element_type_id ,asg.grade_id grade_id ,asg.job_id job_id ,asg.organization_id organization_id ,erl.egp_id overtime_policy_id ,asg.person_id person_id ,asg.position_id position_id FROM hxt_earning_rules erl ,hxt_earning_policies epl ,hxt_add_assign_info_f aai ,per_assignments_f asg ,per_all_people_f peo ,pay_element_types_f pet ,hr_all_organization_units_tl bgrT WHERE peo.person_id = asg.person_id AND asg.assignment_id = aai.assignment_id AND aai.earning_policy = epl.id AND erl.egp_id = epl.id AND erl.element_type_id = pet.element_type_id AND bgrT.organization_id = asg.business_group_id AND bgrT.language = userenv('LANG') AND asg.business_group_id+0 = NVL(hr_general.get_business_group_id,asg.business_group_id) AND SYSDATE BETWEEN peo.effective_start_date AND peo.effective_end_date AND SYSDATE BETWEEN asg.effective_start_date AND asg.effective_end_date AND SYSDATE BETWEEN aai.effective_start_date AND aai.effective_end_date AND SYSDATE BETWEEN pet.effective_start_date AND pet.effective_end_date AND SYSDATE BETWEEN erl.effective_start_date AND erl.effective_end_date AND SYSDATE BETWEEN epl.effective_start_date AND epl.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, 1 PERSON_COUNT
, EPL.NAME EARNING_POLICY
, ERL.NAME EARNING_RULE
, ERL.SEQ_NO SEQUENCE_NUMBER
, HR_GENERAL.DECODE_LOOKUP('HXT_EARN_RULE_TYPE'
, ERL.EGR_TYPE) OVERTIME_TYPE
, ERL.HOURS HOURS
, ERL.DAYS DAYS
, PET.ELEMENT_NAME EARNING_CODE /********/ /* IDS */ /********/
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EPL.ID EARNING_POLICY_ID
, ERL.ID EARNING_RULE_ID
, ERL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ERL.EGP_ID OVERTIME_POLICY_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
FROM HXT_EARNING_RULES ERL
, HXT_EARNING_POLICIES EPL
, HXT_ADD_ASSIGN_INFO_F AAI
, PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, PAY_ELEMENT_TYPES_F PET
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AAI.ASSIGNMENT_ID
AND AAI.EARNING_POLICY = EPL.ID
AND ERL.EGP_ID = EPL.ID
AND ERL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID+0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID)
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN AAI.EFFECTIVE_START_DATE
AND AAI.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ERL.EFFECTIVE_START_DATE
AND ERL.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN EPL.EFFECTIVE_START_DATE
AND EPL.EFFECTIVE_END_DATE WITH READ ONLY