VIEW: APPS.CE_PAY_FC_PAYROLL_V

Source

View Text - Preformatted

SELECT ACTION.BUSINESS_GROUP_ID, /* 1 */ METHOD.CURRENCY_CODE, /* 2 */ (PREPAY.VALUE), /* 3 */ PREPAY.BASE_CURRENCY_VALUE, /* 4 */ ACTION.EFFECTIVE_DATE, /* 5 */ METHOD.ORG_PAYMENT_METHOD_ID, /* 6 */ METHOD.EXTERNAL_ACCOUNT_ID, /* 7 */ BAU.BANK_ACCOUNT_ID, /* 8 */ ACTION.PAYROLL_ID, /* 9 */ ACTION.EFFECTIVE_DATE, /* 10 */ METHOD.ORG_PAYMENT_METHOD_NAME, /* 11 */ PREPAY.PRE_PAYMENT_ID /* 12 */ FROM PAY_PRE_PAYMENTS PREPAY, PAY_ORG_PAYMENT_METHODS_F METHOD, PAY_PAYROLL_ACTIONS ACTION, PAY_ASSIGNMENT_ACTIONS ASGN, CE_BANK_ACCT_USES_ALL BAU WHERE ACTION.ACTION_TYPE IN ('P', 'U', 'E') AND METHOD.ORG_PAYMENT_METHOD_ID = PREPAY.ORG_PAYMENT_METHOD_ID AND PREPAY.ASSIGNMENT_ACTION_ID = ASGN.ASSIGNMENT_ACTION_ID AND ASGN.PAYROLL_ACTION_ID = ACTION.PAYROLL_ACTION_ID AND ACTION.EFFECTIVE_DATE BETWEEN METHOD.EFFECTIVE_START_DATE AND METHOD.EFFECTIVE_END_DATE AND METHOD.EXTERNAL_ACCOUNT_ID = BAU.PAYROLL_BANK_ACCOUNT_ID

View Text - HTML Formatted

SELECT ACTION.BUSINESS_GROUP_ID
, /* 1 */ METHOD.CURRENCY_CODE
, /* 2 */ (PREPAY.VALUE)
, /* 3 */ PREPAY.BASE_CURRENCY_VALUE
, /* 4 */ ACTION.EFFECTIVE_DATE
, /* 5 */ METHOD.ORG_PAYMENT_METHOD_ID
, /* 6 */ METHOD.EXTERNAL_ACCOUNT_ID
, /* 7 */ BAU.BANK_ACCOUNT_ID
, /* 8 */ ACTION.PAYROLL_ID
, /* 9 */ ACTION.EFFECTIVE_DATE
, /* 10 */ METHOD.ORG_PAYMENT_METHOD_NAME
, /* 11 */ PREPAY.PRE_PAYMENT_ID /* 12 */
FROM PAY_PRE_PAYMENTS PREPAY
, PAY_ORG_PAYMENT_METHODS_F METHOD
, PAY_PAYROLL_ACTIONS ACTION
, PAY_ASSIGNMENT_ACTIONS ASGN
, CE_BANK_ACCT_USES_ALL BAU
WHERE ACTION.ACTION_TYPE IN ('P'
, 'U'
, 'E')
AND METHOD.ORG_PAYMENT_METHOD_ID = PREPAY.ORG_PAYMENT_METHOD_ID
AND PREPAY.ASSIGNMENT_ACTION_ID = ASGN.ASSIGNMENT_ACTION_ID
AND ASGN.PAYROLL_ACTION_ID = ACTION.PAYROLL_ACTION_ID
AND ACTION.EFFECTIVE_DATE BETWEEN METHOD.EFFECTIVE_START_DATE
AND METHOD.EFFECTIVE_END_DATE
AND METHOD.EXTERNAL_ACCOUNT_ID = BAU.PAYROLL_BANK_ACCOUNT_ID