DBA Data[Home] [Help]

APPS.PQP_GB_PENSRV_SVPN dependencies on PQP_CONFIGURATION_VALUES

Line 89: FROM pqp_configuration_values pcv,

85:
86: CURSOR csr_svpn_maintain_flag
87: IS
88: SELECT pcv_information4
89: FROM pqp_configuration_values pcv,
90: pqp_configuration_types pct
91: WHERE pcv.pcv_information_category = pct.configuration_type
92: AND pct.configuration_type = 'PQP_GB_PENSERVER_PAYPOINT_INFO'
93: AND pcv.business_group_id = g_business_group_id;

Line 100: FROM pqp_configuration_values pcv,

96:
97: CURSOR csr_pensrv_eligibility
98: IS
99: SELECT pcv_information1,pcv_information2
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_ELIGBLTY_CONF'
104: AND pcv.business_group_id = g_business_group_id;