DBA Data[Home] [Help]

APPS.PQP_VEHICLE_MILEAGE dependencies on PQP_VEHICLE_MILEAGE

Line 1: PACKAGE BODY PQP_VEHICLE_MILEAGE AS

1: PACKAGE BODY PQP_VEHICLE_MILEAGE AS
2: /* $Header: pqbladwr.pkb 115.5 2003/06/27 10:22:11 jcpereir noship $*/
3:
4: PROCEDURE INITIALIZE_BALANCES(errbuf OUT NOCOPY VARCHAR2
5: ,retcode OUT NOCOPY NUMBER

Line 28: AND pete.information_type='PQP_VEHICLE_MILEAGE_INFO'

24: AND ppa.effective_date BETWEEN TO_DATE('04/06/2003','MM/DD/YYYY')
25: AND TO_DATE('04/05/2004','MM/DD/YYYY')
26: )
27: AND pete.element_type_id=pet.element_type_id
28: AND pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
29: AND pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'
30: AND pete.EEI_INFORMATION1 in ('C','P','PM','PP','CM','CP')
31: AND pet.business_group_id =cp_business_group_id;
32:

Line 29: AND pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'

25: AND TO_DATE('04/05/2004','MM/DD/YYYY')
26: )
27: AND pete.element_type_id=pet.element_type_id
28: AND pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
29: AND pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'
30: AND pete.EEI_INFORMATION1 in ('C','P','PM','PP','CM','CP')
31: AND pet.business_group_id =cp_business_group_id;
32:
33: -- Check if given Element has a link or not