APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_USER_COLUMNS

Line 60: FROM pay_user_columns puc

56: ,cp_column_name VARCHAR2
57: )
58: IS
59: SELECT puc.user_column_id column_id
60: FROM pay_user_columns puc
61: WHERE puc.user_table_id =cp_table_id
62: AND puc.user_column_name =cp_column_name
63: AND puc.legislation_code = cp_legislation_code;
64:

Line 127: l_column_name pay_user_columns.user_column_name%TYPE;

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' ;
131: l_element VARCHAR2(30) := 'Claim Element';