eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_ELEMENT_LINKS_V

Source

View Text - Preformatted


SELECT LINK.ROWID ROW_ID ,LINK.ELEMENT_LINK_ID ,LINK.EFFECTIVE_START_DATE ,LINK.EFFECTIVE_END_DATE ,LINK.PAYROLL_ID ,PAYROLL.PAYROLL_NAME ,LINK.JOB_ID ,JBT.NAME JOB_NAME ,LINK.POSITION_ID ,PFT.NAME POSITION_NAME ,LINK.PEOPLE_GROUP_ID ,LINK.COST_ALLOCATION_KEYFLEX_ID ,LINK.ORGANIZATION_ID ,ORGANIZATIONTL.NAME ORGANIZATION_NAME ,LINK.LOCATION_ID ,LOCATIONTL.LOCATION_CODE ,LINK.GRADE_ID ,GRT.NAME GRADE_NAME ,LINK.EMPLOYMENT_CATEGORY ,CATEGORY.MEANING EMPLOYMENT_CATEGORY_NAME ,LINK.QUALIFYING_AGE ,LINK.QUALIFYING_LENGTH_OF_SERVICE ,LINK.QUALIFYING_UNITS ,UNIT.MEANING QUALIFYING_UNIT_NAME ,LINK.ELEMENT_TYPE_ID ,ELEMENTTL.ELEMENT_NAME ,ELEMENT.INPUT_CURRENCY_CODE ,ELEMENT.PROCESSING_TYPE ,ELEMENTTL.DESCRIPTION ,ELEMENT.MULTIPLE_ENTRIES_ALLOWED_FLAG ,ELEMENT.BENEFIT_CLASSIFICATION_ID ,CLASSIFICATIONTL.CLASSIFICATION_NAME ,CLASSIFICATION.COSTING_DEBIT_OR_CREDIT ,CLASSIFICATION.COSTABLE_FLAG CLASSIFICATION_COSTABLE_FLAG ,LINK.BALANCING_KEYFLEX_ID ,LINK.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID ,LINK.ELEMENT_SET_ID ,ELEMENT_SET.ELEMENT_SET_NAME ,LINK.PAY_BASIS_ID ,PAY_BASIS.NAME PAY_BASIS_NAME ,LINK.COSTABLE_TYPE ,LINK.LINK_TO_ALL_PAYROLLS_FLAG ,LINK.MULTIPLY_VALUE_FLAG ,LINK.STANDARD_LINK_FLAG ,LINK.STANDARD_LINK_FLAG OLD_STANDARD_LINK_FLAG ,LINK.TRANSFER_TO_GL_FLAG ,LINK.COMMENT_ID ,BENEFIT.CONTRIBUTIONS_USED ,LINK.ATTRIBUTE_CATEGORY ,LINK.ATTRIBUTE1 ,LINK.ATTRIBUTE2 ,LINK.ATTRIBUTE3 ,LINK.ATTRIBUTE4 ,LINK.ATTRIBUTE5 ,LINK.ATTRIBUTE6 ,LINK.ATTRIBUTE7 ,LINK.ATTRIBUTE8 ,LINK.ATTRIBUTE9 ,LINK.ATTRIBUTE10 ,LINK.ATTRIBUTE11 ,LINK.ATTRIBUTE12 ,LINK.ATTRIBUTE13 ,LINK.ATTRIBUTE14 ,LINK.ATTRIBUTE15 ,LINK.ATTRIBUTE16 ,LINK.ATTRIBUTE17 ,LINK.ATTRIBUTE18 ,LINK.ATTRIBUTE19 ,LINK.ATTRIBUTE20 ,LINK.LAST_UPDATE_DATE ,LINK.LAST_UPDATED_BY ,LINK.LAST_UPDATE_LOGIN ,LINK.CREATED_BY ,LINK.CREATION_DATE ,hr_general.decode_people_group(link.people_group_id) group_name ,to_number(null) BATCH_ELEMENT_LINK_ID ,decode(nvl(pay_batch_object_status_pkg.get_status ('EL',LINK.ELEMENT_LINK_ID),'C'),'C', 'N','Y') batch_mode ,nvl(pay_batch_object_status_pkg.get_status('EL',LINK.ELEMENT_LINK_ID),'C') link_status ,pay_batch_object_status_pkg.get_status_meaning('EL',LINK.ELEMENT_LINK_ID,'C') link_status_meaning FROM PAY_ELEMENT_LINKS_F LINK ,FND_SESSIONS CURRENT_SESSION ,PER_JOBS_TL JBT ,PER_GRADES_TL GRT ,PAY_ELEMENT_SETS ELEMENT_SET ,HR_LOCATIONS_ALL_TL LOCATIONTL ,HR_LOCATIONS_NO_JOIN LOCATION ,HR_ALL_POSITIONS_F_TL PFT ,PAY_ELEMENT_TYPES_F_TL ELEMENTTL ,PAY_ELEMENT_TYPES_F ELEMENT ,BEN_BENEFIT_CLASSIFICATIONS BENEFIT ,PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL ,PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION ,PER_PAY_BASES PAY_BASIS ,PAY_ALL_PAYROLLS_F PAYROLL ,HR_LOOKUPS UNIT ,HR_LOOKUPS CATEGORY ,HR_ALL_ORGANIZATION_UNITS_TL ORGANIZATIONTL ,HR_ALL_ORGANIZATION_UNITS ORGANIZATION WHERE LOCATIONTL.LOCATION_ID (+) =LOCATION.LOCATION_ID AND decode(LOCATIONTL.LOCATION_ID,NULL,'1',LOCATIONTL.LANGUAGE) = decode(LOCATIONTL.LOCATION_ID,NULL,'1',userenv('LANG')) AND ORGANIZATIONTL.ORGANIZATION_ID (+) = ORGANIZATION.ORGANIZATION_ID AND decode(ORGANIZATIONTL.ORGANIZATION_ID,NULL,'1', ORGANIZATIONTL.LANGUAGE) = decode(ORGANIZATIONTL.ORGANIZATION_ID,NULL,'1',userenv('LANG')) AND CLASSIFICATION.CLASSIFICATION_ID = CLASSIFICATIONTL.CLASSIFICATION_ID AND CLASSIFICATIONTL.LANGUAGE = userenv('LANG') AND ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID AND ELEMENTTL.LANGUAGE = userenv('LANG') AND (UNIT.LOOKUP_CODE(+) = LINK.QUALIFYING_UNITS AND UNIT.LOOKUP_TYPE(+) = 'QUALIFYING_UNITS' AND (UNIT.APPLICATION_ID BETWEEN 800 AND 899 OR UNIT.APPLICATION_ID IS NULL)) AND (CATEGORY.LOOKUP_CODE(+) = LINK.EMPLOYMENT_CATEGORY AND CATEGORY.LOOKUP_TYPE(+) = 'EMP_CAT' AND (CATEGORY.APPLICATION_ID BETWEEN 800 AND 899 OR CATEGORY.APPLICATION_ID IS NULL)) AND LINK.ELEMENT_TYPE_ID = ELEMENT.ELEMENT_TYPE_ID AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE AND ELEMENT.EFFECTIVE_END_DATE AND ELEMENT.CLASSIFICATION_ID = CLASSIFICATION.CLASSIFICATION_ID AND LINK.JOB_ID = JBT.JOB_ID(+) AND JBT.LANGUAGE(+) = userenv('LANG') AND LINK.GRADE_ID = GRT.GRADE_ID(+) AND GRT.LANGUAGE(+) = userenv('LANG') AND LINK.ELEMENT_SET_ID = ELEMENT_SET.ELEMENT_SET_ID(+) AND LINK.LOCATION_ID = LOCATION.LOCATION_ID(+) AND LINK.POSITION_ID = PFT.POSITION_ID(+) AND PFT.LANGUAGE(+) = userenv('LANG') AND LINK.PAY_BASIS_ID = PAY_BASIS.PAY_BASIS_ID(+) AND LINK.ORGANIZATION_ID = ORGANIZATION.ORGANIZATION_ID(+) AND ELEMENT.BENEFIT_CLASSIFICATION_ID=BENEFIT.BENEFIT_CLASSIFICATION_ID(+) AND LINK.PAYROLL_ID = PAYROLL.PAYROLL_ID(+) AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN NVL(PAYROLL.EFFECTIVE_START_DATE, CURRENT_SESSION.EFFECTIVE_DATE) AND NVL(PAYROLL.EFFECTIVE_END_DATE, CURRENT_SESSION.EFFECTIVE_DATE) AND CURRENT_SESSION.SESSION_ID = USERENV('sessionid') AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE AND LINK.EFFECTIVE_END_DATE UNION ALL /* Batch Element Links */ SELECT BEL.ROWID ROW_ID ,null ELEMENT_LINK_ID ,BEL.EFFECTIVE_DATE EFFECTIVE_START_DATE ,hr_general.end_of_time EFFECTIVE_END_DATE ,BEL.PAYROLL_ID ,hr_general.decode_payroll(bel.payroll_id) payroll_name ,bel.JOB_ID ,hr_general.decode_job(bel.job_id) job_name ,bel.POSITION_ID ,hr_general.decode_position(bel.position_id) position_name ,bel.PEOPLE_GROUP_ID ,bel.COST_ALLOCATION_KEYFLEX_ID ,bel.ORGANIZATION_ID ,hr_general.decode_organization(bel.organization_id) organization_name ,bel.LOCATION_ID ,hr_general.decode_location(bel.location_id) location_code ,bel.GRADE_ID ,hr_general.decode_grade(bel.grade_id) grade_name ,bel.EMPLOYMENT_CATEGORY ,hr_general.decode_lookup('EMP_CAT', bel.employment_category) employment_category_name ,bel.QUALIFYING_AGE ,bel.QUALIFYING_LENGTH_OF_SERVICE ,bel.QUALIFYING_UNITS ,hr_general.decode_lookup('QUALIFYING_UNITS', bel.qualifying_units) qualifying_unit_name ,BEL.ELEMENT_TYPE_ID ,ELEMENTTL.ELEMENT_NAME ,ELEMENT.INPUT_CURRENCY_CODE ,ELEMENT.PROCESSING_TYPE ,ELEMENTTL.DESCRIPTION ,ELEMENT.MULTIPLE_ENTRIES_ALLOWED_FLAG ,ELEMENT.BENEFIT_CLASSIFICATION_ID ,CLASSIFICATIONTL.CLASSIFICATION_NAME ,CLASSIFICATION.COSTING_DEBIT_OR_CREDIT ,CLASSIFICATION.COSTABLE_FLAG CLASSIFICATION_COSTABLE_FLAG ,BEL.BALANCING_KEYFLEX_ID ,BEL.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID ,BEL.ELEMENT_SET_ID ,ELEMENT_SET.ELEMENT_SET_NAME ,BEL.PAY_BASIS_ID ,hr_general.decode_pay_basis(bel.pay_basis_id) pay_basis_name ,BEL.COSTABLE_TYPE ,BEL.LINK_TO_ALL_PAYROLLS_FLAG ,BEL.MULTIPLY_VALUE_FLAG ,BEL.STANDARD_LINK_FLAG ,BEL.STANDARD_LINK_FLAG OLD_STANDARD_LINK_FLAG ,BEL.TRANSFER_TO_GL_FLAG ,BEL.COMMENT_ID ,BENEFIT.CONTRIBUTIONS_USED ,BEL.ATTRIBUTE_CATEGORY ,BEL.ATTRIBUTE1 ,BEL.ATTRIBUTE2 ,BEL.ATTRIBUTE3 ,BEL.ATTRIBUTE4 ,BEL.ATTRIBUTE5 ,BEL.ATTRIBUTE6 ,BEL.ATTRIBUTE7 ,BEL.ATTRIBUTE8 ,BEL.ATTRIBUTE9 ,BEL.ATTRIBUTE10 ,BEL.ATTRIBUTE11 ,BEL.ATTRIBUTE12 ,BEL.ATTRIBUTE13 ,BEL.ATTRIBUTE14 ,BEL.ATTRIBUTE15 ,BEL.ATTRIBUTE16 ,BEL.ATTRIBUTE17 ,BEL.ATTRIBUTE18 ,BEL.ATTRIBUTE19 ,BEL.ATTRIBUTE20 ,BEL.LAST_UPDATE_DATE ,BEL.LAST_UPDATED_BY ,BEL.LAST_UPDATE_LOGIN ,BEL.CREATED_BY ,BEL.CREATION_DATE ,hr_general.decode_people_group(bel.people_group_id) group_name ,BEL.BATCH_ELEMENT_LINK_ID ,'Y' BATCH_MODE ,nvl(pay_batch_object_status_pkg.get_status ('BEL',BEL.BATCH_ELEMENT_LINK_ID),'U') link_status ,pay_batch_object_status_pkg.get_status_meaning ('BEL',BEL.BATCH_ELEMENT_LINK_ID,'U') link_status_meaning FROM PAY_BATCH_ELEMENT_LINKS BEL ,FND_SESSIONS CURRENT_SESSION ,PAY_ELEMENT_SETS ELEMENT_SET ,PAY_ELEMENT_TYPES_F_TL ELEMENTTL ,PAY_ELEMENT_TYPES_F ELEMENT ,BEN_BENEFIT_CLASSIFICATIONS BENEFIT ,PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL ,PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION WHERE CLASSIFICATION.CLASSIFICATION_ID = CLASSIFICATIONTL.CLASSIFICATION_ID AND CLASSIFICATIONTL.LANGUAGE = userenv('LANG') AND ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID AND ELEMENTTL.LANGUAGE = userenv('LANG') AND BEL.ELEMENT_TYPE_ID = ELEMENT.ELEMENT_TYPE_ID AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE AND ELEMENT.EFFECTIVE_END_DATE AND ELEMENT.CLASSIFICATION_ID = CLASSIFICATION.CLASSIFICATION_ID AND BEL.ELEMENT_SET_ID = ELEMENT_SET.ELEMENT_SET_ID(+) AND ELEMENT.BENEFIT_CLASSIFICATION_ID=BENEFIT.BENEFIT_CLASSIFICATION_ID(+) AND CURRENT_SESSION.SESSION_ID = USERENV('sessionid') AND CURRENT_SESSION.EFFECTIVE_DATE >= BEL.EFFECTIVE_DATE AND BEL.ELEMENT_LINK_ID IS NULL

