APPS.HR_LEGISLATION dependencies on HR_S_ASSIGNMENT_STATUS_TYPES

Line 630: from hr_s_assignment_status_types;

626: , assignment_status_type_id c_surrogate_key
627: , last_update_date
628: , legislation_code c_leg_code
629: , null c_leg_sgrp
630: from hr_s_assignment_status_types;
631:
632: stu_rec stu%ROWTYPE; -- Record for above SELECT
633:
634: PROCEDURE crt_exc (exception_type IN varchar2)

Line 692: from hr_s_assignment_status_types;

688: --with the delivered values
689:
690: select count(*)
691: into cnt
692: from hr_s_assignment_status_types;
693:
694: If cnt=0 then return; end if;
695:
696: select distinct null

Line 701: from hr_s_assignment_status_types b

697: into l_null_return
698: from per_assignment_status_types a
699: where exists
700: (select null
701: from hr_s_assignment_status_types b
702: where a.assignment_status_type_id=b.assignment_status_type_id
703: );
704:
705: --conflict may exist

Line 708: update /*+NO_INDEX*/ hr_s_assignment_status_types

704:
705: --conflict may exist
706: --update all assignment_status_type_id's to remove conflict
707:
708: update /*+NO_INDEX*/ hr_s_assignment_status_types
709: set assignment_status_type_id=assignment_status_type_id - 50000000;
710:
711: update /*+NO_INDEX*/ hr_s_status_processing_rules_f
712: set assignment_status_type_id=assignment_status_type_id - 50000000;

Line 726: from hr_s_assignment_status_types;

722: select min(assignment_status_type_id) - (count(*) *3)
723: , max(assignment_status_type_id) + (count(*) *3)
724: into v_min_delivered
725: , v_max_delivered
726: from hr_s_assignment_status_types;
727:
728: select max(assignment_status_type_id)
729: into v_max_live
730: from per_assignment_status_types;

Line 807: update hr_s_assignment_status_types

803: hrrunprc_trace_off;
804: raise;
805: END;
806:
807: update hr_s_assignment_status_types
808: set assignment_status_type_id = l_new_surrogate_key
809: where assignment_status_type_id = stu_rec.c_surrogate_key;
810:
811: update hr_s_status_processing_rules_f

Line 831: delete from hr_s_assignment_status_types

827:
828: BEGIN
829:
830: IF subject = 'D' THEN
831: delete from hr_s_assignment_status_types
832: where rowid = stu_rec.rowid;
833: ELSE
834: IF p_phase = 1 THEN return; END IF;
835: delete from per_assignment_status_types

Line 1030: from hr_s_assignment_status_types

1026: ,LAST_UPDATED_BY
1027: ,LAST_UPDATE_LOGIN
1028: ,CREATED_BY
1029: ,CREATION_DATE
1030: from hr_s_assignment_status_types
1031: where rowid = stu_rec.rowid;
1032:
1033: END IF;
1034: