VIEW: APPS.EDW_HR_ASGN_ASSGNMNT_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvas.odf 120.0 2005/05/29 06:43:11 appldev noship $ */ assignment_pk ,all_fk ,name ,assignment_dp ,business_group ,assignment_number ,start_date ,end_date ,primary_flag ,instance ,assignment_id ,assignment_status_type_id ,business_group_id ,people_group_id ,effective_start_date ,effective_end_date ,title ,normal_hours_frequency ,normal_hours ,assignment_status ,assignment_type ,manager_flag ,time_normal_start ,time_normal_end ,probation_period_unit ,probation_period ,perf_review_period_frqncy ,performance_review_period ,slry_review_period_frqncy ,slry_review_period ,hourly_salaried_flag ,creation_date ,last_update_date ,null ,null ,null ,null ,null FROM edwbv_hr_asgn_assgnmnt_lcv

View Text - HTML Formatted

SELECT /* $HEADER: HRISVAS.ODF 120.0 2005/05/29 06:43:11 APPLDEV NOSHIP $ */ ASSIGNMENT_PK
, ALL_FK
, NAME
, ASSIGNMENT_DP
, BUSINESS_GROUP
, ASSIGNMENT_NUMBER
, START_DATE
, END_DATE
, PRIMARY_FLAG
, INSTANCE
, ASSIGNMENT_ID
, ASSIGNMENT_STATUS_TYPE_ID
, BUSINESS_GROUP_ID
, PEOPLE_GROUP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, TITLE
, NORMAL_HOURS_FREQUENCY
, NORMAL_HOURS
, ASSIGNMENT_STATUS
, ASSIGNMENT_TYPE
, MANAGER_FLAG
, TIME_NORMAL_START
, TIME_NORMAL_END
, PROBATION_PERIOD_UNIT
, PROBATION_PERIOD
, PERF_REVIEW_PERIOD_FRQNCY
, PERFORMANCE_REVIEW_PERIOD
, SLRY_REVIEW_PERIOD_FRQNCY
, SLRY_REVIEW_PERIOD
, HOURLY_SALARIED_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_ASGN_ASSGNMNT_LCV