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

Line 234: PQP_CONFIGURATION_VALUES PCV

230: CURSOR C_GET_QUALIFYING_PENSION_INFO
231: IS
232: SELECT DISTINCT PPSV.ELEMENT_NAME
233: FROM PQP_GB_PENSION_SCHEMES_V PPSV,
234: PQP_CONFIGURATION_VALUES PCV
235: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
236: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
237: AND PCV.PCV_INFORMATION2 = PPSV.ELEMENT_NAME ; --CHECK
238:

Line 245: FROM PQP_CONFIGURATION_VALUES PCV

241: CURSOR C_GET_DEFAULT_PENSION_INFO
242: IS
243: SELECT PCV.PCV_INFORMATION1,
244: PCV.PCV_INFORMATION2,PCV.PCV_INFORMATION3
245: FROM PQP_CONFIGURATION_VALUES PCV
246: WHERE PCV.PCV_INFORMATION_CATEGORY = 'PAY_GB_DEFAULT_PENSIONS_INFO'
247: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID ;
248:
249: G_DEFAULT_PENSION PQP_CONFIGURATION_VALUES.PCV_INFORMATION2%TYPE; -- To hold Default Pension Scheme Name

Line 249: G_DEFAULT_PENSION PQP_CONFIGURATION_VALUES.PCV_INFORMATION2%TYPE; -- To hold Default Pension Scheme Name

245: FROM PQP_CONFIGURATION_VALUES PCV
246: WHERE PCV.PCV_INFORMATION_CATEGORY = 'PAY_GB_DEFAULT_PENSIONS_INFO'
247: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID ;
248:
249: G_DEFAULT_PENSION PQP_CONFIGURATION_VALUES.PCV_INFORMATION2%TYPE; -- To hold Default Pension Scheme Name
250: G_DEFAULT_ELEMENT_ER PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;--Employer Element
251: G_DEFAULT_ELEMENT_EE PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --To hold Default Pension Scheme's Element Name
252: G_DEFAULT_PENSION_DUMMY PAY_ELEMENT_TYPE_EXTRA_INFO.EEI_INFORMATION1%TYPE;
253: G_DEFAULT_ELEMENT_DUMMY PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

Line 289: FROM PQP_CONFIGURATION_VALUES PCV

285: -- Cursor to get Pension Scheme's Elements' Names for the Pension Scheme Name
286: CURSOR C_GET_PENSION_ELEMENTS(P_PENSION_SCHEME_NAME VARCHAR2)
287: IS
288: SELECT PCV.PCV_INFORMATION2,PCV.PCV_INFORMATION3
289: FROM PQP_CONFIGURATION_VALUES PCV
290: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
291: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
292: AND PCV.PCV_INFORMATION1 = P_PENSION_SCHEME_NAME;
293: --ER 14126545