DBA Data[Home] [Help]

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_SALARY_SURVEY_MAPPINGS

Line 64: ,per_salary_survey_mappings pss_mappings

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