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_IN_SCL_DETAILS_V

Source

View Text - Preformatted


SELECT scl.segment1, pay_in_utils.get_organization_name(scl.segment2) PF_Organization, pay_in_utils.get_organization_name(scl.segment3) Professional_Tax_Organization, pay_in_utils.get_organization_name(scl.segment4) ESI_Organization, pay_in_utils.get_organization_name(scl.segment5) Factory, pay_in_utils.get_organization_name(scl.segment6) Establishment, hr_general.decode_lookup('YES_NO',scl.segment8) Covered_by_Gratuity_Act, hr_general.decode_lookup('YES_NO',scl.segment9) Substantial_Interest, hr_general.decode_lookup('YES_NO',scl.segment10) Director, hr_general.decode_lookup('YES_NO',scl.segment11) Specified_Employee, hr_general.decode_lookup('IN_CONTRIBUTION',scl.segment12) PF_EPS_Contribution, (SELECT rule_type FROM pay_legislation_rules WHERE legislation_code = 'IN' AND rule_mode = fnd_number.number_to_canonical(scl.id_flex_num) )rule_type, asg.effective_start_date, asg.effective_end_date, asg.assignment_id, asg.person_id FROM hr_soft_coding_keyflex scl ,per_assignments_f asg WHERE scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

View Text - HTML Formatted

SELECT SCL.SEGMENT1
, PAY_IN_UTILS.GET_ORGANIZATION_NAME(SCL.SEGMENT2) PF_ORGANIZATION
, PAY_IN_UTILS.GET_ORGANIZATION_NAME(SCL.SEGMENT3) PROFESSIONAL_TAX_ORGANIZATION
, PAY_IN_UTILS.GET_ORGANIZATION_NAME(SCL.SEGMENT4) ESI_ORGANIZATION
, PAY_IN_UTILS.GET_ORGANIZATION_NAME(SCL.SEGMENT5) FACTORY
, PAY_IN_UTILS.GET_ORGANIZATION_NAME(SCL.SEGMENT6) ESTABLISHMENT
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, SCL.SEGMENT8) COVERED_BY_GRATUITY_ACT
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, SCL.SEGMENT9) SUBSTANTIAL_INTEREST
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, SCL.SEGMENT10) DIRECTOR
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, SCL.SEGMENT11) SPECIFIED_EMPLOYEE
, HR_GENERAL.DECODE_LOOKUP('IN_CONTRIBUTION'
, SCL.SEGMENT12) PF_EPS_CONTRIBUTION
, (SELECT RULE_TYPE
FROM PAY_LEGISLATION_RULES
WHERE LEGISLATION_CODE = 'IN'
AND RULE_MODE = FND_NUMBER.NUMBER_TO_CANONICAL(SCL.ID_FLEX_NUM) )RULE_TYPE
, ASG.EFFECTIVE_START_DATE
, ASG.EFFECTIVE_END_DATE
, ASG.ASSIGNMENT_ID
, ASG.PERSON_ID
FROM HR_SOFT_CODING_KEYFLEX SCL
, PER_ASSIGNMENTS_F ASG
WHERE SCL.SOFT_CODING_KEYFLEX_ID = ASG.SOFT_CODING_KEYFLEX_ID
AND ASG.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')