APPS.PAY_CA_ARCHIVE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 268: hr_assignment_set_amendments hasa,

264:
265: str := 'select
266: distinct paf.person_id
267: from
268: hr_assignment_set_amendments hasa,
269: per_assignments_f paf,
270: pay_payroll_actions ppa
271: WHERE
272: hasa.assignment_set_id =

Line 880: hr_assignment_set_amendments hasa,

876: cursor cur_asg_set_person_id is
877: select
878: distinct paf.person_id person_id
879: from
880: hr_assignment_set_amendments hasa,
881: per_assignments_f paf
882: WHERE
883: hasa.assignment_set_id = l_assignment_set_id and
884: hasa.include_or_exclude = 'I' and

Line 3486: FROM hr_assignment_set_amendments

3482: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3483:
3484: CURSOR c_already_in_set is
3485: SELECT 'X'
3486: FROM hr_assignment_set_amendments
3487: WHERE assignment_id = p_assignment_id
3488: AND assignment_set_id = l_assignment_set_id
3489: AND include_or_exclude = 'I';
3490:

Line 3575: FROM hr_assignment_set_amendments

3571: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3572:
3573: CURSOR c_already_in_set IS
3574: SELECT 'X'
3575: FROM hr_assignment_set_amendments
3576: WHERE assignment_id = p_assignment_id
3577: AND assignment_set_id = l_assignment_set_id
3578: AND include_or_exclude = 'I';
3579:

Line 3582: FROM hr_assignment_set_amendments

3578: AND include_or_exclude = 'I';
3579:
3580: CURSOR cur_last_row IS
3581: SELECT 'X'
3582: FROM hr_assignment_set_amendments
3583: WHERE assignment_set_id = l_assignment_set_id;
3584:
3585: --
3586: l_dummy VARCHAR2(1);

Line 3613: hr_assignment_set_amendments

3609: hr_utility.trace(' In delete_asg_set_records, c_already_in_set found !');
3610: CLOSE c_already_in_set;
3611:
3612: DELETE FROM
3613: hr_assignment_set_amendments
3614: WHERE
3615: assignment_set_id = l_assignment_set_id and
3616: assignment_id = p_assignment_id;
3617:

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

3614: WHERE
3615: assignment_set_id = l_assignment_set_id and
3616: assignment_id = p_assignment_id;
3617:
3618: -- If this is the last row in hr_assignment_set_amendments
3619: -- then we need to delete the assignment set as well from
3620: -- hr_assignment_sets.
3621:
3622: OPEN cur_last_row;