DBA Data[Home] [Help]

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 2397: FROM fnd_descriptive_flexs_vl

2393:
2394:
2395: CURSOR csr_fnd_desc_flex IS
2396: SELECT *
2397: FROM fnd_descriptive_flexs_vl
2398: WHERE descriptive_flexfield_name = UPPER(p_desc_flex_name);
2399:
2400: rec_fnd_desc_flex csr_fnd_desc_flex%ROWTYPE;
2401: --

Line 2563: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)

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

Line 2836: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)

2832:
2833: -- QA failed due to length 30 increased to 100
2834: -- Max length based on the highest possible length of all its sources
2835: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2836: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2837: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2838:
2839: l_flexfield_name pay_user_column_instances_f.value%type;
2840: -- Flexfield Name