VIEW: APPS.CE_FC_PAY_DISC_V

Source

View Text - Preformatted

SELECT to_char(src.reference_id), pay.payroll_name, -src.amount, -nvl(src.base_amount,src.amount), src.payment_method, hr.name from ce_pay_fc_payroll_v src, pay_all_payrolls_f pay, hr_all_organization_units hr WHERE pay.payroll_id(+) = src.payroll_id and hr.organization_id(+) = src.org_id and exists (select null from ce_security_profiles_v sec where sec.organization_id = src.org_id and sec.organization_type = 'BUSINESS_GROUP')

View Text - HTML Formatted

SELECT TO_CHAR(SRC.REFERENCE_ID)
, PAY.PAYROLL_NAME
, -SRC.AMOUNT
, -NVL(SRC.BASE_AMOUNT
, SRC.AMOUNT)
, SRC.PAYMENT_METHOD
, HR.NAME
FROM CE_PAY_FC_PAYROLL_V SRC
, PAY_ALL_PAYROLLS_F PAY
, HR_ALL_ORGANIZATION_UNITS HR
WHERE PAY.PAYROLL_ID(+) = SRC.PAYROLL_ID
AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID
AND EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'BUSINESS_GROUP')