APPS.PAY_AU_DLEC dependencies on PER_ALL_ASSIGNMENTS_F

Line 34: c_business_group_id per_all_assignments_f.business_group_id%type,

30: -- we want to check all date-tracked changes for the assignment.
31:
32: cursor c_select_assignments
33: (
34: c_business_group_id per_all_assignments_f.business_group_id%type,
35: c_start_date per_all_assignments_f.effective_start_date%type,
36: c_end_date per_all_assignments_f.effective_end_date%type
37: )
38: is

Line 35: c_start_date per_all_assignments_f.effective_start_date%type,

31:
32: cursor c_select_assignments
33: (
34: c_business_group_id per_all_assignments_f.business_group_id%type,
35: c_start_date per_all_assignments_f.effective_start_date%type,
36: c_end_date per_all_assignments_f.effective_end_date%type
37: )
38: is
39: select asg.assignment_id,

Line 36: c_end_date per_all_assignments_f.effective_end_date%type

32: cursor c_select_assignments
33: (
34: c_business_group_id per_all_assignments_f.business_group_id%type,
35: c_start_date per_all_assignments_f.effective_start_date%type,
36: c_end_date per_all_assignments_f.effective_end_date%type
37: )
38: is
39: select asg.assignment_id,
40: asg.assignment_number,

Line 45: from per_all_assignments_f asg

41: asg.effective_start_date,
42: asg.effective_end_date,
43: asg.person_id,
44: scl.segment1
45: from per_all_assignments_f asg
46: ,hr_soft_coding_keyflex scl
47: where scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
48: and asg.business_group_id = c_business_group_id
49: and asg.effective_start_date <= c_end_date

Line 65: (assignment_id per_all_assignments_f.assignment_id%type,

61: l_today date;
62: l_business_group_name hr_all_organization_units.name%type;
63:
64: type l_asg_rec is record
65: (assignment_id per_all_assignments_f.assignment_id%type,
66: assignment_number per_all_assignments_f.assignment_number%type,
67: effective_start_date per_all_assignments_f.effective_start_date%type,
68: effective_end_date per_all_assignments_f.effective_end_date%type,
69: segment1 hr_soft_coding_keyflex.segment1%type,

Line 66: assignment_number per_all_assignments_f.assignment_number%type,

62: l_business_group_name hr_all_organization_units.name%type;
63:
64: type l_asg_rec is record
65: (assignment_id per_all_assignments_f.assignment_id%type,
66: assignment_number per_all_assignments_f.assignment_number%type,
67: effective_start_date per_all_assignments_f.effective_start_date%type,
68: effective_end_date per_all_assignments_f.effective_end_date%type,
69: segment1 hr_soft_coding_keyflex.segment1%type,
70: prev_segment1 hr_soft_coding_keyflex.segment1%type,

Line 67: effective_start_date per_all_assignments_f.effective_start_date%type,

63:
64: type l_asg_rec is record
65: (assignment_id per_all_assignments_f.assignment_id%type,
66: assignment_number per_all_assignments_f.assignment_number%type,
67: effective_start_date per_all_assignments_f.effective_start_date%type,
68: effective_end_date per_all_assignments_f.effective_end_date%type,
69: segment1 hr_soft_coding_keyflex.segment1%type,
70: prev_segment1 hr_soft_coding_keyflex.segment1%type,
71: seg1_name hr_organization_units.name%type,

Line 68: effective_end_date per_all_assignments_f.effective_end_date%type,

64: type l_asg_rec is record
65: (assignment_id per_all_assignments_f.assignment_id%type,
66: assignment_number per_all_assignments_f.assignment_number%type,
67: effective_start_date per_all_assignments_f.effective_start_date%type,
68: effective_end_date per_all_assignments_f.effective_end_date%type,
69: segment1 hr_soft_coding_keyflex.segment1%type,
70: prev_segment1 hr_soft_coding_keyflex.segment1%type,
71: seg1_name hr_organization_units.name%type,
72: seg1_prev_name hr_organization_units.name%type,

Line 73: person_id per_all_assignments_f.person_id%type,

69: segment1 hr_soft_coding_keyflex.segment1%type,
70: prev_segment1 hr_soft_coding_keyflex.segment1%type,
71: seg1_name hr_organization_units.name%type,
72: seg1_prev_name hr_organization_units.name%type,
73: person_id per_all_assignments_f.person_id%type,
74: full_name per_all_people_f.full_name%type
75: );
76:
77: type l_asg_table_def is table of l_asg_rec