APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_CONFIGURATION_TYPES

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 883: l_configuration_type pqp_configuration_types.configuration_type%TYPE;

879: --
880: l_proc_name VARCHAR2(80)
881: := g_proc_name || 'fetch_process_defn_cv';
882: l_proc_step PLS_INTEGER;
883: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
884: l_tab_config_values pqp_utilities.t_config_values;
885: i NUMBER;
886: --
887: BEGIN

Line 994: l_configuration_type pqp_configuration_types.configuration_type%TYPE;

990:
991: l_proc_name VARCHAR2(80)
992: := g_proc_name || 'fetch_event_map_cv';
993: l_proc_step PLS_INTEGER;
994: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
995: l_tab_config_values pqp_utilities.t_config_values;
996: i NUMBER;
997: j NUMBER;
998: l_event_code hr_lookups.lookup_code%TYPE;

Line 1568: l_configuration_type pqp_configuration_types.configuration_type%TYPE;

1564: l_proc_name VARCHAR2(80)
1565: := g_proc_name || 'fetch_pension_scheme_map_cv';
1566: l_proc_step PLS_INTEGER;
1567: l_element_type_id NUMBER;
1568: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1569: l_tab_config_values pqp_utilities.t_config_values;
1570: i NUMBER;
1571: --
1572: BEGIN

Line 1686: l_configuration_type pqp_configuration_types.configuration_type%TYPE;

1682: l_proc_name VARCHAR2(80)
1683: := g_proc_name || 'fetch_leaving_reason_map_cv';
1684: l_proc_step PLS_INTEGER;
1685: l_element_type_id NUMBER;
1686: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1687: l_tab_config_values pqp_utilities.t_config_values;
1688: i NUMBER;
1689: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
1690: --

Line 1811: l_configuration_type pqp_configuration_types.configuration_type%TYPE;

1807: --
1808: l_proc_name VARCHAR2(80)
1809: := g_proc_name || 'fetch_empl_type_map_cv';
1810: l_proc_step PLS_INTEGER;
1811: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1812: i NUMBER;
1813: l_tab_config_values pqp_utilities.t_config_values;
1814: --
1815: BEGIN