VIEW: APPS.PAY_KR_ASG_PAYMENTS_V

Source

View Text - Preformatted

SELECT ppaa.Assignment_Action_Id Assignment_Action_ID ,popm.Org_Payment_Method_Name Payment_Method_Name ,hl.Meaning Bank ,pea.Segment3 Account_Number ,ppp.Value Amount From Pay_Payroll_Actions pppa ,Pay_Assignment_Actions ppaa ,Pay_Pre_Payments ppp ,Pay_Personal_Payment_Methods_F pppm ,Pay_Org_Payment_Methods_F popm ,Pay_External_Accounts pea ,Hr_Lookups hl WHERE pppa.Payroll_Action_Id = ppaa.Payroll_Action_ID And pppa.Action_Type IN ('P','U') And pppa.Action_Status = 'C' And ppp.Assignment_Action_Id = ppaa.Assignment_Action_Id And ppp.Personal_Payment_Method_Id = pppm.Personal_Payment_Method_Id And pppm.Org_Payment_Method_ID = popm.Org_Payment_Method_ID And popm.External_Account_Id = pea.External_Account_Id And pea.segment1 = Hl.Lookup_code And Hl.Lookup_Type = 'KR_BANK' And pppa.Effective_Date Between pppm.Effective_Start_Date And pppm.Effective_End_Date And pppm.Effective_Start_Date >= popm.Effective_Start_Date And pppm.Effective_End_Date <= popm.Effective_End_Date Union All Select ppaa.Assignment_Action_Id Assignment_Action_ID ,popm.Org_Payment_Method_Name Payment_Method_Name ,null Bank ,null Account_Number ,ppp.Value Amount From Pay_Payroll_Actions pppa ,Pay_Assignment_Actions ppaa ,Pay_Pre_Payments ppp ,Pay_Org_Payment_Methods_F popm Where pppa.Payroll_Action_Id = ppaa.Payroll_Action_ID And pppa.Action_Type IN ('P','U') And pppa.Action_Status = 'C' And ppp.Assignment_Action_Id = ppaa.Assignment_Action_Id And ppp.Personal_Payment_Method_Id IS NULL And ppp.Org_Payment_Method_ID = popm.Org_Payment_Method_ID And pppa.Effective_Date Between popm.Effective_Start_Date And popm.Effective_End_Date

View Text - HTML Formatted

SELECT PPAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD_NAME
, HL.MEANING BANK
, PEA.SEGMENT3 ACCOUNT_NUMBER
, PPP.VALUE AMOUNT
FROM PAY_PAYROLL_ACTIONS PPPA
, PAY_ASSIGNMENT_ACTIONS PPAA
, PAY_PRE_PAYMENTS PPP
, PAY_PERSONAL_PAYMENT_METHODS_F PPPM
, PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_EXTERNAL_ACCOUNTS PEA
, HR_LOOKUPS HL
WHERE PPPA.PAYROLL_ACTION_ID = PPAA.PAYROLL_ACTION_ID
AND PPPA.ACTION_TYPE IN ('P'
, 'U')
AND PPPA.ACTION_STATUS = 'C'
AND PPP.ASSIGNMENT_ACTION_ID = PPAA.ASSIGNMENT_ACTION_ID
AND PPP.PERSONAL_PAYMENT_METHOD_ID = PPPM.PERSONAL_PAYMENT_METHOD_ID
AND PPPM.ORG_PAYMENT_METHOD_ID = POPM.ORG_PAYMENT_METHOD_ID
AND POPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID
AND PEA.SEGMENT1 = HL.LOOKUP_CODE
AND HL.LOOKUP_TYPE = 'KR_BANK'
AND PPPA.EFFECTIVE_DATE BETWEEN PPPM.EFFECTIVE_START_DATE
AND PPPM.EFFECTIVE_END_DATE
AND PPPM.EFFECTIVE_START_DATE >= POPM.EFFECTIVE_START_DATE
AND PPPM.EFFECTIVE_END_DATE <= POPM.EFFECTIVE_END_DATE UNION ALL SELECT PPAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, POPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD_NAME
, NULL BANK
, NULL ACCOUNT_NUMBER
, PPP.VALUE AMOUNT
FROM PAY_PAYROLL_ACTIONS PPPA
, PAY_ASSIGNMENT_ACTIONS PPAA
, PAY_PRE_PAYMENTS PPP
, PAY_ORG_PAYMENT_METHODS_F POPM
WHERE PPPA.PAYROLL_ACTION_ID = PPAA.PAYROLL_ACTION_ID
AND PPPA.ACTION_TYPE IN ('P'
, 'U')
AND PPPA.ACTION_STATUS = 'C'
AND PPP.ASSIGNMENT_ACTION_ID = PPAA.ASSIGNMENT_ACTION_ID
AND PPP.PERSONAL_PAYMENT_METHOD_ID IS NULL
AND PPP.ORG_PAYMENT_METHOD_ID = POPM.ORG_PAYMENT_METHOD_ID
AND PPPA.EFFECTIVE_DATE BETWEEN POPM.EFFECTIVE_START_DATE
AND POPM.EFFECTIVE_END_DATE