APPS.PAY_KR_SEP_FORM_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 18: type screen_entry_value_tbl is table of pay_element_entry_values_f.screen_entry_value%type index by binary_integer;

14: g_legislation_code varchar2(2);
15: g_session_date date;
16: g_element_entry_id number;
17: g_input_value_index number;
18: type screen_entry_value_tbl is table of pay_element_entry_values_f.screen_entry_value%type index by binary_integer;
19: g_screen_entry_value_tbl screen_entry_value_tbl;
20: type element_name_tbl is table of pay_element_types_f.element_name%type index by binary_integer;
21: type element_type_id_tbl is table of pay_element_types_f.element_type_id%type index by binary_integer;
22: type input_value_id_tbl is table of pay_input_values_f.input_value_id%type index by binary_integer;

Line 1988: l_value pay_element_entry_values_f.screen_entry_value%type;

1984: p_ee_effective_end_date in date) return varchar2
1985: --------------------------------------------------------------------------------
1986: is
1987: --
1988: l_value pay_element_entry_values_f.screen_entry_value%type;
1989: l_input_value_id number;
1990: l_input_value_id_tbl input_value_id_tbl;
1991: l_screen_entry_value_tbl screen_entry_value_tbl;
1992: --

Line 1997: from pay_element_entry_values_f peev

1993: cursor csr_entry_value
1994: is
1995: select peev.input_value_id input_value_id,
1996: peev.screen_entry_value screen_entry_value
1997: from pay_element_entry_values_f peev
1998: where peev.element_entry_id = p_ee_element_entry_id
1999: and peev.effective_start_date = p_ee_effective_start_date
2000: and peev.effective_end_date = p_ee_effective_end_date;
2001: --

Line 2042: l_screen_value pay_element_entry_values_f.screen_entry_value%type;

2038: --------------------------------------------------------------------------------
2039: is
2040: --
2041: l_input_value_id number;
2042: l_screen_value pay_element_entry_values_f.screen_entry_value%type;
2043: l_value varchar2(240);
2044: --
2045: cursor csr_entry_value
2046: is