APPS.PAY_CA_ARCHIVE dependencies on HR_ASSIGNMENT_SETS

Line 2080: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE; l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

2076: l_roe_comment varchar2(150);
2077: l_last_day_paid date;
2078: l_last_day_paid1 date;
2079: l_last_day_paid2 date;
2080: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE; l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
2081:
2082: CURSOR cur_asg_set_name IS
2083: SELECT
2084: assignment_set_name

Line 2086: hr_assignment_sets

2082: CURSOR cur_asg_set_name IS
2083: SELECT
2084: assignment_set_name
2085: FROM
2086: hr_assignment_sets
2087: WHERE assignment_set_id = l_assignment_set_id
2088: AND business_group_id = l_business_group_id;
2089:
2090: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;

Line 2090: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;

2086: hr_assignment_sets
2087: WHERE assignment_set_id = l_assignment_set_id
2088: AND business_group_id = l_business_group_id;
2089:
2090: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;
2091: l_first_day_worked date;
2092: l_final_pay_period_end_date date;
2093: l_final_pay_period_start_date date;
2094: l_roe_contact_person per_people_f.full_name%TYPE;

Line 3470: FROM hr_assignment_sets

3466: p_business_group_id in number) return NUMBER IS
3467: --
3468: cursor c_set_check is
3469: SELECT assignment_set_id
3470: FROM hr_assignment_sets
3471: WHERE UPPER(assignment_set_name) = UPPER(p_asg_set)
3472: AND business_group_id = p_business_group_id;
3473: --
3474: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

Line 3474: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

3470: FROM hr_assignment_sets
3471: WHERE UPPER(assignment_set_name) = UPPER(p_asg_set)
3472: AND business_group_id = p_business_group_id;
3473: --
3474: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3475: --
3476: begin
3477: --
3478: OPEN c_set_check;

Line 3500: SELECT hr_assignment_sets_s.nextval

3496:
3497: declare
3498:
3499: cursor c_sequence is
3500: SELECT hr_assignment_sets_s.nextval
3501: FROM dual;
3502:
3503: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3504:

Line 3503: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

3499: cursor c_sequence is
3500: SELECT hr_assignment_sets_s.nextval
3501: FROM dual;
3502:
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

Line 3558: hr_assignment_sets_pkg.insert_row(

3554: OPEN c_sequence;
3555: FETCH c_sequence into l_assignment_set_id;
3556: CLOSE c_sequence;
3557:
3558: hr_assignment_sets_pkg.insert_row(
3559: p_rowid => l_rowid,
3560: p_assignment_set_id => l_assignment_set_id,
3561: p_business_group_id => p_business_group_id,
3562: p_payroll_id => '',

Line 3588: FROM hr_assignment_sets

3584: declare
3585:
3586: CURSOR cur_asg_set_id IS
3587: SELECT assignment_set_id
3588: FROM hr_assignment_sets
3589: WHERE UPPER(assignment_set_name) = UPPER(p_assignment_set_name)
3590: AND business_group_id = p_business_group_id;
3591:
3592: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

Line 3592: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

3588: FROM hr_assignment_sets
3589: WHERE UPPER(assignment_set_name) = UPPER(p_assignment_set_name)
3590: AND business_group_id = p_business_group_id;
3591:
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

Line 3641: -- hr_assignment_sets.

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;
3644: FETCH cur_last_row
3645: INTO l_dummy;

Line 3654: DELETE FROM hr_assignment_sets

3650: to_char(cur_last_row%ROWCOUNT));
3651:
3652: CLOSE cur_last_row;
3653:
3654: DELETE FROM hr_assignment_sets
3655: where assignment_set_id = l_assignment_set_id;
3656:
3657: ELSE
3658: