DBA Data[Home] [Help]

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_SALARY_SURVEY_MAPPINGS

Line 61: ,per_salary_survey_mappings pss_mappings

57: pct75_salary
58: ,pss_lines.maximum_pay max_salary
59: FROM per_salary_surveys pss
60: ,per_salary_survey_lines pss_lines
61: ,per_salary_survey_mappings pss_mappings
62: WHERE pss.salary_survey_id = g_salary_survey_id
63: AND pss_lines.salary_survey_id = pss.salary_survey_id
64: AND v_effective_date BETWEEN pss_lines.start_date
65: AND NVL(pss_lines.end_date, to_date('4712/12/31', 'yyyy/mm/dd'))