DBA Data[Home] [Help]

APPS.HR_SALARY_SURVEY_MAPPING_API dependencies on PER_SALARY_SURVEY_LINES

Line 625: per_salary_survey_lines ssl

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
629: group by ssm.location_id,

Line 658: from per_salary_survey_lines ssl

654: ,c_industry_code varchar2
655: ,c_date_from date
656: ,c_date_to date) is
657: select salary_survey_line_id
658: from per_salary_survey_lines ssl
659: where ssl.start_date between c_date_from and c_date_to
660: and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)
661: and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)
662: and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)