eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PQP_CONFIGURATION_VALUES

Line 126: l_legislation_code pqp_configuration_values.legislation_code%TYPE;

122: l_get_row_info c_get_row_info%ROWTYPE;
123: l_get_value c_get_value%ROWTYPE;
124: l_get_element_id c_get_element_id%ROWTYPE;
125: l_get_rate_id c_get_rate_id%ROWTYPE;
126: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
127: l_column_name pay_user_columns.user_column_name%TYPE;
128: l_vehicle VARCHAR2(30) ;
129: l_ownership VARCHAR2(30);
130: l_rates VARCHAR2(30) := 'Rates Table' ;

Line 846: from pqp_configuration_values pcv

842: CURSOR c_get_config_element(cp_business_group_id NUMBER)
843: IS
844: select TO_NUMBER(pcv.pcv_information6) element_type_id
845: ,TO_NUMBER(pcv.pcv_information5) Rates_table_id
846: from pqp_configuration_values pcv
847: WHERE pcv.pcv_information_category='PQP_MILEAGE CALC_INFO'
848: AND pcv.business_group_id=cp_business_group_id;
849:
850:

Line 883: l_get_element_type_id pqp_configuration_values.pcv_information5%TYPE;

879: l_effective_date DATE;
880: l_element_type_id pay_element_types_f.element_type_id%TYPE;
881: l_element_link_id pay_element_links_f.element_link_id%TYPE;
882: l_rates_table_id VARCHAR2(80); --pay_user_tables.user_table_id%TYPE;
883: l_get_element_type_id pqp_configuration_values.pcv_information5%TYPE;
884: l_get_rate_id pqp_configuration_values.pcv_information6%TYPE;
885: l_chk_eligibility VARCHAR2(1);
886: l_chk_mndtry VARCHAR2(1);
887: l_message VARCHAR2(100);

Line 884: l_get_rate_id pqp_configuration_values.pcv_information6%TYPE;

880: l_element_type_id pay_element_types_f.element_type_id%TYPE;
881: l_element_link_id pay_element_links_f.element_link_id%TYPE;
882: l_rates_table_id VARCHAR2(80); --pay_user_tables.user_table_id%TYPE;
883: l_get_element_type_id pqp_configuration_values.pcv_information5%TYPE;
884: l_get_rate_id pqp_configuration_values.pcv_information6%TYPE;
885: l_chk_eligibility VARCHAR2(1);
886: l_chk_mndtry VARCHAR2(1);
887: l_message VARCHAR2(100);
888: l_session_id pay_us_rpt_totals.GRE_NAME%TYPE;

Line 1732: FROM pqp_configuration_values pcv

1728: ,pcv.pcv_information2 Usage_type
1729: ,pcv.pcv_information3 Vehicle_type
1730: ,pcv.pcv_information4 Fuel_type
1731: ,pcv.pcv_information5 rates_type
1732: FROM pqp_configuration_values pcv
1733: WHERE business_group_id=p_business_group_id
1734: AND pcv.pcv_information_category='GB_VEHICLE_CALC_INFO'
1735: AND pcv_information1=p_ownership
1736: AND (pcv_information2=p_usage_type

Line 1755: FROM pqp_configuration_values pcv

1751: ,pcv.pcv_information2 Usage_type
1752: ,pcv.pcv_information3 Vehicle_type
1753: ,pcv.pcv_information4 Fuel_type
1754: ,pcv.pcv_information6 element_id
1755: FROM pqp_configuration_values pcv
1756: WHERE business_group_id=p_business_group_id
1757: AND pcv.pcv_information_category='GB_VEHICLE_CALC_INFO'
1758: AND pcv_information1=p_ownership
1759: AND (pcv_information2=p_usage_type

Line 2163: FROM pqp_configuration_values pcv

2159: IS
2160: SELECT pcv_information6 prev_tax_yr_valid
2161: ,pcv_information7 allow_both_veh_clm
2162: ,pcv_information9 validate_pvt_veh
2163: FROM pqp_configuration_values pcv
2164: WHERE pcv.legislation_code=cp_leg_code
2165: AND pcv.pcv_information_category='PQP_VEHICLE_MILEAGE';
2166:
2167: --Check the status of vehicle