APPS.HR_SALARY_SURVEY_MAPPING_API dependencies on PER_SALARY_SURVEY_MAPPINGS

Line 613: cursor csr_get_mappings(c_table_name per_salary_survey_mappings.parent_table_name%TYPE) is

609: from hr_positions_f p
610: where p.position_id = p_position_id
611: and p.effective_end_date = hr_general.end_of_time;
612: --
613: cursor csr_get_mappings(c_table_name per_salary_survey_mappings.parent_table_name%TYPE) is
614: select ssm.location_id location_id,
615: ssm.grade_id grade_id,
616: ssm.company_organization_id company_organization_id,
617: ssm.company_age_code company_age_code,

Line 624: from per_salary_survey_mappings ssm,

620: ssl.survey_seniority_code survey_seniority_code,
621: ssl.company_size_code company_size_code,
622: ssl.industry_code industry_code,
623: max(ssl.end_date) max_end_date
624: from per_salary_survey_mappings ssm,
625: per_salary_survey_lines ssl
626: where nvl(p_job_id,p_position_id) = ssm.parent_id
627: and ssl.salary_survey_line_id = ssm.salary_survey_line_id
628: and parent_table_name = c_table_name