View Text - HTML Formatted

SELECT LINK.ROWID ROW_ID
, LINK.ELEMENT_LINK_ID
, LINK.EFFECTIVE_START_DATE
, LINK.EFFECTIVE_END_DATE
, LINK.PAYROLL_ID
, PAYROLL.PAYROLL_NAME
, LINK.JOB_ID
, JBT.NAME JOB_NAME
, LINK.POSITION_ID
, PFT.NAME POSITION_NAME
, LINK.PEOPLE_GROUP_ID
, LINK.COST_ALLOCATION_KEYFLEX_ID
, LINK.ORGANIZATION_ID
, ORGANIZATIONTL.NAME ORGANIZATION_NAME
, LINK.LOCATION_ID
, LOCATIONTL.LOCATION_CODE
, LINK.GRADE_ID
, GRT.NAME GRADE_NAME
, LINK.EMPLOYMENT_CATEGORY
, CATEGORY.MEANING EMPLOYMENT_CATEGORY_NAME
, LINK.QUALIFYING_AGE
, LINK.QUALIFYING_LENGTH_OF_SERVICE
, LINK.QUALIFYING_UNITS
, UNIT.MEANING QUALIFYING_UNIT_NAME
, LINK.ELEMENT_TYPE_ID
, ELEMENTTL.ELEMENT_NAME
, ELEMENT.INPUT_CURRENCY_CODE
, ELEMENT.PROCESSING_TYPE
, ELEMENTTL.DESCRIPTION
, ELEMENT.MULTIPLE_ENTRIES_ALLOWED_FLAG
, ELEMENT.BENEFIT_CLASSIFICATION_ID
, CLASSIFICATIONTL.CLASSIFICATION_NAME
, CLASSIFICATION.COSTING_DEBIT_OR_CREDIT
, CLASSIFICATION.COSTABLE_FLAG CLASSIFICATION_COSTABLE_FLAG
, LINK.BALANCING_KEYFLEX_ID
, LINK.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, LINK.ELEMENT_SET_ID
, ELEMENT_SET.ELEMENT_SET_NAME
, LINK.PAY_BASIS_ID
, PAY_BASIS.NAME PAY_BASIS_NAME
, LINK.COSTABLE_TYPE
, LINK.LINK_TO_ALL_PAYROLLS_FLAG
, LINK.MULTIPLY_VALUE_FLAG
, LINK.STANDARD_LINK_FLAG
, LINK.STANDARD_LINK_FLAG OLD_STANDARD_LINK_FLAG
, LINK.TRANSFER_TO_GL_FLAG
, LINK.COMMENT_ID
, BENEFIT.CONTRIBUTIONS_USED
, LINK.ATTRIBUTE_CATEGORY
, LINK.ATTRIBUTE1
, LINK.ATTRIBUTE2
, LINK.ATTRIBUTE3
, LINK.ATTRIBUTE4
, LINK.ATTRIBUTE5
, LINK.ATTRIBUTE6
, LINK.ATTRIBUTE7
, LINK.ATTRIBUTE8
, LINK.ATTRIBUTE9
, LINK.ATTRIBUTE10
, LINK.ATTRIBUTE11
, LINK.ATTRIBUTE12
, LINK.ATTRIBUTE13
, LINK.ATTRIBUTE14
, LINK.ATTRIBUTE15
, LINK.ATTRIBUTE16
, LINK.ATTRIBUTE17
, LINK.ATTRIBUTE18
, LINK.ATTRIBUTE19
, LINK.ATTRIBUTE20
, LINK.LAST_UPDATE_DATE
, LINK.LAST_UPDATED_BY
, LINK.LAST_UPDATE_LOGIN
, LINK.CREATED_BY
, LINK.CREATION_DATE
, HR_GENERAL.DECODE_PEOPLE_GROUP(LINK.PEOPLE_GROUP_ID) GROUP_NAME
, TO_NUMBER(NULL) BATCH_ELEMENT_LINK_ID
, DECODE(NVL(PAY_BATCH_OBJECT_STATUS_PKG.GET_STATUS ('EL'
, LINK.ELEMENT_LINK_ID)
, 'C')
, 'C'
, 'N'
, 'Y') BATCH_MODE
, NVL(PAY_BATCH_OBJECT_STATUS_PKG.GET_STATUS('EL'
, LINK.ELEMENT_LINK_ID)
, 'C') LINK_STATUS
, PAY_BATCH_OBJECT_STATUS_PKG.GET_STATUS_MEANING('EL'
, LINK.ELEMENT_LINK_ID
, 'C') LINK_STATUS_MEANING
FROM PAY_ELEMENT_LINKS_F LINK
, FND_SESSIONS CURRENT_SESSION
, PER_JOBS_TL JBT
, PER_GRADES_TL GRT
, PAY_ELEMENT_SETS ELEMENT_SET
, HR_LOCATIONS_ALL_TL LOCATIONTL
, HR_LOCATIONS_NO_JOIN LOCATION
, HR_ALL_POSITIONS_F_TL PFT
, PAY_ELEMENT_TYPES_F_TL ELEMENTTL
, PAY_ELEMENT_TYPES_F ELEMENT
, BEN_BENEFIT_CLASSIFICATIONS BENEFIT
, PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL
, PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION
, PER_PAY_BASES PAY_BASIS
, PAY_ALL_PAYROLLS_F PAYROLL
, HR_LOOKUPS UNIT
, HR_LOOKUPS CATEGORY
, HR_ALL_ORGANIZATION_UNITS_TL ORGANIZATIONTL
, HR_ALL_ORGANIZATION_UNITS ORGANIZATION
WHERE LOCATIONTL.LOCATION_ID (+) =LOCATION.LOCATION_ID
AND DECODE(LOCATIONTL.LOCATION_ID
, NULL
, '1'
, LOCATIONTL.LANGUAGE) = DECODE(LOCATIONTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND ORGANIZATIONTL.ORGANIZATION_ID (+) = ORGANIZATION.ORGANIZATION_ID
AND DECODE(ORGANIZATIONTL.ORGANIZATION_ID
, NULL
, '1'
, ORGANIZATIONTL.LANGUAGE) = DECODE(ORGANIZATIONTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND CLASSIFICATION.CLASSIFICATION_ID = CLASSIFICATIONTL.CLASSIFICATION_ID
AND CLASSIFICATIONTL.LANGUAGE = USERENV('LANG')
AND ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
AND ELEMENTTL.LANGUAGE = USERENV('LANG')
AND (UNIT.LOOKUP_CODE(+) = LINK.QUALIFYING_UNITS
AND UNIT.LOOKUP_TYPE(+) = 'QUALIFYING_UNITS'
AND (UNIT.APPLICATION_ID BETWEEN 800
AND 899 OR UNIT.APPLICATION_ID IS NULL))
AND (CATEGORY.LOOKUP_CODE(+) = LINK.EMPLOYMENT_CATEGORY
AND CATEGORY.LOOKUP_TYPE(+) = 'EMP_CAT'
AND (CATEGORY.APPLICATION_ID BETWEEN 800
AND 899 OR CATEGORY.APPLICATION_ID IS NULL))
AND LINK.ELEMENT_TYPE_ID = ELEMENT.ELEMENT_TYPE_ID
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND ELEMENT.CLASSIFICATION_ID = CLASSIFICATION.CLASSIFICATION_ID
AND LINK.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND LINK.GRADE_ID = GRT.GRADE_ID(+)
AND GRT.LANGUAGE(+) = USERENV('LANG')
AND LINK.ELEMENT_SET_ID = ELEMENT_SET.ELEMENT_SET_ID(+)
AND LINK.LOCATION_ID = LOCATION.LOCATION_ID(+)
AND LINK.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND LINK.PAY_BASIS_ID = PAY_BASIS.PAY_BASIS_ID(+)
AND LINK.ORGANIZATION_ID = ORGANIZATION.ORGANIZATION_ID(+)
AND ELEMENT.BENEFIT_CLASSIFICATION_ID=BENEFIT.BENEFIT_CLASSIFICATION_ID(+)
AND LINK.PAYROLL_ID = PAYROLL.PAYROLL_ID(+)
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN NVL(PAYROLL.EFFECTIVE_START_DATE
, CURRENT_SESSION.EFFECTIVE_DATE)
AND NVL(PAYROLL.EFFECTIVE_END_DATE
, CURRENT_SESSION.EFFECTIVE_DATE)
AND CURRENT_SESSION.SESSION_ID = USERENV('SESSIONID')
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE UNION ALL /* BATCH ELEMENT LINKS */ SELECT BEL.ROWID ROW_ID
, NULL ELEMENT_LINK_ID
, BEL.EFFECTIVE_DATE EFFECTIVE_START_DATE
, HR_GENERAL.END_OF_TIME EFFECTIVE_END_DATE
, BEL.PAYROLL_ID
, HR_GENERAL.DECODE_PAYROLL(BEL.PAYROLL_ID) PAYROLL_NAME
, BEL.JOB_ID
, HR_GENERAL.DECODE_JOB(BEL.JOB_ID) JOB_NAME
, BEL.POSITION_ID
, HR_GENERAL.DECODE_POSITION(BEL.POSITION_ID) POSITION_NAME
, BEL.PEOPLE_GROUP_ID
, BEL.COST_ALLOCATION_KEYFLEX_ID
, BEL.ORGANIZATION_ID
, HR_GENERAL.DECODE_ORGANIZATION(BEL.ORGANIZATION_ID) ORGANIZATION_NAME
, BEL.LOCATION_ID
, HR_GENERAL.DECODE_LOCATION(BEL.LOCATION_ID) LOCATION_CODE
, BEL.GRADE_ID
, HR_GENERAL.DECODE_GRADE(BEL.GRADE_ID) GRADE_NAME
, BEL.EMPLOYMENT_CATEGORY
, HR_GENERAL.DECODE_LOOKUP('EMP_CAT'
, BEL.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY_NAME
, BEL.QUALIFYING_AGE
, BEL.QUALIFYING_LENGTH_OF_SERVICE
, BEL.QUALIFYING_UNITS
, HR_GENERAL.DECODE_LOOKUP('QUALIFYING_UNITS'
, BEL.QUALIFYING_UNITS) QUALIFYING_UNIT_NAME
, BEL.ELEMENT_TYPE_ID
, ELEMENTTL.ELEMENT_NAME
, ELEMENT.INPUT_CURRENCY_CODE
, ELEMENT.PROCESSING_TYPE
, ELEMENTTL.DESCRIPTION
, ELEMENT.MULTIPLE_ENTRIES_ALLOWED_FLAG
, ELEMENT.BENEFIT_CLASSIFICATION_ID
, CLASSIFICATIONTL.CLASSIFICATION_NAME
, CLASSIFICATION.COSTING_DEBIT_OR_CREDIT
, CLASSIFICATION.COSTABLE_FLAG CLASSIFICATION_COSTABLE_FLAG
, BEL.BALANCING_KEYFLEX_ID
, BEL.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BEL.ELEMENT_SET_ID
, ELEMENT_SET.ELEMENT_SET_NAME
, BEL.PAY_BASIS_ID
, HR_GENERAL.DECODE_PAY_BASIS(BEL.PAY_BASIS_ID) PAY_BASIS_NAME
, BEL.COSTABLE_TYPE
, BEL.LINK_TO_ALL_PAYROLLS_FLAG
, BEL.MULTIPLY_VALUE_FLAG
, BEL.STANDARD_LINK_FLAG
, BEL.STANDARD_LINK_FLAG OLD_STANDARD_LINK_FLAG
, BEL.TRANSFER_TO_GL_FLAG
, BEL.COMMENT_ID
, BENEFIT.CONTRIBUTIONS_USED
, BEL.ATTRIBUTE_CATEGORY
, BEL.ATTRIBUTE1
, BEL.ATTRIBUTE2
, BEL.ATTRIBUTE3
, BEL.ATTRIBUTE4
, BEL.ATTRIBUTE5
, BEL.ATTRIBUTE6
, BEL.ATTRIBUTE7
, BEL.ATTRIBUTE8
, BEL.ATTRIBUTE9
, BEL.ATTRIBUTE10
, BEL.ATTRIBUTE11
, BEL.ATTRIBUTE12
, BEL.ATTRIBUTE13
, BEL.ATTRIBUTE14
, BEL.ATTRIBUTE15
, BEL.ATTRIBUTE16
, BEL.ATTRIBUTE17
, BEL.ATTRIBUTE18
, BEL.ATTRIBUTE19
, BEL.ATTRIBUTE20
, BEL.LAST_UPDATE_DATE
, BEL.LAST_UPDATED_BY
, BEL.LAST_UPDATE_LOGIN
, BEL.CREATED_BY
, BEL.CREATION_DATE
, HR_GENERAL.DECODE_PEOPLE_GROUP(BEL.PEOPLE_GROUP_ID) GROUP_NAME
, BEL.BATCH_ELEMENT_LINK_ID
, 'Y' BATCH_MODE
, NVL(PAY_BATCH_OBJECT_STATUS_PKG.GET_STATUS ('BEL'
, BEL.BATCH_ELEMENT_LINK_ID)
, 'U') LINK_STATUS
, PAY_BATCH_OBJECT_STATUS_PKG.GET_STATUS_MEANING ('BEL'
, BEL.BATCH_ELEMENT_LINK_ID
, 'U') LINK_STATUS_MEANING
FROM PAY_BATCH_ELEMENT_LINKS BEL
, FND_SESSIONS CURRENT_SESSION
, PAY_ELEMENT_SETS ELEMENT_SET
, PAY_ELEMENT_TYPES_F_TL ELEMENTTL
, PAY_ELEMENT_TYPES_F ELEMENT
, BEN_BENEFIT_CLASSIFICATIONS BENEFIT
, PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL
, PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION
WHERE CLASSIFICATION.CLASSIFICATION_ID = CLASSIFICATIONTL.CLASSIFICATION_ID
AND CLASSIFICATIONTL.LANGUAGE = USERENV('LANG')
AND ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
AND ELEMENTTL.LANGUAGE = USERENV('LANG')
AND BEL.ELEMENT_TYPE_ID = ELEMENT.ELEMENT_TYPE_ID
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND ELEMENT.CLASSIFICATION_ID = CLASSIFICATION.CLASSIFICATION_ID
AND BEL.ELEMENT_SET_ID = ELEMENT_SET.ELEMENT_SET_ID(+)
AND ELEMENT.BENEFIT_CLASSIFICATION_ID=BENEFIT.BENEFIT_CLASSIFICATION_ID(+)
AND CURRENT_SESSION.SESSION_ID = USERENV('SESSIONID')
AND CURRENT_SESSION.EFFECTIVE_DATE >= BEL.EFFECTIVE_DATE
AND BEL.ELEMENT_LINK_ID IS NULL