APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 126: FROM pay_element_types_f_tl pettl,

122: CURSOR csr_eit_element_name(p_element_type_id NUMBER,
123: p_effective_date DATE)
124: IS
125: SELECT nvl(pettl.reporting_name,pettl.element_name)
126: FROM pay_element_types_f_tl pettl,
127: pay_element_types_f pet
128: WHERE pet.element_type_id = p_element_type_id
129: AND pettl.element_type_id = pet.element_type_id
130: AND pettl.language = userenv('LANG')

Line 127: pay_element_types_f pet

123: p_effective_date DATE)
124: IS
125: SELECT nvl(pettl.reporting_name,pettl.element_name)
126: FROM pay_element_types_f_tl pettl,
127: pay_element_types_f pet
128: WHERE pet.element_type_id = p_element_type_id
129: AND pettl.element_type_id = pet.element_type_id
130: AND pettl.language = userenv('LANG')
131: AND p_effective_date BETWEEN pet.effective_start_date

Line 159: l_element_name pay_element_types_f.reporting_name%TYPE;

155: l_context VARCHAR2(30);
156: l_element_index PLS_INTEGER :=0;
157: l_balance_index PLS_INTEGER :=0;
158: l_element_type_id NUMBER;
159: l_element_name pay_element_types_f.reporting_name%TYPE;
160: l_input_value_id NUMBER;
161: l_element_narrative VARCHAR2(150);
162: l_input_value_name pay_input_values_f.name%TYPE;
163:

Line 469: FROM pay_element_types_f

465: CURSOR csr_eit_element_name(p_element_type_id NUMBER,
466: p_effective_date DATE)
467: IS
468: SELECT nvl(reporting_name,element_name)
469: FROM pay_element_types_f
470: WHERE element_type_id = p_element_type_id
471: AND p_effective_date BETWEEN effective_start_date
472: AND effective_end_date;
473:

Line 527: l_element_name pay_element_types_f.reporting_name%TYPE;

523: l_sum_value NUMBER:=0;
524: l_uom pay_input_values_f.uom%TYPE;
525: l_action_info_id NUMBER;
526: l_ovn NUMBER;
527: l_element_name pay_element_types_f.reporting_name%TYPE;
528: l_input_name pay_input_values_f.name%TYPE;
529: l_element_archived VARCHAR2(1);
530:
531: BEGIN