VIEW: APPS.HRFV_ASSIGNMENT_COSTS

Source

View Text - Preformatted

SELECT bgrt.name business_group_name ,peo.full_name person_name ,ass.assignment_number assignment_number ,cost.proportion costing_proportion ,cost.effective_start_date costing_date_from ,hr_discoverer.check_end_date( cost.effective_end_date) costing_date_to ,orgt.name organization_name ,jbt.name job_name ,pft.name pos_name ,gdt.name grade_name ,loct.location_code location_name ,peo.employee_number employee_number ,'_KF:PAY:COST:ckey' ,cost.assignment_id assignment_id ,ass.business_group_id business_group_id ,peo.person_id person_id FROM pay_cost_allocation_keyflex ckey ,hr_all_organization_units_tl orgt ,hr_all_organization_units_tl bgrt ,per_jobs_tl jbt ,hr_all_positions_f_tl pft ,per_grades_tl gdt ,hr_locations_all_tl loct ,per_people_x peo ,pay_cost_allocations_f cost ,per_assignments_x ass WHERE cost.cost_allocation_keyflex_id = ckey.cost_allocation_keyflex_id AND ass.assignment_id = cost.assignment_id AND ass.organization_id = orgt.organization_id AND orgt.language = userenv('LANG') AND ass.job_id = jbt.job_id(+) AND jbt.language(+) = userenv('LANG') AND ass.position_id = pft.position_id(+) AND pft.language(+) = userenv('LANG') AND ass.grade_id = gdt.grade_id(+) AND gdt.language(+) = userenv('LANG') AND ass.location_id = loct.location_id(+) AND loct.language (+) = userenv('LANG') AND ass.person_id = peo.person_id AND ass.business_group_id = bgrt.organization_id AND bgrt.language = userenv('LANG') AND ass.assignment_type = 'E' AND ass.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, COST.PROPORTION COSTING_PROPORTION
, COST.EFFECTIVE_START_DATE COSTING_DATE_FROM
, HR_DISCOVERER.CHECK_END_DATE( COST.EFFECTIVE_END_DATE) COSTING_DATE_TO
, ORGT.NAME ORGANIZATION_NAME
, JBT.NAME JOB_NAME
, PFT.NAME POS_NAME
, GDT.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, '_KF:PAY:COST:CKEY'
, COST.ASSIGNMENT_ID ASSIGNMENT_ID
, ASS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
FROM PAY_COST_ALLOCATION_KEYFLEX CKEY
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, HR_LOCATIONS_ALL_TL LOCT
, PER_PEOPLE_X PEO
, PAY_COST_ALLOCATIONS_F COST
, PER_ASSIGNMENTS_X ASS
WHERE COST.COST_ALLOCATION_KEYFLEX_ID = CKEY.COST_ALLOCATION_KEYFLEX_ID
AND ASS.ASSIGNMENT_ID = COST.ASSIGNMENT_ID
AND ASS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ASS.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND ASS.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND ASS.GRADE_ID = GDT.GRADE_ID(+)
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND ASS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ASS.PERSON_ID = PEO.PERSON_ID
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASS.ASSIGNMENT_TYPE = 'E'
AND ASS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASS.BUSINESS_GROUP_ID) WITH READ ONLY