APPS.HR_LEGISLATION dependencies on HR_S_ASSIGNMENT_STATUS_TYPES

Line 835: from hr_s_assignment_status_types;

831: , assignment_status_type_id c_surrogate_key
832: , last_update_date
833: , legislation_code c_leg_code
834: , null c_leg_sgrp
835: from hr_s_assignment_status_types;
836:
837: stu_rec stu%ROWTYPE; -- Record for above SELECT
838:
839: PROCEDURE crt_exc (exception_type IN varchar2)

Line 897: from hr_s_assignment_status_types;

893: --with the delivered values
894:
895: select count(*)
896: into cnt
897: from hr_s_assignment_status_types;
898:
899: If cnt=0 then return; end if;
900:
901: select distinct null

Line 906: from hr_s_assignment_status_types b

902: into l_null_return
903: from per_assignment_status_types a
904: where exists
905: (select null
906: from hr_s_assignment_status_types b
907: where a.assignment_status_type_id=b.assignment_status_type_id
908: );
909:
910: --conflict may exist

Line 913: update /*+NO_INDEX*/ hr_s_assignment_status_types

909:
910: --conflict may exist
911: --update all assignment_status_type_id's to remove conflict
912:
913: update /*+NO_INDEX*/ hr_s_assignment_status_types
914: set assignment_status_type_id=assignment_status_type_id - 50000000;
915:
916: update /*+NO_INDEX*/ hr_s_status_processing_rules_f
917: set assignment_status_type_id=assignment_status_type_id - 50000000;

Line 931: from hr_s_assignment_status_types;

927: select min(assignment_status_type_id) - (count(*) *3)
928: , max(assignment_status_type_id) + (count(*) *3)
929: into v_min_delivered
930: , v_max_delivered
931: from hr_s_assignment_status_types;
932:
933: select max(assignment_status_type_id)
934: into v_max_live
935: from per_assignment_status_types;

Line 1012: update hr_s_assignment_status_types

1008: hrrunprc_trace_off;
1009: raise;
1010: END;
1011:
1012: update hr_s_assignment_status_types
1013: set assignment_status_type_id = l_new_surrogate_key
1014: where assignment_status_type_id = stu_rec.c_surrogate_key;
1015:
1016: update hr_s_status_processing_rules_f

Line 1036: delete from hr_s_assignment_status_types

1032:
1033: BEGIN
1034:
1035: IF subject = 'D' THEN
1036: delete from hr_s_assignment_status_types
1037: where rowid = stu_rec.rowid;
1038: ELSE
1039: IF p_phase = 1 THEN return; END IF;
1040: delete from per_assignment_status_types

Line 1235: from hr_s_assignment_status_types

1231: ,LAST_UPDATED_BY
1232: ,LAST_UPDATE_LOGIN
1233: ,CREATED_BY
1234: ,CREATION_DATE
1235: from hr_s_assignment_status_types
1236: where rowid = stu_rec.rowid;
1237:
1238: END IF;
1239: