DBA Data[Home] [Help]

APPS.PER_GB_PENSRV_SVPN dependencies on PQP_CONFIGURATION_TYPES

Line 55: pqp_configuration_types pct

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;
59:

Line 101: pqp_configuration_types pct

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;
105: