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.PER_GB_PENSRV_SVPN dependencies on PQP_CONFIGURATION_VALUES

Line 54: FROM pqp_configuration_values pcv,

50:
51: CURSOR get_penserv_config(c_business_group_id NUMBER)
52: IS
53: SELECT pcv_information1,pcv_information2
54: FROM pqp_configuration_values pcv,
55: pqp_configuration_types pct
56: WHERE pcv.pcv_information_category = pct.configuration_type
57: AND pct.configuration_type = 'PQP_GB_PENSERVER_ELIGBLTY_CONF'
58: AND pcv.business_group_id = c_business_group_id;

Line 100: FROM pqp_configuration_values pcv,

96:
97: CURSOR csr_svpn_maintain_flag(c_business_group_id NUMBER)
98: IS
99: SELECT pcv_information4
100: FROM pqp_configuration_values pcv,
101: pqp_configuration_types pct
102: WHERE pcv.pcv_information_category = pct.configuration_type
103: AND pct.configuration_type = 'PQP_GB_PENSERVER_PAYPOINT_INFO'
104: AND pcv.business_group_id = c_business_group_id;

Line 253: l_business_group_id pqp_configuration_values.business_group_id%TYPE;

249:
250: procedure AUTO_CALC_FTE (p_assignment_id in Number,
251: P_EFFECTIVE_START_DATE in Date)
252: IS
253: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
254: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
255: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
256: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
257: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 254: l_legislation_code pqp_configuration_values.legislation_code%TYPE;

250: procedure AUTO_CALC_FTE (p_assignment_id in Number,
251: P_EFFECTIVE_START_DATE in Date)
252: IS
253: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
254: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
255: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
256: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
257: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
258: l_assignment_type varchar2(30);

Line 255: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;

251: P_EFFECTIVE_START_DATE in Date)
252: IS
253: l_business_group_id pqp_configuration_values.business_group_id%TYPE;
254: l_legislation_code pqp_configuration_values.legislation_code%TYPE;
255: l_abv_uom pqp_configuration_values.pcv_information1%TYPE;
256: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
257: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
258: l_assignment_type varchar2(30);
259:

Line 286: FROM pqp_configuration_values mtn

282: ,def.configuration_name defn_config_name
283: ,def.business_group_id defn_bg_id
284: ,def.legislation_code defn_leg_code
285: ,def.pcv_information4 defn_custom_function
286: FROM pqp_configuration_values mtn
287: ,pqp_configuration_values def
288: WHERE mtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
289: AND def.pcv_information_category = 'PQP_ABVM_DEFINITION'
290: AND def.pcv_information1 = mtn.pcv_information1

Line 287: ,pqp_configuration_values def

283: ,def.business_group_id defn_bg_id
284: ,def.legislation_code defn_leg_code
285: ,def.pcv_information4 defn_custom_function
286: FROM pqp_configuration_values mtn
287: ,pqp_configuration_values def
288: WHERE mtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
289: AND def.pcv_information_category = 'PQP_ABVM_DEFINITION'
290: AND def.pcv_information1 = mtn.pcv_information1
291: AND mtn.pcv_information2 = 'Y'

Line 298: FROM pqp_configuration_values bgmtn

294: ( ( mtn.business_group_id IS NULL AND mtn.legislation_code = p_legislation_code )
295: AND -- there does not exist a config for this UOM at bg level
296: NOT EXISTS
297: (SELECT 1
298: FROM pqp_configuration_values bgmtn
299: WHERE bgmtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
300: AND bgmtn.pcv_information1 = mtn.pcv_information1
301: AND bgmtn.business_group_id = p_business_group_id
302: ) -- NOT EXISTS

Line 309: FROM pqp_configuration_values hlmtn

305: ( ( mtn.business_group_id IS NULL AND mtn.legislation_code IS NULL )
306: AND -- there does not exist a config for this UOM at a higher level
307: NOT EXISTS
308: (SELECT 1
309: FROM pqp_configuration_values hlmtn
310: WHERE hlmtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
311: AND hlmtn.pcv_information1 = mtn.pcv_information1
312: AND ( hlmtn.business_group_id = p_business_group_id
313: OR