APPS.PA_PWP_SUMM_PKG dependencies on PA_LOOKUPS

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

79: , C.CUSTOMER_NAME
80: , C.CUSTOMER_NUMBER
81: , I.INVOICE_DATE
82: , LK.MEANING INVOICE_STATUS_M
83: ,(select LK3.MEANING FROM PA_LOOKUPS LK3 WHERE LK3.LOOKUP_TYPE = 'INVOICE_CLASS'
84: AND LK3.LOOKUP_CODE = DECODE(ORG_INV.CANCELED_FLAG, 'Y', 'CANCEL',
85: DECODE(I.WRITE_OFF_FLAG, 'Y', 'WRITE_OFF',
86: DECODE(I.concession_flag, 'Y', 'CONCESSION',
87: DECODE(NVL(I.DRAFT_INVOICE_NUM_CREDITED, 0), 0, 'INVOICE',

Line 104: ,PA_LOOKUPS LK

100: , l_date
101: FROM PA_DRAFT_INVOICES_ALL I
102: , PA_DRAFT_INVOICES_ALL ORG_INV
103: , PA_CUSTOMERS_V C
104: ,PA_LOOKUPS LK
105: ,PA_AGREEMENTS_ALL A
106: WHERE I.AGREEMENT_ID = A.AGREEMENT_ID
107: and I.PROJECT_ID = P_Project_Id
108: AND C.CUSTOMER_ID = I.CUSTOMER_ID