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_GB_PENSION_SCHEMES_V

Line 49: G_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;

45: G_WORKER_POSTPONEMENT_RULE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE;
46: G_ELIGIBLE_POSTPONEMENT_RULE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE;
47: G_DEFINED_BALANCE_ID NUMBER := NULL;
48:
49: G_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
50: G_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
51: G_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;
52: --------------------
53: CURSOR C_DEF_BAL IS

Line 50: G_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;

46: G_ELIGIBLE_POSTPONEMENT_RULE HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE;
47: G_DEFINED_BALANCE_ID NUMBER := NULL;
48:
49: G_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
50: G_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
51: G_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;
52: --------------------
53: CURSOR C_DEF_BAL IS
54: SELECT PDB.DEFINED_BALANCE_ID

Line 51: G_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;

47: G_DEFINED_BALANCE_ID NUMBER := NULL;
48:
49: G_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
50: G_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
51: G_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;
52: --------------------
53: CURSOR C_DEF_BAL IS
54: SELECT PDB.DEFINED_BALANCE_ID
55: FROM

Line 233: FROM PQP_GB_PENSION_SCHEMES_V PPSV,

229: --To get all the Pension associated Element names that are classified as QUALIFYING
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