APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on HR_LOOKUPS

Line 600: l_meaning hr_lookups.meaning%TYPE;

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: --
604: IF g_debug

Line 980: FROM hr_lookups

976: -- Cursor to fetch values from event desc lookup
977: CURSOR csr_get_event_desc
978: IS
979: SELECT lookup_code, meaning
980: FROM hr_lookups
981: WHERE lookup_type = 'PQP_PENSERVER_EVENT_DESC'
982: AND enabled_flag = 'Y'
983: AND g_effective_date BETWEEN NVL(
984: start_date_active

Line 998: l_event_code hr_lookups.lookup_code%TYPE;

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;
999: l_event_desc hr_lookups.meaning%TYPE;
1000: l_token1 VARCHAR2(2000);
1001: l_token2 VARCHAR2(2000);
1002: l_new_joiner VARCHAR2(10);

Line 999: l_event_desc hr_lookups.meaning%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;
999: l_event_desc hr_lookups.meaning%TYPE;
1000: l_token1 VARCHAR2(2000);
1001: l_token2 VARCHAR2(2000);
1002: l_new_joiner VARCHAR2(10);
1003: l_ret_break VARCHAR2(10);

Line 1004: l_meaning hr_lookups.meaning%TYPE;

1000: l_token1 VARCHAR2(2000);
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);