APPS.HR_LEGISLATION dependencies on HR_S_HISTORY

Line 5055: from hr_s_history;

5051: -- exist in the history table.
5052:
5053: cursor c_legs is
5054: select package_name
5055: from hr_s_history;
5056:
5057: v_package_name varchar2(30);
5058:
5059: BEGIN

Line 5102: from hr_s_history

5098: , date_of_export
5099: , sysdate
5100: , 'Phase 1'
5101: , legislation_code
5102: from hr_s_history
5103: where package_name = v_package_name;
5104:
5105: END IF;
5106:

Line 6578: from hr_s_history);

6574: update hr_stu_history
6575: set status = 'Phase '||p_phase||' has exceptions raised'
6576: where package_name in
6577: (select package_name
6578: from hr_s_history);
6579:
6580: ELSE -- number of exceptions = 0
6581:
6582: -- No exceptions have been raised, phase must have been successful

Line 6590: from hr_s_history b

6586: update hr_stu_history a
6587: set a.status = 'Complete'
6588: where exists
6589: (select null
6590: from hr_s_history b
6591: where b.package_name = a.package_name
6592: and b.date_of_export = a.date_of_export
6593: );
6594:

Line 7562: from hr_s_history;

7558: IS
7559:
7560: cursor c_main is
7561: select distinct legislation_code
7562: from hr_s_history;
7563:
7564: v_exception_counter number (15);
7565:
7566: -- This install procedure calls the parameterised install procedure.

Line 7635: from hr_s_history

7631:
7632: BEGIN
7633: select distinct legislation_code
7634: into l_leg_code
7635: from hr_s_history
7636: where legislation_code = 'ZZ';
7637:
7638: create_zz_leg_rule;
7639: