APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 128: FROM pay_element_types_f_tl pettl,

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

Line 129: pay_element_types_f pet

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

Line 161: l_element_name pay_element_types_f.reporting_name%TYPE;

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

Line 471: FROM pay_element_types_f

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

Line 529: l_element_name pay_element_types_f.reporting_name%TYPE;

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