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.

[Home] [Help]

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_QUALIFICATIONS

Line 2318: l_membership_number per_qualifications.membership_number%type := NULL;

2314: IS
2315:
2316: l_proc_name VARCHAR2(61) := g_proc_name||'get_qualification_mno';
2317:
2318: l_membership_number per_qualifications.membership_number%type := NULL;
2319: l_membership_number2 per_qualifications.membership_number%type := NULL;
2320:
2321: BEGIN
2322:

Line 2319: l_membership_number2 per_qualifications.membership_number%type := NULL;

2315:
2316: l_proc_name VARCHAR2(61) := g_proc_name||'get_qualification_mno';
2317:
2318: l_membership_number per_qualifications.membership_number%type := NULL;
2319: l_membership_number2 per_qualifications.membership_number%type := NULL;
2320:
2321: BEGIN
2322:
2323: debug_enter(l_proc_name);

Line 2561: -- PER_QUALIFICATIONS_V NAME NOT NULL VARCHAR2(100)

2557:
2558: -- QA failed due to length 30 increased to 100
2559: -- Max length based on the highest possible length of all its sources
2560: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2561: -- PER_QUALIFICATIONS_V NAME NOT NULL VARCHAR2(100)
2562: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)
2563: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2564: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2565:

Line 2562: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)

2558: -- QA failed due to length 30 increased to 100
2559: -- Max length based on the highest possible length of all its sources
2560: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2561: -- PER_QUALIFICATIONS_V NAME NOT NULL VARCHAR2(100)
2562: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)
2563: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2564: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2565:
2566: l_attr_location_type pay_user_column_instances_f.value%type;

Line 2575: -- PER_QUALIFICATIONS_V MEMBERSHIP_NUMBER VARCHAR2(80)

2571: -- Flexfield Segment Name
2572:
2573: l_dfee_refno per_all_assignments_f.ass_attribute1%type;
2574: -- Max length based on the highest possible length of all its sources
2575: -- PER_QUALIFICATIONS_V MEMBERSHIP_NUMBER VARCHAR2(80)
2576: -- PER_ALL_PEOPLE_F PER_INFORMATION1 VARCHAR2(150)
2577:
2578: BEGIN
2579: