VIEW: APPS.PAY_EMP_HRS_RATE_ACTION_INFO_V

Source

View Text - Preformatted

SELECT pai.action_context_id, pai.action_information1 element_type_id, pai.action_information4 element_name, fnd_number.canonical_to_number(pai.action_information5) rate, fnd_number.canonical_to_number(pai.action_information6) hours, pai.action_information7 processing_priority, fnd_number.canonical_to_number(pai.action_information8) multiple, (fnd_number.canonical_to_number( pai.action_information5) * fnd_number.canonical_to_number(pai.action_information6) * fnd_number.canonical_to_number(nvl(pai.action_information8,1))) amount from pay_action_information pai, per_assignments_f paf WHERE pai.action_information_category = 'EMPLOYEE HOURS BY RATE' and paf.assignment_id = pai.assignment_id and pai.effective_date between paf.effective_start_date and paf.effective_end_date

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID
, PAI.ACTION_INFORMATION1 ELEMENT_TYPE_ID
, PAI.ACTION_INFORMATION4 ELEMENT_NAME
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION5) RATE
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6) HOURS
, PAI.ACTION_INFORMATION7 PROCESSING_PRIORITY
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8) MULTIPLE
, (FND_NUMBER.CANONICAL_TO_NUMBER( PAI.ACTION_INFORMATION5) * FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6) * FND_NUMBER.CANONICAL_TO_NUMBER(NVL(PAI.ACTION_INFORMATION8
, 1))) AMOUNT
FROM PAY_ACTION_INFORMATION PAI
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE HOURS BY RATE'
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE