APPS.PJM_TRANSFER_CHARGES_PKG dependencies on PA_PROJECTS_ALL

Line 363: PA_Projects_ALL PAP,

359: WHERE LINE_TYPE_LOOKUP_CODE IN ('IPV', 'ERV', 'TIPV', 'TERV', 'TRV')
360: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
361: AND POSTED_FLAG = 'Y'
362: ) DIST,
363: PA_Projects_ALL PAP,
364: PJM_Org_Parameters POP,
365: PO_Distributions_All POD
366: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
367: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')

Line 434: PA_Projects_ALL PAP,

430: AND C.POSTED_FLAG = 'Y'
431: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
432: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
433: ) DIST,
434: PA_Projects_ALL PAP,
435: PJM_Org_Parameters POP,
436: PO_Distributions_All POD
437: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
438: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')

Line 503: PA_Projects_ALL PAP,

499: WHERE LINE_TYPE_LOOKUP_CODE IN ('IPV', 'ERV', 'TIPV', 'TERV', 'TRV')
500: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
501: AND POSTED_FLAG = 'Y'
502: ) DIST,
503: PA_Projects_ALL PAP,
504: PJM_Org_Parameters POP,
505: PO_Distributions_All POD
506: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
507: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')

Line 575: PA_Projects_ALL PAP,

571: AND C.POSTED_FLAG = 'Y'
572: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
573: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
574: ) DIST,
575: PA_Projects_ALL PAP,
576: PJM_Org_Parameters POP,
577: PO_Distributions_All POD
578: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
579: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')