VIEW: APPS.PAY_PAYROLLS_X

Source

View Text - Preformatted

SELECT payroll_id, effective_start_date, effective_end_date, default_payment_method_id, business_group_id, consolidation_set_id, cost_allocation_keyflex_id, suspense_account_keyflex_id, gl_set_of_books_id, soft_coding_keyflex_id, period_type, organization_id, cut_off_date_offset, direct_deposit_date_offset, first_period_end_date, negative_pay_allowed_flag, number_of_years, pay_advice_date_offset, pay_date_offset, payroll_name, workload_shifting_level, comment_id, midpoint_offset, arrears_flag, multi_assignments_flag,attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, attribute16, attribute17, attribute18, attribute19, attribute20, prl_information_category,prl_information1,prl_information2, prl_information3, prl_information4, prl_information5, prl_information6, prl_information7, prl_information8, prl_information9, prl_information10, prl_information11, prl_information12, prl_information13, prl_information14, prl_information15, prl_information16, prl_information17, prl_information18, prl_information19, prl_information20, prl_information21, prl_information22, prl_information23, prl_information24, prl_information25, prl_information26, prl_information27, prl_information28, prl_information29, prl_information30, last_update_date, last_updated_by, last_update_login, created_by, creation_date FROM PAY_PAYROLLS_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PAYROLL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DEFAULT_PAYMENT_METHOD_ID
, BUSINESS_GROUP_ID
, CONSOLIDATION_SET_ID
, COST_ALLOCATION_KEYFLEX_ID
, SUSPENSE_ACCOUNT_KEYFLEX_ID
, GL_SET_OF_BOOKS_ID
, SOFT_CODING_KEYFLEX_ID
, PERIOD_TYPE
, ORGANIZATION_ID
, CUT_OFF_DATE_OFFSET
, DIRECT_DEPOSIT_DATE_OFFSET
, FIRST_PERIOD_END_DATE
, NEGATIVE_PAY_ALLOWED_FLAG
, NUMBER_OF_YEARS
, PAY_ADVICE_DATE_OFFSET
, PAY_DATE_OFFSET
, PAYROLL_NAME
, WORKLOAD_SHIFTING_LEVEL
, COMMENT_ID
, MIDPOINT_OFFSET
, ARREARS_FLAG
, MULTI_ASSIGNMENTS_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, PRL_INFORMATION_CATEGORY
, PRL_INFORMATION1
, PRL_INFORMATION2
, PRL_INFORMATION3
, PRL_INFORMATION4
, PRL_INFORMATION5
, PRL_INFORMATION6
, PRL_INFORMATION7
, PRL_INFORMATION8
, PRL_INFORMATION9
, PRL_INFORMATION10
, PRL_INFORMATION11
, PRL_INFORMATION12
, PRL_INFORMATION13
, PRL_INFORMATION14
, PRL_INFORMATION15
, PRL_INFORMATION16
, PRL_INFORMATION17
, PRL_INFORMATION18
, PRL_INFORMATION19
, PRL_INFORMATION20
, PRL_INFORMATION21
, PRL_INFORMATION22
, PRL_INFORMATION23
, PRL_INFORMATION24
, PRL_INFORMATION25
, PRL_INFORMATION26
, PRL_INFORMATION27
, PRL_INFORMATION28
, PRL_INFORMATION29
, PRL_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PAY_PAYROLLS_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE