APPS.PER_POSITIONS_PKG dependencies on PER_VALID_GRADES

Line 215: FROM PER_VALID_GRADES VG1

211: select '1'
212: into l_exists
213: from sys.dual
214: where exists(SELECT NULL
215: FROM PER_VALID_GRADES VG1
216: WHERE business_group_id + 0 = p_business_group_id
217: AND VG1.POSITION_ID = p_position_id);
218: exception when no_data_found then
219: null;

Line 1006: FROM per_valid_grades

1002: -- declare cursor
1003: --
1004: CURSOR get_grades IS
1005: SELECT 'Y'
1006: FROM per_valid_grades
1007: WHERE position_id = p_position_id
1008: AND date_from < p_date_effective;
1009: --
1010: --declare local variables

Line 1044: from per_valid_grades

1040: p_end_date_blank IN OUT NOCOPY BOOLEAN,
1041: p_after_date_to IN OUT NOCOPY BOOLEAN) IS
1042: --
1043: cursor csr_date_to is select null
1044: from per_valid_grades
1045: where position_id = p_position_id
1046: and nvl(date_to, p_end_of_time) > p_date_end;
1047: --
1048: cursor csr_date_from is select null

Line 1049: from per_valid_grades vg

1045: where position_id = p_position_id
1046: and nvl(date_to, p_end_of_time) > p_date_end;
1047: --
1048: cursor csr_date_from is select null
1049: from per_valid_grades vg
1050: where vg.position_id = p_position_id
1051: and vg.date_from > p_date_end;
1052: --
1053: --

Line 1060: from per_valid_grades vg , per_positions p

1056: -- currently valid grade end date. PASHUN. 24-FEB-1998.
1057: --
1058: --
1059: cursor csr_end_date_blank is select null
1060: from per_valid_grades vg , per_positions p
1061: where vg.position_id = p_position_id
1062: and p.position_id = p_position_id
1063: and nvl(vg.date_to, p_end_of_time) =
1064: nvl(p.date_end, p_end_of_time)

Line 1075: from per_valid_grades vg , per_positions p

1071: -- date. PASHUN. 24-FEB-1998.
1072: --
1073: --
1074: cursor csr_after_date_to is select null
1075: from per_valid_grades vg , per_positions p
1076: where vg.position_id = p_position_id
1077: and p.position_id = p_position_id
1078: and nvl(vg.date_to,p_end_of_time) <
1079: nvl(p_date_end,p_end_of_time)

Line 1133: update per_valid_grades vg

1129: -- Update valid grade end dates to match the end date of the
1130: -- position where the end date of the position is earlier than the end
1131: -- date of the valid grade or the previous end dates matched.
1132: --
1133: update per_valid_grades vg
1134: set vg.date_to =
1135: (select least(nvl(p_date_end, p_end_of_time),
1136: nvl(g.date_to, p_end_of_time))
1137: from per_grades g

Line 1159: delete from per_valid_grades

1155: -- Valid grades are deleted if the end date of the position
1156: -- has been made earlier than the start date of the
1157: -- valid grade.
1158: --
1159: delete from per_valid_grades
1160: where position_id = p_position_id
1161: and date_from > p_date_end;
1162: --
1163: if (SQL%NOTFOUND) then

Line 1180: update per_valid_grades vg

1176: -- new end date of the position and the end date for the grade, where the old
1177: -- end date of the position matches the end date of the valid grade.
1178: -- PASHUN. 24-FEB-1998.
1179: --
1180: update per_valid_grades vg
1181: set vg.date_to =
1182: (select decode(least(nvl(p_date_end, p_end_of_time),
1183: nvl(g.date_to,p_end_of_time)),
1184: p_date_end,