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

1546: l_proc_name VARCHAR2(80)
1547: := g_proc_name || 'fetch_pension_scheme_map_cv';
1548: l_proc_step PLS_INTEGER;
1549: l_element_type_id NUMBER;
1550: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1551: l_tab_config_values pqp_utilities.t_config_values;
1552: i NUMBER;
1553: --
1554: BEGIN

Line 1668: l_configuration_type pqp_configuration_types.configuration_type%TYPE;

1664: l_proc_name VARCHAR2(80)
1665: := g_proc_name || 'fetch_leaving_reason_map_cv';
1666: l_proc_step PLS_INTEGER;
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: --

Line 1793: l_configuration_type pqp_configuration_types.configuration_type%TYPE;

1789: --
1790: l_proc_name VARCHAR2(80)
1791: := g_proc_name || 'fetch_empl_type_map_cv';
1792: l_proc_step PLS_INTEGER;
1793: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1794: i NUMBER;
1795: l_tab_config_values pqp_utilities.t_config_values;
1796: --
1797: BEGIN