APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on FND_DESCR_FLEX_CONTEXTS_VL

Line 369: FROM pqp_configuration_types pct, fnd_descr_flex_contexts_vl dfc

365: -- Cursor to fetch config desc
366: CURSOR csr_get_config_desc
367: IS
368: SELECT dfc.descriptive_flex_context_name
369: FROM pqp_configuration_types pct, fnd_descr_flex_contexts_vl dfc
370: WHERE pct.configuration_type = p_config_type
371: AND dfc.descriptive_flex_context_code = pct.configuration_type
372: AND dfc.application_id = 8303
373: AND dfc.descriptive_flexfield_name =

Line 379: l_config_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;

375: AND dfc.enabled_flag = 'Y';
376:
377: l_proc_name VARCHAR2(80) := g_proc_name || 'get_config_type_desc';
378: l_proc_step PLS_INTEGER;
379: l_config_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
380: --
381: BEGIN
382: --
383: IF g_debug

Line 599: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;

595: l_proc_step PLS_INTEGER;
596: i NUMBER;
597: l_return VARCHAR2(10);
598: l_value NUMBER;
599: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
600: l_meaning hr_lookups.meaning%TYPE;
601: --
602: BEGIN
603: --

Line 1005: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;

1001: l_token2 VARCHAR2(2000);
1002: l_new_joiner VARCHAR2(10);
1003: l_ret_break VARCHAR2(10);
1004: l_meaning hr_lookups.meaning%TYPE;
1005: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
1006: l_abs_type_name per_absence_attendance_types.NAME%TYPE;
1007: l_asg_status per_assignment_status_types.user_status%TYPE;
1008: l_miss_events VARCHAR2(32000);
1009: --

Line 1671: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;

1667: l_element_type_id NUMBER;
1668: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1669: l_tab_config_values pqp_utilities.t_config_values;
1670: i NUMBER;
1671: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
1672: --
1673: BEGIN
1674: --
1675: IF g_debug