APPS.AP_APXKIRKI_XMLP_PKG dependencies on PO_VENDOR_SITES

Line 657: PO_VENDOR_SITES PVS

653: count(*)
654: INTO L_TOTAL_SITES
655: FROM
656: PO_VENDORS PV,
657: PO_VENDOR_SITES PVS
658: WHERE TRUNC(PVS.CREATION_DATE) <= TO_DATE(C_END_DATE
659: ,'DD/MM/YYYY')
660: AND PV.VENDOR_ID = PVS.VENDOR_ID
661: AND TRUNC(PV.CREATION_DATE) <= TO_DATE(C_END_DATE

Line 1205: PO_VENDOR_SITES PVS

1201: ,0)
1202: INTO L_OLD_VENDOR_SITES,L_TOTAL_VENDORS_HELD
1203: FROM
1204: PO_VENDORS PV,
1205: PO_VENDOR_SITES PVS
1206: WHERE TRUNC(PVS.CREATION_DATE) >= TO_DATE(C_START_DATE
1207: ,'DD/MM/YYYY')
1208: AND TRUNC(PVS.CREATION_DATE) <= TO_DATE(C_END_DATE
1209: ,'DD/MM/YYYY')

Line 1226: PO_VENDOR_SITES PVS

1222: ,0)
1223: INTO L_NEW_VENDOR_SITES,L_NEW_VENDORS_HELD
1224: FROM
1225: PO_VENDORS PV,
1226: PO_VENDOR_SITES PVS
1227: WHERE TRUNC(PVS.CREATION_DATE) >= TO_DATE(C_START_DATE
1228: ,'DD/MM/YYYY')
1229: AND TRUNC(PVS.CREATION_DATE) <= TO_DATE(C_END_DATE
1230: ,'DD/MM/YYYY')

Line 1249: PO_VENDOR_SITES

1245: SELECT
1246: count(*)
1247: INTO L_UPDATED_SITES
1248: FROM
1249: PO_VENDOR_SITES
1250: WHERE TRUNC(LAST_UPDATE_DATE) >= TO_DATE(C_START_DATE
1251: ,'DD/MM/YYYY')
1252: AND TRUNC(LAST_UPDATE_DATE) <= TO_DATE(C_END_DATE
1253: ,'DD/MM/YYYY');