APPS.PER_SSL_BUS dependencies on PER_SALARY_SURVEYS

Line 120: from per_salary_surveys pss

116: l_exists varchar2(1);
117: --
118: cursor csr_chk_survey_exists is
119: select null
120: from per_salary_surveys pss
121: where pss.salary_survey_id = p_salary_survey_id;
122: --
123: Begin
124: --

Line 138: -- check If salary_survey_id value exists in per_salary_surveys table

134: --
135: hr_utility.set_location(l_proc,6);
136: --
137: --
138: -- check If salary_survey_id value exists in per_salary_surveys table
139: --
140: open csr_chk_survey_exists;
141: --
142: fetch csr_chk_survey_exists into l_exists;

Line 149: -- raise error as FK does not relate to PK in per_salary_surveys

145: --
146: close csr_chk_survey_exists;
147: hr_utility.set_location('SS id '||to_char(p_salary_survey_id),7);
148: --
149: -- raise error as FK does not relate to PK in per_salary_surveys
150: -- table.
151: --
152: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_FK1');
153: --

Line 421: -- c) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two

417: -- Description
418: -- This Procedure is used to check that survey_job_name_code:
419: -- a) Is not null.
420: -- b) Exists in hr_standard_lookups for lookup_type 'SURVEY_JOB_NAME'.
421: -- c) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
422: -- letters.
423: --
424: --
425: -- Pre Requisites

Line 474: from per_salary_surveys

470: l_exists Varchar2(1);
471: --
472: cursor csr_has_identifier is
473: select null
474: from per_salary_surveys
475: where salary_survey_id = p_salary_survey_id
476: and identifier = SUBSTR(p_survey_job_name_code,0,2);
477: --
478: Begin

Line 573: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two

569: --
570: -- Description
571: -- This Procedure is used to check that survey_region_code:
572: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_REGION'.
573: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
574: -- letters
575: --
576: -- Pre Requisites
577: -- None.

Line 623: from per_salary_surveys

619: l_exists Varchar2(1);
620: --
621: cursor csr_has_identifier is
622: select null
623: from per_salary_surveys
624: where salary_survey_id = p_salary_survey_id
625: and identifier = SUBSTR(p_survey_region_code,0,2);
626: --
627: --

Line 719: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two

715: --
716: -- Description
717: -- This Procedure is used to check that survey_seniority_code:
718: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_SENIORITY'.
719: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
720: -- letters
721: --
722: -- Pre Requisites
723: -- None.

Line 769: from per_salary_surveys

765: l_exists Varchar2(1);
766: --
767: cursor csr_has_identifier is
768: select null
769: from per_salary_surveys
770: where salary_survey_id = p_salary_survey_id
771: and identifier = SUBSTR(p_survey_seniority_code,0,2);
772: --
773: --

Line 864: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two

860: --
861: -- Description
862: -- This Procedure is used to check that company_size_code:
863: -- a) Exists in hr_standard_lookups for lookup_type 'COMPANY_SIZE'.
864: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
865: -- letters
866: --
867: -- Pre Requisites
868: -- None.

Line 914: from per_salary_surveys

910: l_exists Varchar2(1);
911: --
912: cursor csr_has_identifier is
913: select null
914: from per_salary_surveys
915: where salary_survey_id = p_salary_survey_id
916: and identifier = SUBSTR(p_company_size_code,0,2);
917: --
918: --

Line 1009: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two

1005: --
1006: -- Description
1007: -- This Procedure is used to check that industry_code:
1008: -- a) Exists in hr_standard_lookups for lookup_type 'INDUSTRY'.
1009: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
1010: -- letters
1011: --
1012: -- Pre Requisites
1013: -- None.

Line 1059: from per_salary_surveys

1055: l_exists Varchar2(1);
1056: --
1057: cursor csr_has_identifier is
1058: select null
1059: from per_salary_surveys
1060: where salary_survey_id = p_salary_survey_id
1061: and identifier = SUBSTR(p_industry_code,0,2);
1062: --
1063: --

Line 1158: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two

1154: --
1155: -- Description
1156: -- This Procedure is used to check that survey_age_code:
1157: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_AGE'.
1158: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
1159: -- letters
1160: --
1161: -- Pre Requisites
1162: -- None.

Line 1208: from per_salary_surveys

1204: l_exists Varchar2(1);
1205: --
1206: cursor csr_has_identifier is
1207: select null
1208: from per_salary_surveys
1209: where salary_survey_id = p_salary_survey_id
1210: and identifier = SUBSTR(p_survey_age_code,0,2);
1211: --
1212: --