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_EMP_OTHERS_ACTION_INFO_V

Source

View Text - Preformatted


SELECT pai.action_context_id, pai.assignment_id, pai.effective_date, pai.action_information2 info_type, /*(gives type ..balance/element/message)*/ pai.action_information4 name, /* (balance name, element name, message)*/ pai.action_information5 value_type, /*input value for element, or dimension for balance)*/ /* commenting for bug 4941034 to_char(fnd_number.canonical_to_number(pai.action_information6),'9999999999990D00') value */ pai.action_information6 value, pai.action_information11 UOM, /* Unit of Measure */ pai.action_information13 org_information_cntxt, /* Messg Context Bug:- 7115367*/ nvl(pai.action_information14, pai.action_information4) reporting_name /* Bug 8827140 */ from pay_action_information pai ,per_assignments_f paf WHERE pai.action_information_category = 'EMPLOYEE OTHER INFORMATION' and pai.action_information2 = 'BALANCE' and paf.assignment_id = pai.assignment_id and pai.effective_date between paf.effective_start_date and paf.effective_end_date UNION ALL select pai.action_context_id, pai.assignment_id, pai.effective_date, pai.action_information2 info_type, pai.action_information4 name, pai.action_information5 value_type, /*input value for element*/ pai.action_information6 value, pai.action_information11 UOM, pai.action_information13 org_information_cntxt, /* Messg Context Bug:- 7115367*/ nvl(pai.action_information14, pai.action_information4) reporting_name /* Bug 8827140 */ from pay_action_information pai, pay_input_values_f piv, per_assignments_f paf where pai.action_information_category = 'EMPLOYEE OTHER INFORMATION' and pai.action_information2 = 'ELEMENT' and pai.effective_date between piv.effective_start_date and piv.effective_end_date and piv.input_value_id = pai.action_information8 and paf.assignment_id = pai.assignment_id and pai.effective_date between paf.effective_start_date and paf.effective_end_date UNION ALL select paa.assignment_action_id, pai.assignment_id, pai.effective_date, pai.action_information2 info_type, /*(gives type ..balance/element/message)*/ pai.action_information4 name, /* (balance name, element name, message)*/ pai.action_information5 value_type, /*input value for element, or dimension for balance)*/ pai.action_information6 value, pai.action_information11 UOM, pai.action_information13 org_information_cntxt, /* Messg Context Bug:- 7115367*/ nvl(pai.action_information14, pai.action_information4) reporting_name /* Bug 8827140 */ FROM pay_action_information pai, pay_assignment_actions paa, per_all_assignments_f paf WHERE pai.action_information_category = 'EMPLOYEE OTHER INFORMATION' and pai.action_information2 = 'MESG' and paa.payroll_action_id = pai.action_context_id and paf.assignment_id = paa.assignment_id and paf.organization_id = pai.action_information1 and pai.effective_date between paf.effective_Start_date and paf.effective_end_Date UNION ALL select paa.assignment_action_id, pai.assignment_id, pai.effective_date, pai.action_information2 info_type, /*(gives type ..balance/element/message)*/ pai.action_information4 name, /* (balance name, element name, message)*/ pai.action_information5 value_type, /*input value for element, or dimension for ba lance)*/ pai.action_information6 value, pai.action_information11 UOM, pai.action_information13 org_information_cntxt, /* Messg Context Bug:- 7115367*/ nvl(pai.action_information14, pai.action_information4) reporting_name /* Bug 8827140 */ FROM pay_action_information pai, pay_assignment_actions paa, pay_payroll_actions ppa WHERE pai.action_information_category = 'EMPLOYEE OTHER INFORMATION' and pai.action_information2 = 'MESG' and paa.payroll_action_id = pai.action_context_id and ppa.payroll_action_id = paa.payroll_action_id and ppa.business_group_id = pai.action_information1 AND pai.action_information13 = 'Business Group:Payslip Info' /*Added so that only Business Group level payslip info is retrieved Bug:- 7041464*/ UNION ALL select paa.assignment_action_id action_context_id, pai.assignment_id assignment_id, pai.effective_date effective_date, pai.action_information2 info_type, pai.action_information4 name, pai.action_information5 value_type, pai.action_information6 value, pai.action_information11 UOM, pai.action_information13 org_information_cntxt, /* Messg Context Bug:- 7115367*/ nvl(pai.action_information14, pai.action_information4) reporting_name /* Bug 8827140 */ FROM pay_payroll_actions ppa, pay_assignment_actions paa, pay_action_interlocks lck, pay_assignment_actions paa2, pay_payroll_actions ppa2, pay_action_information pai WHERE ppa.payroll_action_id = paa.payroll_action_id and paa.assignment_action_id = lck.locking_action_id and lck.locked_action_id = paa2.assignment_action_id and paa2.payroll_action_id = ppa2.payroll_action_id and ppa2.action_type in ('R','Q') and paa.payroll_action_id = pai.action_context_id and pai.action_information_category = 'EMPLOYEE OTHER INFORMATION' and pai.action_information2 = 'MESG' and paa2.payroll_action_id = pai.action_information1

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID
, PAI.ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION2 INFO_TYPE
, /*(GIVES TYPE ..BALANCE/ELEMENT/MESSAGE)*/ PAI.ACTION_INFORMATION4 NAME
, /* (BALANCE NAME
, ELEMENT NAME
, MESSAGE)*/ PAI.ACTION_INFORMATION5 VALUE_TYPE
, /*INPUT VALUE FOR ELEMENT
, OR DIMENSION FOR BALANCE)*/ /* COMMENTING FOR BUG 4941034 TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6)
, '9999999999990D00') VALUE */ PAI.ACTION_INFORMATION6 VALUE
, PAI.ACTION_INFORMATION11 UOM
, /* UNIT OF MEASURE */ PAI.ACTION_INFORMATION13 ORG_INFORMATION_CNTXT
, /* MESSG CONTEXT BUG:- 7115367*/ NVL(PAI.ACTION_INFORMATION14
, PAI.ACTION_INFORMATION4) REPORTING_NAME /* BUG 8827140 */
FROM PAY_ACTION_INFORMATION PAI
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE OTHER INFORMATION'
AND PAI.ACTION_INFORMATION2 = 'BALANCE'
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE UNION ALL SELECT PAI.ACTION_CONTEXT_ID
, PAI.ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION2 INFO_TYPE
, PAI.ACTION_INFORMATION4 NAME
, PAI.ACTION_INFORMATION5 VALUE_TYPE
, /*INPUT VALUE FOR ELEMENT*/ PAI.ACTION_INFORMATION6 VALUE
, PAI.ACTION_INFORMATION11 UOM
, PAI.ACTION_INFORMATION13 ORG_INFORMATION_CNTXT
, /* MESSG CONTEXT BUG:- 7115367*/ NVL(PAI.ACTION_INFORMATION14
, PAI.ACTION_INFORMATION4) REPORTING_NAME /* BUG 8827140 */
FROM PAY_ACTION_INFORMATION PAI
, PAY_INPUT_VALUES_F PIV
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE OTHER INFORMATION'
AND PAI.ACTION_INFORMATION2 = 'ELEMENT'
AND PAI.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIV.INPUT_VALUE_ID = PAI.ACTION_INFORMATION8
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE UNION ALL SELECT PAA.ASSIGNMENT_ACTION_ID
, PAI.ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION2 INFO_TYPE
, /*(GIVES TYPE ..BALANCE/ELEMENT/MESSAGE)*/ PAI.ACTION_INFORMATION4 NAME
, /* (BALANCE NAME
, ELEMENT NAME
, MESSAGE)*/ PAI.ACTION_INFORMATION5 VALUE_TYPE
, /*INPUT VALUE FOR ELEMENT
, OR DIMENSION FOR BALANCE)*/ PAI.ACTION_INFORMATION6 VALUE
, PAI.ACTION_INFORMATION11 UOM
, PAI.ACTION_INFORMATION13 ORG_INFORMATION_CNTXT
, /* MESSG CONTEXT BUG:- 7115367*/ NVL(PAI.ACTION_INFORMATION14
, PAI.ACTION_INFORMATION4) REPORTING_NAME /* BUG 8827140 */
FROM PAY_ACTION_INFORMATION PAI
, PAY_ASSIGNMENT_ACTIONS PAA
, PER_ALL_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE OTHER INFORMATION'
AND PAI.ACTION_INFORMATION2 = 'MESG'
AND PAA.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAF.ORGANIZATION_ID = PAI.ACTION_INFORMATION1
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE UNION ALL SELECT PAA.ASSIGNMENT_ACTION_ID
, PAI.ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION2 INFO_TYPE
, /*(GIVES TYPE ..BALANCE/ELEMENT/MESSAGE)*/ PAI.ACTION_INFORMATION4 NAME
, /* (BALANCE NAME
, ELEMENT NAME
, MESSAGE)*/ PAI.ACTION_INFORMATION5 VALUE_TYPE
, /*INPUT VALUE FOR ELEMENT
, OR DIMENSION FOR BA LANCE)*/ PAI.ACTION_INFORMATION6 VALUE
, PAI.ACTION_INFORMATION11 UOM
, PAI.ACTION_INFORMATION13 ORG_INFORMATION_CNTXT
, /* MESSG CONTEXT BUG:- 7115367*/ NVL(PAI.ACTION_INFORMATION14
, PAI.ACTION_INFORMATION4) REPORTING_NAME /* BUG 8827140 */
FROM PAY_ACTION_INFORMATION PAI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE OTHER INFORMATION'
AND PAI.ACTION_INFORMATION2 = 'MESG'
AND PAA.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.BUSINESS_GROUP_ID = PAI.ACTION_INFORMATION1
AND PAI.ACTION_INFORMATION13 = 'BUSINESS GROUP:PAYSLIP INFO' /*ADDED SO THAT ONLY BUSINESS GROUP LEVEL PAYSLIP INFO IS RETRIEVED BUG:- 7041464*/ UNION ALL SELECT PAA.ASSIGNMENT_ACTION_ID ACTION_CONTEXT_ID
, PAI.ASSIGNMENT_ID ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE EFFECTIVE_DATE
, PAI.ACTION_INFORMATION2 INFO_TYPE
, PAI.ACTION_INFORMATION4 NAME
, PAI.ACTION_INFORMATION5 VALUE_TYPE
, PAI.ACTION_INFORMATION6 VALUE
, PAI.ACTION_INFORMATION11 UOM
, PAI.ACTION_INFORMATION13 ORG_INFORMATION_CNTXT
, /* MESSG CONTEXT BUG:- 7115367*/ NVL(PAI.ACTION_INFORMATION14
, PAI.ACTION_INFORMATION4) REPORTING_NAME /* BUG 8827140 */
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA2
, PAY_ACTION_INFORMATION PAI
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ACTION_ID = LCK.LOCKING_ACTION_ID
AND LCK.LOCKED_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PPA2.PAYROLL_ACTION_ID
AND PPA2.ACTION_TYPE IN ('R'
, 'Q')
AND PAA.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE OTHER INFORMATION'
AND PAI.ACTION_INFORMATION2 = 'MESG'
AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_INFORMATION1