APPS.PER_QUA_BUS dependencies on PER_SUBJECTS_TAKEN

Line 1040: from per_subjects_taken per

1036: -- dates of the qualification.
1037: --
1038: cursor c2 is
1039: select null
1040: from per_subjects_taken per
1041: where per.qualification_id = p_qualification_id
1042: and per.start_date
1043: not between nvl(p_start_date,hr_api.g_sot)
1044: and nvl(p_end_date,hr_api.g_eot);

Line 1229: from per_subjects_taken per

1225: --
1226:
1227: cursor c1 is
1228: select null
1229: from per_subjects_taken per
1230: where per.qualification_id = p_qualification_id
1231: and nvl(per.end_date,per.start_date) > nvl(p_end_date,hr_api.g_eot);
1232:
1233: Begin

Line 1696: from per_subjects_taken per

1692: l_dummy varchar2(1);
1693: --
1694: cursor c1 is
1695: select null
1696: from per_subjects_taken per
1697: where per.qualification_id = p_qualification_id;
1698: --
1699: Begin
1700: --

Line 1707: -- check if referenced records exist in the PER_SUBJECTS_TAKEN table.

1703: if hr_multi_message.no_all_inclusive_error
1704: (p_check_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1705: ) then
1706: --
1707: -- check if referenced records exist in the PER_SUBJECTS_TAKEN table.
1708: --
1709: open c1;
1710: --
1711: fetch c1 into l_dummy;