APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F

Line 5970: from pay_element_types_f pet

5966: --
5967: Cursor csr_ele_type_id ( c_element_name in varchar2
5968: ,c_effective_date in date ) Is
5969: Select pet.element_type_id
5970: from pay_element_types_f pet
5971: where c_effective_date between pet.effective_start_date
5972: and pet.effective_end_date
5973: and pet.element_name = c_element_name;
5974: --

Line 5995: l_element_name pay_element_types_f.element_name%TYPE;

5991: Type t_allowance_code Is Table of varchar2(1) Index By BINARY_INTEGER;
5992:
5993: l_udt_allowance_code t_allowance_code;
5994: l_allowance_code varchar2(1);
5995: l_element_name pay_element_types_f.element_name%TYPE;
5996: l_input_value_name pay_input_values_f.name%TYPE;
5997: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5998: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5999: l_count_ele_entries Number;

Line 5997: l_element_type_id pay_element_types_f.element_type_id%TYPE;

5993: l_udt_allowance_code t_allowance_code;
5994: l_allowance_code varchar2(1);
5995: l_element_name pay_element_types_f.element_name%TYPE;
5996: l_input_value_name pay_input_values_f.name%TYPE;
5997: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5998: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5999: l_count_ele_entries Number;
6000: l_return_value char(7) := ' ';
6001: l_error_value number;

Line 6317: ,pay_element_types_f pet

6313: ,p_date IN DATE )IS
6314: select 'Y'
6315: from pay_element_links_f pel
6316: ,pay_element_entries_f pee
6317: ,pay_element_types_f pet
6318: where pet.element_type_id = pel.element_type_id
6319: and pel.element_link_id = pee.element_link_id
6320: and pee.assignment_id = p_assignment_id
6321: and pet.element_type_id = p_element_type_id

Line 13326: l_index pay_element_types_f.element_type_id%TYPE;

13322: FUNCTION get_grade_sp_type (p_tab_ele_ids IN t_ele_ids_from_bal)
13323: RETURN VARCHAR2
13324: IS
13325:
13326: l_index pay_element_types_f.element_type_id%TYPE;
13327: l_grd_type pay_grade_rules_f.rate_type%TYPE:='N';
13328: l_proc_name varchar2(61) := g_proc_name || 'get_grade_sp_type';
13329:
13330: CURSOR csr_chk_pay_src(p_ele_id NUMBER) IS