APPS.PAY_CA_ARCHIVE dependencies on HR_ASSIGNMENT_SETS

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

2072: l_roe_comment varchar2(150);
2073: l_last_day_paid date;
2074: l_last_day_paid1 date;
2075: l_last_day_paid2 date;
2076: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE; l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
2077:
2078: CURSOR cur_asg_set_name IS
2079: SELECT
2080: assignment_set_name

Line 2082: hr_assignment_sets

2078: CURSOR cur_asg_set_name IS
2079: SELECT
2080: assignment_set_name
2081: FROM
2082: hr_assignment_sets
2083: WHERE assignment_set_id = l_assignment_set_id
2084: AND business_group_id = l_business_group_id;
2085:
2086: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;

Line 2086: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;

2082: hr_assignment_sets
2083: WHERE assignment_set_id = l_assignment_set_id
2084: AND business_group_id = l_business_group_id;
2085:
2086: l_asg_set_name hr_assignment_sets.assignment_set_name%TYPE;
2087: l_first_day_worked date;
2088: l_final_pay_period_end_date date;
2089: l_final_pay_period_start_date date;
2090: l_roe_contact_person per_people_f.full_name%TYPE;

Line 3449: FROM hr_assignment_sets

3445: p_business_group_id in number) return NUMBER IS
3446: --
3447: cursor c_set_check is
3448: SELECT assignment_set_id
3449: FROM hr_assignment_sets
3450: WHERE UPPER(assignment_set_name) = UPPER(p_asg_set)
3451: AND business_group_id = p_business_group_id;
3452: --
3453: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

Line 3453: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

3449: FROM hr_assignment_sets
3450: WHERE UPPER(assignment_set_name) = UPPER(p_asg_set)
3451: AND business_group_id = p_business_group_id;
3452: --
3453: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3454: --
3455: begin
3456: --
3457: OPEN c_set_check;

Line 3479: SELECT hr_assignment_sets_s.nextval

3475:
3476: declare
3477:
3478: cursor c_sequence is
3479: SELECT hr_assignment_sets_s.nextval
3480: FROM dual;
3481:
3482: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
3483:

Line 3482: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

3478: cursor c_sequence is
3479: SELECT hr_assignment_sets_s.nextval
3480: FROM dual;
3481:
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

Line 3537: hr_assignment_sets_pkg.insert_row(

3533: OPEN c_sequence;
3534: FETCH c_sequence into l_assignment_set_id;
3535: CLOSE c_sequence;
3536:
3537: hr_assignment_sets_pkg.insert_row(
3538: p_rowid => l_rowid,
3539: p_assignment_set_id => l_assignment_set_id,
3540: p_business_group_id => p_business_group_id,
3541: p_payroll_id => '',

Line 3567: FROM hr_assignment_sets

3563: declare
3564:
3565: CURSOR cur_asg_set_id IS
3566: SELECT assignment_set_id
3567: FROM hr_assignment_sets
3568: WHERE UPPER(assignment_set_name) = UPPER(p_assignment_set_name)
3569: AND business_group_id = p_business_group_id;
3570:
3571: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

Line 3571: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

3567: FROM hr_assignment_sets
3568: WHERE UPPER(assignment_set_name) = UPPER(p_assignment_set_name)
3569: AND business_group_id = p_business_group_id;
3570:
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

Line 3620: -- hr_assignment_sets.

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;
3623: FETCH cur_last_row
3624: INTO l_dummy;

Line 3633: DELETE FROM hr_assignment_sets

3629: to_char(cur_last_row%ROWCOUNT));
3630:
3631: CLOSE cur_last_row;
3632:
3633: DELETE FROM hr_assignment_sets
3634: where assignment_set_id = l_assignment_set_id;
3635:
3636: ELSE
3637: