APPS.HR_LEGISLATION dependencies on HR_S_HISTORY

Line 5305: from hr_s_history;

5301: -- exist in the history table.
5302:
5303: cursor c_legs is
5304: select package_name
5305: from hr_s_history;
5306:
5307: v_package_name varchar2(30);
5308:
5309: BEGIN

Line 5352: from hr_s_history

5348: , date_of_export
5349: , sysdate
5350: , 'Phase 1'
5351: , legislation_code
5352: from hr_s_history
5353: where package_name = v_package_name;
5354:
5355: END IF;
5356:

Line 6828: from hr_s_history);

6824: update hr_stu_history
6825: set status = 'Phase '||p_phase||' has exceptions raised'
6826: where package_name in
6827: (select package_name
6828: from hr_s_history);
6829:
6830: ELSE -- number of exceptions = 0
6831:
6832: -- No exceptions have been raised, phase must have been successful

Line 6840: from hr_s_history b

6836: update hr_stu_history a
6837: set a.status = 'Complete'
6838: where exists
6839: (select null
6840: from hr_s_history b
6841: where b.package_name = a.package_name
6842: and b.date_of_export = a.date_of_export
6843: );
6844:

Line 7812: from hr_s_history;

7808: IS
7809:
7810: cursor c_main is
7811: select distinct legislation_code
7812: from hr_s_history;
7813:
7814: v_exception_counter number (15);
7815:
7816: -- This install procedure calls the parameterised install procedure.

Line 7893: from hr_s_history

7889:
7890: BEGIN
7891: select distinct legislation_code
7892: into l_leg_code
7893: from hr_s_history
7894: where legislation_code = 'ZZ';
7895:
7896: create_zz_leg_rule;
7897: