APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F

Line 5998: from pay_element_types_f pet

5994: --
5995: Cursor csr_ele_type_id ( c_element_name in varchar2
5996: ,c_effective_date in date ) Is
5997: Select pet.element_type_id
5998: from pay_element_types_f pet
5999: where c_effective_date between pet.effective_start_date
6000: and pet.effective_end_date
6001: and pet.element_name = c_element_name;
6002: --

Line 6023: l_element_name pay_element_types_f.element_name%TYPE;

6019: Type t_allowance_code Is Table of varchar2(1) Index By BINARY_INTEGER;
6020:
6021: l_udt_allowance_code t_allowance_code;
6022: l_allowance_code varchar2(1);
6023: l_element_name pay_element_types_f.element_name%TYPE;
6024: l_input_value_name pay_input_values_f.name%TYPE;
6025: l_element_type_id pay_element_types_f.element_type_id%TYPE;
6026: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
6027: l_count_ele_entries Number;

Line 6025: l_element_type_id pay_element_types_f.element_type_id%TYPE;

6021: l_udt_allowance_code t_allowance_code;
6022: l_allowance_code varchar2(1);
6023: l_element_name pay_element_types_f.element_name%TYPE;
6024: l_input_value_name pay_input_values_f.name%TYPE;
6025: l_element_type_id pay_element_types_f.element_type_id%TYPE;
6026: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
6027: l_count_ele_entries Number;
6028: l_return_value char(7) := ' ';
6029: l_error_value number;

Line 6345: ,pay_element_types_f pet

6341: ,p_date IN DATE )IS
6342: select 'Y'
6343: from pay_element_links_f pel
6344: ,pay_element_entries_f pee
6345: ,pay_element_types_f pet
6346: where pet.element_type_id = pel.element_type_id
6347: and pel.element_link_id = pee.element_link_id
6348: and pee.assignment_id = p_assignment_id
6349: and pet.element_type_id = p_element_type_id

Line 13525: l_index pay_element_types_f.element_type_id%TYPE;

13521: FUNCTION get_grade_sp_type (p_tab_ele_ids IN t_ele_ids_from_bal)
13522: RETURN VARCHAR2
13523: IS
13524:
13525: l_index pay_element_types_f.element_type_id%TYPE;
13526: l_grd_type pay_grade_rules_f.rate_type%TYPE:='N';
13527: l_proc_name varchar2(61) := g_proc_name || 'get_grade_sp_type';
13528:
13529: CURSOR csr_chk_pay_src(p_ele_id NUMBER) IS