APPS.PAY_US_TAX_UDFS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 51: ln_element_type_id pay_element_types_f.element_type_id%TYPE;

47:
48: ln_return number;
49: ln_cnt number;
50: ln_found number;
51: ln_element_type_id pay_element_types_f.element_type_id%TYPE;
52: lv_level fnd_lookup_values.meaning%TYPE;
53: lv_state_code pay_us_states.state_code%TYPE;
54: lv_calc_method fnd_lookup_values.lookup_code%TYPE;
55:

Line 132: from pay_element_types_f pet,

128: select pet.element_type_id,
129: petei.EEI_INFORMATION2,
130: petei.EEI_INFORMATION4,
131: petei.EEI_INFORMATION5
132: from pay_element_types_f pet,
133: pay_element_type_extra_info petei
134: where pet.element_type_id = p_element_type_id
135: and p_date_earned between pet.effective_start_date
136: and pet.effective_end_date

Line 141: ln_element_type_id pay_element_types_f.element_type_id%TYPE;

137: and petei.INFORMATION_TYPE = 'PAY_US_TAX_CALCULATION_METHOD'
138: and petei.element_type_id = pet.element_type_id;
139:
140:
141: ln_element_type_id pay_element_types_f.element_type_id%TYPE;
142: lv_level fnd_lookup_values.meaning%TYPE;
143: lv_state_code pay_us_states.state_code%TYPE;
144: lv_calc_method fnd_lookup_values.lookup_code%TYPE;
145: