DBA Data[Home] [Help]

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 2404: FROM fnd_descriptive_flexs_vl

2400:
2401:
2402: CURSOR csr_fnd_desc_flex IS
2403: SELECT *
2404: FROM fnd_descriptive_flexs_vl
2405: WHERE descriptive_flexfield_name = UPPER(p_desc_flex_name);
2406:
2407: rec_fnd_desc_flex csr_fnd_desc_flex%ROWTYPE;
2408: --

Line 2570: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)

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;
2574: -- Attribute Location Type

Line 2843: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)

2839:
2840: -- QA failed due to length 30 increased to 100
2841: -- Max length based on the highest possible length of all its sources
2842: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2843: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2844: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2845:
2846: l_flexfield_name pay_user_column_instances_f.value%type;
2847: -- Flexfield Name