VIEW: APPS.PAY_KR_ASG_LEAVE_BALANCES_V

Source

View Text - Preformatted

SELECT aa.Assignment_Action_Id Assignment_Action_Id ,aa.Assignment_Id Assignment_Id ,ap.Accrual_Plan_Id Accrual_Plan_Id ,ap.Accrual_Plan_Name Accrual_Plan_Name ,pa.Effective_Date Effective_Date ,tp.Start_Date Start_Date ,tp.End_Date End_Date ,pa.Payroll_Id Payroll_Id ,ap.Business_Group_Id Business_Group_Id ,hl.Meaning Accrual_Units_Of_Measure ,oi.Org_Information13 Leave_Taken_Dim From Pay_Assignment_Actions aa ,Pay_Payroll_Actions pa ,Pay_Accrual_Plans ap ,Pay_Element_Types_F et ,Pay_Element_Links_F el ,Pay_Element_Entries_F ee ,Per_Time_Periods tp ,Hr_Lookups hl ,Hr_Organization_Information oi WHERE et.Element_Type_Id = ap.Accrual_Plan_Element_Type_Id And el.Element_Type_Id = et.Element_Type_Id And ee.Element_Link_Id = el.Element_Link_Id And aa.Assignment_Id = ee.Assignment_Id And pa.Payroll_Action_Id = aa.Payroll_Action_Id And pa.action_type In ('R','Q') And pa.action_status = 'C' And tp.Payroll_Id = pa.Payroll_Id And ap.Accrual_Units_Of_Measure = hl.Lookup_Code And hl.Lookup_type = 'HOURS_OR_DAYS' And aa.Tax_Unit_Id = oi.Organization_Id And oi.Org_Information_Context = 'KR_BUSINESS_PLACE_REGISTRATION' And pa.date_Earned between tp.Start_Date And tp.End_Date And pa.Effective_Date between et.Effective_Start_Date and et.Effective_End_Date And pa.Effective_Date between el.Effective_Start_Date and el.Effective_End_Date And pa.Effective_Date between ee.Effective_Start_Date and ee.Effective_End_Date

View Text - HTML Formatted

SELECT AA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, AA.ASSIGNMENT_ID ASSIGNMENT_ID
, AP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, AP.ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME
, PA.EFFECTIVE_DATE EFFECTIVE_DATE
, TP.START_DATE START_DATE
, TP.END_DATE END_DATE
, PA.PAYROLL_ID PAYROLL_ID
, AP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HL.MEANING ACCRUAL_UNITS_OF_MEASURE
, OI.ORG_INFORMATION13 LEAVE_TAKEN_DIM
FROM PAY_ASSIGNMENT_ACTIONS AA
, PAY_PAYROLL_ACTIONS PA
, PAY_ACCRUAL_PLANS AP
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_LINKS_F EL
, PAY_ELEMENT_ENTRIES_F EE
, PER_TIME_PERIODS TP
, HR_LOOKUPS HL
, HR_ORGANIZATION_INFORMATION OI
WHERE ET.ELEMENT_TYPE_ID = AP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
AND EL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
AND EE.ELEMENT_LINK_ID = EL.ELEMENT_LINK_ID
AND AA.ASSIGNMENT_ID = EE.ASSIGNMENT_ID
AND PA.PAYROLL_ACTION_ID = AA.PAYROLL_ACTION_ID
AND PA.ACTION_TYPE IN ('R'
, 'Q')
AND PA.ACTION_STATUS = 'C'
AND TP.PAYROLL_ID = PA.PAYROLL_ID
AND AP.ACCRUAL_UNITS_OF_MEASURE = HL.LOOKUP_CODE
AND HL.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND AA.TAX_UNIT_ID = OI.ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT = 'KR_BUSINESS_PLACE_REGISTRATION'
AND PA.DATE_EARNED BETWEEN TP.START_DATE
AND TP.END_DATE
AND PA.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND PA.EFFECTIVE_DATE BETWEEN EL.EFFECTIVE_START_DATE
AND EL.EFFECTIVE_END_DATE
AND PA.EFFECTIVE_DATE BETWEEN EE.EFFECTIVE_START_DATE
AND EE.EFFECTIVE_END_DATE