APPS.PAY_AU_DLEC dependencies on HR_SOFT_CODING_KEYFLEX

Line 46: ,hr_soft_coding_keyflex scl

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
50: and asg.effective_end_date >= c_start_date

Line 69: segment1 hr_soft_coding_keyflex.segment1%type,

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,
73: person_id per_all_assignments_f.person_id%type,

Line 70: prev_segment1 hr_soft_coding_keyflex.segment1%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,
73: person_id per_all_assignments_f.person_id%type,
74: full_name per_all_people_f.full_name%type