APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_PERIODS_OF_PLACEMENT

Line 306: from per_periods_of_placement pp

302: -- CWK periofs of placement
303: --
304: cursor csr_periods_of_placement is
305: select pp.rowid
306: from per_periods_of_placement pp
307: where pp.person_id = p_person_id
308: for update of person_id;
309: --
310: cursor csr_assignment_rate_values is

Line 2342: from per_periods_of_placement pp

2338: --
2339: --
2340: cursor csr_is_cwk(cp_date_start date) is -- 3194314
2341: select pp.period_of_placement_id, pp.date_start
2342: from per_periods_of_placement pp
2343: where pp.person_id = p_person_id
2344: and pp.actual_termination_date = cp_date_start - 1;
2345:
2346: l_pp_id number;

Line 4680: FROM per_periods_of_placement pp

4676: AND paf.person_id = p_person_id);
4677: --
4678: CURSOR csr_periods_of_placement IS
4679: SELECT pp.rowid
4680: FROM per_periods_of_placement pp
4681: WHERE pp.person_id = p_person_id
4682: AND pp.date_start = p_date_start;
4683: --
4684: CURSOR csr_pop_back_to_back (p_date_start IN DATE) IS

Line 4686: FROM per_periods_of_placement pp

4682: AND pp.date_start = p_date_start;
4683: --
4684: CURSOR csr_pop_back_to_back (p_date_start IN DATE) IS
4685: SELECT pp.period_of_placement_id
4686: FROM per_periods_of_placement pp
4687: WHERE pp.person_id = p_person_id
4688: AND pp.actual_termination_date = p_date_start -1;
4689: --
4690: CURSOR csr_pos_back_to_back (p_date_start IN DATE) IS

Line 4700: FROM per_periods_of_placement pop

4696:
4697: -- Change for the bug 6460093 starts here
4698: CURSOR csr_pdped_start is
4699: SELECT pop.date_start
4700: FROM per_periods_of_placement pop
4701: WHERE pop.person_id = p_person_id
4702: AND p_effective_date between pop.date_start and
4703: nvl(pop.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'));
4704:

Line 5070: DELETE FROM per_periods_of_placement

5066: FETCH csr_periods_of_placement INTO l_rowid;
5067: --
5068: EXIT WHEN csr_periods_of_placement%NOTFOUND;
5069: --
5070: DELETE FROM per_periods_of_placement
5071: WHERE rowid = l_rowid;
5072: --
5073: IF SQL%NOTFOUND THEN
5074: --