APPS.PA_PWP_SUMM_PKG dependencies on PA_LOOKUPS

Line 63: ,(select LK3.MEANING FROM PA_LOOKUPS LK3 WHERE LK3.LOOKUP_TYPE = 'INVOICE_CLASS'

59: , C.CUSTOMER_NAME
60: , C.CUSTOMER_NUMBER
61: , I.INVOICE_DATE
62: , LK.MEANING INVOICE_STATUS_M
63: ,(select LK3.MEANING FROM PA_LOOKUPS LK3 WHERE LK3.LOOKUP_TYPE = 'INVOICE_CLASS'
64: AND LK3.LOOKUP_CODE = DECODE(ORG_INV.CANCELED_FLAG, 'Y', 'CANCEL',
65: DECODE(I.WRITE_OFF_FLAG, 'Y', 'WRITE_OFF',
66: DECODE(I.concession_flag, 'Y', 'CONCESSION',
67: DECODE(NVL(I.DRAFT_INVOICE_NUM_CREDITED, 0), 0, 'INVOICE',

Line 84: ,PA_LOOKUPS LK

80: , l_date
81: FROM PA_DRAFT_INVOICES_ALL I
82: , PA_DRAFT_INVOICES_ALL ORG_INV
83: , PA_CUSTOMERS_V C
84: ,PA_LOOKUPS LK
85: ,PA_AGREEMENTS_ALL A
86: WHERE I.AGREEMENT_ID = A.AGREEMENT_ID
87: and I.PROJECT_ID = P_Project_Id
88: AND C.CUSTOMER_ID = I.CUSTOMER_ID