APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_PERIODS_OF_PLACEMENT

Line 138: from per_periods_of_placement pp

134: -- CWK periofs of placement
135: --
136: cursor csr_periods_of_placement is
137: select pp.rowid
138: from per_periods_of_placement pp
139: where pp.person_id = p_person_id
140: for update of person_id;
141: --
142: cursor csr_assignment_rate_values is

Line 1422: from per_periods_of_placement pp

1418: --
1419: --
1420: cursor csr_is_cwk(cp_date_start date) is -- 3194314
1421: select pp.period_of_placement_id, pp.date_start
1422: from per_periods_of_placement pp
1423: where pp.person_id = p_person_id
1424: and pp.actual_termination_date = cp_date_start - 1;
1425:
1426: l_pp_id number;

Line 3453: FROM per_periods_of_placement pp

3449: AND paf.person_id = p_person_id);
3450: --
3451: CURSOR csr_periods_of_placement IS
3452: SELECT pp.rowid
3453: FROM per_periods_of_placement pp
3454: WHERE pp.person_id = p_person_id
3455: AND pp.date_start = p_date_start;
3456: --
3457: CURSOR csr_pop_back_to_back (p_date_start IN DATE) IS

Line 3459: FROM per_periods_of_placement pp

3455: AND pp.date_start = p_date_start;
3456: --
3457: CURSOR csr_pop_back_to_back (p_date_start IN DATE) IS
3458: SELECT pp.period_of_placement_id
3459: FROM per_periods_of_placement pp
3460: WHERE pp.person_id = p_person_id
3461: AND pp.actual_termination_date = p_date_start -1;
3462: --
3463: CURSOR csr_pos_back_to_back (p_date_start IN DATE) IS

Line 3473: FROM per_periods_of_placement pop

3469:
3470: -- Change for the bug 6460093 starts here
3471: CURSOR csr_pdped_start is
3472: SELECT pop.date_start
3473: FROM per_periods_of_placement pop
3474: WHERE pop.person_id = p_person_id
3475: AND p_effective_date between pop.date_start and
3476: nvl(pop.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'));
3477:

Line 3773: DELETE FROM per_periods_of_placement

3769: FETCH csr_periods_of_placement INTO l_rowid;
3770: --
3771: EXIT WHEN csr_periods_of_placement%NOTFOUND;
3772: --
3773: DELETE FROM per_periods_of_placement
3774: WHERE rowid = l_rowid;
3775: --
3776: IF SQL%NOTFOUND THEN
3777: --