VIEW: APPS.PAY_VIEW_NET_CALC_RULES_V

Source

View Text - Preformatted

SELECT 1 , 0 , PAP1.ACCRUAL_PLAN_ID , 0 , 'Accrual Plan' , PAP1.ACCRUAL_PLAN_ELEMENT_TYPE_ID , PAP1.ACCRUAL_PLAN_NAME , '1' , HRL1.MEANING , PAP1.ACCRUAL_UNITS_OF_MEASURE , HRL2.MEANING ,null absence_attendance_type_id FROM HR_LOOKUPS HRL1, HR_LOOKUPS HRL2, PAY_ACCRUAL_PLANS PAP1 WHERE HRL1.LOOKUP_CODE = '1' AND HRL1.LOOKUP_TYPE = 'ADD_SUBTRACT' AND HRL2.LOOKUP_CODE = PAP1.ACCRUAL_UNITS_OF_MEASURE AND HRL2.LOOKUP_TYPE = 'HOURS_OR_DAYS' UNION SELECT 2, NCR1.NET_CALCULATION_RULE_ID, NCR1.ACCRUAL_PLAN_ID, NCR1.INPUT_VALUE_ID, PIV1.NAME, PET1.ELEMENT_TYPE_ID, PET1.ELEMENT_NAME, NCR1.ADD_OR_SUBTRACT, HRL4.MEANING, PAP2.ACCRUAL_UNITS_OF_MEASURE, HRL3.MEANING, NCR1.absence_attendance_type_id absence_attendance_type_id FROM PAY_ELEMENT_TYPES_F_TL PET1TL, PAY_INPUT_VALUES_F_TL PIV1TL, HR_LOOKUPS HRL4, HR_LOOKUPS HRL3, PAY_ELEMENT_TYPES_F PET1, PAY_INPUT_VALUES_F PIV1, PAY_NET_CALCULATION_RULES NCR1, PAY_ACCRUAL_PLANS PAP2, FND_SESSIONS SES1 WHERE PIV1TL.input_value_id = PIV1.input_value_id and PIV1TL.LANGUAGE = userenv('LANG') and PET1.element_type_id = PET1TL.element_type_id and PET1TL.language = userenv('LANG') and HRL4.LOOKUP_CODE = NCR1.ADD_OR_SUBTRACT AND HRL4.LOOKUP_TYPE = 'ADD_SUBTRACT' AND HRL3.LOOKUP_CODE = PAP2.ACCRUAL_UNITS_OF_MEASURE AND HRL3.LOOKUP_TYPE = 'HOURS_OR_DAYS' AND SES1.EFFECTIVE_DATE BETWEEN PET1.EFFECTIVE_START_DATE AND PET1.EFFECTIVE_END_DATE AND PET1.ELEMENT_TYPE_ID = PIV1.ELEMENT_TYPE_ID AND SES1.EFFECTIVE_DATE BETWEEN PIV1.EFFECTIVE_START_DATE AND PIV1.EFFECTIVE_END_DATE AND PIV1.INPUT_VALUE_ID = NCR1.INPUT_VALUE_ID AND NCR1.ACCRUAL_PLAN_ID = PAP2.ACCRUAL_PLAN_ID AND NCR1.INPUT_VALUE_ID = PAP2.CO_INPUT_VALUE_ID AND SES1.SESSION_ID = USERENV('SESSIONID') UNION SELECT 3, NCR2.NET_CALCULATION_RULE_ID, NCR2.ACCRUAL_PLAN_ID, NCR2.INPUT_VALUE_ID, PIV2.NAME, PET2.ELEMENT_TYPE_ID, PET2.ELEMENT_NAME, NCR2.ADD_OR_SUBTRACT, HRL6.MEANING, PAP3.ACCRUAL_UNITS_OF_MEASURE, HRL5.MEANING, NCR2.absence_attendance_type_id absence_attendance_type_id FROM PAY_INPUT_VALUES_F_TL PIV2TL, PAY_ELEMENT_TYPES_F_TL PET2TL, HR_LOOKUPS HRL6, HR_LOOKUPS HRL5, PAY_ELEMENT_TYPES_F PET2, PAY_INPUT_VALUES_F PIV2, PAY_NET_CALCULATION_RULES NCR2, PAY_ACCRUAL_PLANS PAP3, FND_SESSIONS SES2 WHERE PIV2TL.input_value_id = PIV2.input_value_id and PIV2TL.LANGUAGE = userenv('LANG') and PET2.element_type_id = PET2TL.element_type_id and PET2TL.language = userenv('LANG') and HRL6.LOOKUP_CODE = NCR2.ADD_OR_SUBTRACT AND HRL6.LOOKUP_TYPE = 'ADD_SUBTRACT' AND HRL5.LOOKUP_CODE = PAP3.ACCRUAL_UNITS_OF_MEASURE AND HRL5.LOOKUP_TYPE = 'HOURS_OR_DAYS' AND SES2.EFFECTIVE_DATE BETWEEN PET2.EFFECTIVE_START_DATE AND PET2.EFFECTIVE_END_DATE AND PET2.ELEMENT_TYPE_ID = PIV2.ELEMENT_TYPE_ID AND SES2.EFFECTIVE_DATE BETWEEN PIV2.EFFECTIVE_START_DATE AND PIV2.EFFECTIVE_END_DATE AND PIV2.INPUT_VALUE_ID = NCR2.INPUT_VALUE_ID AND NCR2.ACCRUAL_PLAN_ID = PAP3.ACCRUAL_PLAN_ID AND NCR2.INPUT_VALUE_ID != PAP3.CO_INPUT_VALUE_ID AND SES2.SESSION_ID = USERENV('SESSIONID')

