APPS.PER_AST_BUS dependencies on PER_ASSESSMENTS

Line 313: from per_assessments ass

309: -- the assessment_type being checked
310: --
311: cursor csr_assessment_dates is
312: select min(assessment_date) , max(assessment_date)
313: from per_assessments ass
314: where p_assessment_type_id = ass.assessment_type_id
315: and (p_business_group_id = business_group_id or p_business_group_id is null) ;
316:
317: --

Line 318: l_min_assessment_date per_assessments.assessment_date%TYPE;

314: where p_assessment_type_id = ass.assessment_type_id
315: and (p_business_group_id = business_group_id or p_business_group_id is null) ;
316:
317: --
318: l_min_assessment_date per_assessments.assessment_date%TYPE;
319: l_max_assessment_date per_assessments.assessment_date%TYPE;
320: --
321: begin
322: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 319: l_max_assessment_date per_assessments.assessment_date%TYPE;

315: and (p_business_group_id = business_group_id or p_business_group_id is null) ;
316:
317: --
318: l_min_assessment_date per_assessments.assessment_date%TYPE;
319: l_max_assessment_date per_assessments.assessment_date%TYPE;
320: --
321: begin
322: hr_utility.set_location('Entering:'|| l_proc, 1);
323: --

Line 430: from per_assessments

426: -- Define the cursor to check if the assessment_type is used in an assessment
427: --
428: cursor csr_assessment_type_usage is
429: select null
430: from per_assessments
431: where assessment_type_id = p_assessment_type_id
432: and (p_business_group_id = business_group_id or p_business_group_id is null) ;
433:
434: --

Line 556: from per_assessments

552: -- Define the cursor to check if the assessment_type is used in an assessment
553: --
554: cursor csr_assessment_type_usage is
555: select null
556: from per_assessments
557: where assessment_type_id = p_assessment_type_id
558: and ( business_group_id = p_business_group_id or p_business_group_id is null) ;
559: --
560: -- Define the local variables for the cursor to go

Line 757: from per_assessments

753: -- Define the cursor to check if the assessment_type is used in an assessment
754: --
755: cursor csr_assessment_type_usage is
756: select null
757: from per_assessments
758: where assessment_type_id = p_assessment_type_id
759: and business_group_id = p_business_group_id;
760: --
761: -- Define the local variables for the cursor to go

Line 1273: from per_assessments

1269: -- Define a cursor to get an assessment which uses this assessment_type.
1270: --
1271: cursor csr_assessment_type_usage is
1272: select null
1273: from per_assessments
1274: where assessment_type_id = p_assessment_type_id;
1275: --
1276: Begin
1277: hr_utility.set_location('Entering '||l_proc,1);