APPS.HR_US_OSHA dependencies on PER_ANALYSIS_CRITERIA

Line 59: from per_analysis_criteria pac,

55: cursor c1 is
56: select null
57: from sys.dual
58: where exists (select null
59: from per_analysis_criteria pac,
60: fnd_id_flex_structures fif
61: where pac.id_flex_num = fif.id_flex_num
62: and fif.id_flex_structure_code = 'OSHA-REPORTABLE_INCIDENT'
63: and pac.segment1 = v_case_number);

Line 67: from per_analysis_criteria pac,

63: and pac.segment1 = v_case_number);
64: --
65: cursor c2 is
66: select max(pac.segment1)+v_case_number
67: from per_analysis_criteria pac,
68: fnd_id_flex_structures fif
69: where pac.id_flex_num = fif.id_flex_num
70: and fif.id_flex_structure_code = 'OSHA-REPORTABLE_INCIDENT';
71: --