DBA Data[Home] [Help]

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_SALARY_SURVEY_LINES

Line 60: ,per_salary_survey_lines pss_lines

56: (pss_lines.maximum_pay-pss_lines.minimum_pay)*0.75)
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