DBA Data[Home] [Help]

APPS.PER_SSL_BUS dependencies on PER_SALARY_SURVEY_LINES

Line 53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,

49: Procedure chk_unique_key
50: (p_salary_survey_line_id in number,
51: p_object_version_number in number,
52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,

Line 54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,

50: (p_salary_survey_line_id in number,
51: p_object_version_number in number,
52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,

Line 55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,

51: p_object_version_number in number,
52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,

Line 56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,

52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);

Line 57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,

53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:

Line 58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,

54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:
62:

Line 59: p_start_date in per_salary_survey_lines.start_date%TYPE,

55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:
62:
63: --

Line 60: p_end_date in per_salary_survey_lines.end_date%TYPE);

56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:
62:
63: --
64: -- ---------------------------------------------------------------

Line 119: in per_salary_survey_lines.currency_code%TYPE,

115: in number,
116: p_object_version_number
117: in number,
118: p_currency_code
119: in per_salary_survey_lines.currency_code%TYPE,
120: p_minimum_pay
121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,

Line 121: in per_salary_survey_lines.minimum_pay%TYPE,

117: in number,
118: p_currency_code
119: in per_salary_survey_lines.currency_code%TYPE,
120: p_minimum_pay
121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,

Line 123: in per_salary_survey_lines.mean_pay%TYPE,

119: in per_salary_survey_lines.currency_code%TYPE,
120: p_minimum_pay
121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,

Line 125: in per_salary_survey_lines.maximum_pay%TYPE,

121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,

Line 127: in per_salary_survey_lines.graduate_pay%TYPE,

123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,

Line 129: in per_salary_survey_lines.starting_pay%TYPE,

125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,

Line 131: in per_salary_survey_lines.percentage_change%TYPE,

127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,

Line 133: in per_salary_survey_lines.job_first_quartile%TYPE,

129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,

Line 135: in per_salary_survey_lines.job_median_quartile%TYPE,

131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,

Line 137: in per_salary_survey_lines.job_third_quartile%TYPE,

133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,

Line 139: in per_salary_survey_lines.job_fourth_quartile%TYPE,

135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,

Line 141: in per_salary_survey_lines.minimum_total_compensation%TYPE,

137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,

Line 143: in per_salary_survey_lines.mean_total_compensation%TYPE,

139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,

Line 145: in per_salary_survey_lines.maximum_total_compensation%TYPE,

141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,

Line 147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,

143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,

Line 149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,

145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
152: p_compnstn_fourth_quartile
153: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE

Line 151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,

147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
152: p_compnstn_fourth_quartile
153: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE
154: );
155:

Line 153: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE

149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
152: p_compnstn_fourth_quartile
153: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE
154: );
155:
156:
157: --