APPS.HR_REPORTS dependencies on PAY_ELEMENT_TYPES_F

Line 509: v_element_name pay_element_types_f_tl.element_name%type;

505: (p_session_date DATE,
506: p_element_type_id NUMBER) return VARCHAR2
507: --
508: AS
509: v_element_name pay_element_types_f_tl.element_name%type;
510: --
511: begin
512: hr_utility.trace('Entered hr_reports.get_element_name');
513: --

Line 522: from pay_element_types_f_tl etl,

518: begin
519: hr_utility.set_location('hr_reports.get_element_name',10);
520: select etl.element_name
521: into v_element_name
522: from pay_element_types_f_tl etl,
523: pay_element_types_f e
524: where e.element_type_id = p_element_type_id
525: and p_session_date between
526: e.effective_start_date and

Line 523: pay_element_types_f e

519: hr_utility.set_location('hr_reports.get_element_name',10);
520: select etl.element_name
521: into v_element_name
522: from pay_element_types_f_tl etl,
523: pay_element_types_f e
524: where e.element_type_id = p_element_type_id
525: and p_session_date between
526: e.effective_start_date and
527: e.effective_end_date