APPS.PAY_CA_ARCHIVE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 272: hr_assignment_set_amendments hasa,

268:
269: str := 'select
270: distinct paf.person_id
271: from
272: hr_assignment_set_amendments hasa,
273: per_assignments_f paf,
274: pay_payroll_actions ppa
275: WHERE
276: hasa.assignment_set_id =

Line 884: hr_assignment_set_amendments hasa,

880: cursor cur_asg_set_person_id is
881: select
882: distinct paf.person_id person_id
883: from
884: hr_assignment_set_amendments hasa,
885: per_assignments_f paf
886: WHERE
887: hasa.assignment_set_id = l_assignment_set_id and
888: hasa.include_or_exclude = 'I' and

Line 3507: FROM hr_assignment_set_amendments

3503: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3504:
3505: CURSOR c_already_in_set is
3506: SELECT 'X'
3507: FROM hr_assignment_set_amendments
3508: WHERE assignment_id = p_assignment_id
3509: AND assignment_set_id = l_assignment_set_id
3510: AND include_or_exclude = 'I';
3511:

Line 3596: FROM hr_assignment_set_amendments

3592: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3593:
3594: CURSOR c_already_in_set IS
3595: SELECT 'X'
3596: FROM hr_assignment_set_amendments
3597: WHERE assignment_id = p_assignment_id
3598: AND assignment_set_id = l_assignment_set_id
3599: AND include_or_exclude = 'I';
3600:

Line 3603: FROM hr_assignment_set_amendments

3599: AND include_or_exclude = 'I';
3600:
3601: CURSOR cur_last_row IS
3602: SELECT 'X'
3603: FROM hr_assignment_set_amendments
3604: WHERE assignment_set_id = l_assignment_set_id;
3605:
3606: --
3607: l_dummy VARCHAR2(1);

Line 3634: hr_assignment_set_amendments

3630: hr_utility.trace(' In delete_asg_set_records, c_already_in_set found !');
3631: CLOSE c_already_in_set;
3632:
3633: DELETE FROM
3634: hr_assignment_set_amendments
3635: WHERE
3636: assignment_set_id = l_assignment_set_id and
3637: assignment_id = p_assignment_id;
3638:

Line 3639: -- If this is the last row in hr_assignment_set_amendments

3635: WHERE
3636: assignment_set_id = l_assignment_set_id and
3637: assignment_id = p_assignment_id;
3638:
3639: -- If this is the last row in hr_assignment_set_amendments
3640: -- then we need to delete the assignment set as well from
3641: -- hr_assignment_sets.
3642:
3643: OPEN cur_last_row;