View Text - HTML Formatted

SELECT 1
, 0
, PAP1.ACCRUAL_PLAN_ID
, 0
, 'ACCRUAL PLAN'
, PAP1.ACCRUAL_PLAN_ELEMENT_TYPE_ID
, PAP1.ACCRUAL_PLAN_NAME
, '1'
, HRL1.MEANING
, PAP1.ACCRUAL_UNITS_OF_MEASURE
, HRL2.MEANING
, NULL ABSENCE_ATTENDANCE_TYPE_ID
FROM HR_LOOKUPS HRL1
, HR_LOOKUPS HRL2
, PAY_ACCRUAL_PLANS PAP1
WHERE HRL1.LOOKUP_CODE = '1'
AND HRL1.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HRL2.LOOKUP_CODE = PAP1.ACCRUAL_UNITS_OF_MEASURE
AND HRL2.LOOKUP_TYPE = 'HOURS_OR_DAYS' UNION SELECT 2
, NCR1.NET_CALCULATION_RULE_ID
, NCR1.ACCRUAL_PLAN_ID
, NCR1.INPUT_VALUE_ID
, PIV1.NAME
, PET1.ELEMENT_TYPE_ID
, PET1.ELEMENT_NAME
, NCR1.ADD_OR_SUBTRACT
, HRL4.MEANING
, PAP2.ACCRUAL_UNITS_OF_MEASURE
, HRL3.MEANING
, NCR1.ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID
FROM PAY_ELEMENT_TYPES_F_TL PET1TL
, PAY_INPUT_VALUES_F_TL PIV1TL
, HR_LOOKUPS HRL4
, HR_LOOKUPS HRL3
, PAY_ELEMENT_TYPES_F PET1
, PAY_INPUT_VALUES_F PIV1
, PAY_NET_CALCULATION_RULES NCR1
, PAY_ACCRUAL_PLANS PAP2
, FND_SESSIONS SES1
WHERE PIV1TL.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND PIV1TL.LANGUAGE = USERENV('LANG')
AND PET1.ELEMENT_TYPE_ID = PET1TL.ELEMENT_TYPE_ID
AND PET1TL.LANGUAGE = USERENV('LANG')
AND HRL4.LOOKUP_CODE = NCR1.ADD_OR_SUBTRACT
AND HRL4.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HRL3.LOOKUP_CODE = PAP2.ACCRUAL_UNITS_OF_MEASURE
AND HRL3.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND SES1.EFFECTIVE_DATE BETWEEN PET1.EFFECTIVE_START_DATE
AND PET1.EFFECTIVE_END_DATE
AND PET1.ELEMENT_TYPE_ID = PIV1.ELEMENT_TYPE_ID
AND SES1.EFFECTIVE_DATE BETWEEN PIV1.EFFECTIVE_START_DATE
AND PIV1.EFFECTIVE_END_DATE
AND PIV1.INPUT_VALUE_ID = NCR1.INPUT_VALUE_ID
AND NCR1.ACCRUAL_PLAN_ID = PAP2.ACCRUAL_PLAN_ID
AND NCR1.INPUT_VALUE_ID = PAP2.CO_INPUT_VALUE_ID
AND SES1.SESSION_ID = USERENV('SESSIONID') UNION SELECT 3
, NCR2.NET_CALCULATION_RULE_ID
, NCR2.ACCRUAL_PLAN_ID
, NCR2.INPUT_VALUE_ID
, PIV2.NAME
, PET2.ELEMENT_TYPE_ID
, PET2.ELEMENT_NAME
, NCR2.ADD_OR_SUBTRACT
, HRL6.MEANING
, PAP3.ACCRUAL_UNITS_OF_MEASURE
, HRL5.MEANING
, NCR2.ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID
FROM PAY_INPUT_VALUES_F_TL PIV2TL
, PAY_ELEMENT_TYPES_F_TL PET2TL
, HR_LOOKUPS HRL6
, HR_LOOKUPS HRL5
, PAY_ELEMENT_TYPES_F PET2
, PAY_INPUT_VALUES_F PIV2
, PAY_NET_CALCULATION_RULES NCR2
, PAY_ACCRUAL_PLANS PAP3
, FND_SESSIONS SES2
WHERE PIV2TL.INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID
AND PIV2TL.LANGUAGE = USERENV('LANG')
AND PET2.ELEMENT_TYPE_ID = PET2TL.ELEMENT_TYPE_ID
AND PET2TL.LANGUAGE = USERENV('LANG')
AND HRL6.LOOKUP_CODE = NCR2.ADD_OR_SUBTRACT
AND HRL6.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HRL5.LOOKUP_CODE = PAP3.ACCRUAL_UNITS_OF_MEASURE
AND HRL5.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND SES2.EFFECTIVE_DATE BETWEEN PET2.EFFECTIVE_START_DATE
AND PET2.EFFECTIVE_END_DATE
AND PET2.ELEMENT_TYPE_ID = PIV2.ELEMENT_TYPE_ID
AND SES2.EFFECTIVE_DATE BETWEEN PIV2.EFFECTIVE_START_DATE
AND PIV2.EFFECTIVE_END_DATE
AND PIV2.INPUT_VALUE_ID = NCR2.INPUT_VALUE_ID
AND NCR2.ACCRUAL_PLAN_ID = PAP3.ACCRUAL_PLAN_ID
AND NCR2.INPUT_VALUE_ID != PAP3.CO_INPUT_VALUE_ID
AND SES2.SESSION_ID = USERENV('SESSIONID')