APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_QUALIFICATIONS

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

2321: IS
2322:
2323: l_proc_name VARCHAR2(61) := g_proc_name||'get_qualification_mno';
2324:
2325: l_membership_number per_qualifications.membership_number%type := NULL;
2326: l_membership_number2 per_qualifications.membership_number%type := NULL;
2327:
2328: BEGIN
2329:

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

2322:
2323: l_proc_name VARCHAR2(61) := g_proc_name||'get_qualification_mno';
2324:
2325: l_membership_number per_qualifications.membership_number%type := NULL;
2326: l_membership_number2 per_qualifications.membership_number%type := NULL;
2327:
2328: BEGIN
2329:
2330: debug_enter(l_proc_name);

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

2564:
2565: -- QA failed due to length 30 increased to 100
2566: -- Max length based on the highest possible length of all its sources
2567: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2568: -- PER_QUALIFICATIONS_V NAME NOT NULL VARCHAR2(100)
2569: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)
2570: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2571: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2572:

Line 2569: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)

2565: -- QA failed due to length 30 increased to 100
2566: -- Max length based on the highest possible length of all its sources
2567: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2568: -- PER_QUALIFICATIONS_V NAME NOT NULL VARCHAR2(100)
2569: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)
2570: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2571: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2572:
2573: l_attr_location_type pay_user_column_instances_f.value%type;

Line 2582: -- PER_QUALIFICATIONS_V MEMBERSHIP_NUMBER VARCHAR2(80)

2578: -- Flexfield Segment Name
2579:
2580: l_dfee_refno per_all_assignments_f.ass_attribute1%type;
2581: -- Max length based on the highest possible length of all its sources
2582: -- PER_QUALIFICATIONS_V MEMBERSHIP_NUMBER VARCHAR2(80)
2583: -- PER_ALL_PEOPLE_F PER_INFORMATION1 VARCHAR2(150)
2584:
2585: BEGIN
2586: