APPS.HR_ENTRY dependencies on PER_ALL_ASSIGNMENTS_F

Line 363: per_all_assignments_f a

359: 'Y', add_months(p.date_start,(12 * l_qualifying_los)),
360: 'W', p.date_start + (l_qualifying_los * 7),
361: add_months(p.date_start,l_qualifying_los))
362: from per_periods_of_service p,
363: per_all_assignments_f a
364: where a.assignment_id = p_assignment_id
365: and p.period_of_service_id = a.period_of_service_id;
366: --
367: cursor csr_age_date is

Line 1177: from per_all_assignments_f

1173: select ser.*
1174: into l_service_rec
1175: from per_periods_of_service ser
1176: where ser.person_id = (select distinct person_id
1177: from per_all_assignments_f
1178: where assignment_id = p_assignment_id)
1179: and (c1rec.effective_start_date - 1) between ser.date_start
1180: and nvl(ser.actual_termination_date, hr_general.end_of_time);
1181:

Line 1594: from per_all_assignments_f asg,

1590: -- rule date occurs...
1591: --
1592: select ptp.end_date
1593: into v_element_term_rule_date
1594: from per_all_assignments_f asg,
1595: per_time_periods ptp
1596: where asg.assignment_id = p_assignment_id
1597: and p_session_date between asg.effective_start_date and asg.effective_end_date
1598: and asg.payroll_id = ptp.payroll_id

Line 1852: per_all_assignments_f asg

1848: max(pay.effective_end_date)
1849: into v_payroll_start_date,
1850: v_payroll_end_date
1851: from pay_all_payrolls_f pay,
1852: per_all_assignments_f asg
1853: where p_session_date
1854: between asg.effective_start_date
1855: and asg.effective_end_date
1856: and asg.assignment_id = p_assignment_id

Line 3162: from per_all_assignments_f asg

3158: -- Need assignment type for comparison purposes
3159: --
3160: select asg.assignment_type, asg.assignment_number
3161: into v_assignment_type, v_assignment_number
3162: from per_all_assignments_f asg
3163: where asg.assignment_id = p_assignment_id
3164: and p_session_date between asg.effective_start_date
3165: and asg.effective_end_date;
3166: --

Line 3414: ,p_parent_table_name1 => 'per_all_assignments_f'

3410: ,p_datetrack_mode => 'INSERT' --*
3411: ,p_base_table_name => 'pay_element_entries_f'
3412: ,p_base_key_column => 'element_entry_id'
3413: ,p_base_key_value => p_element_entry_id --*
3414: ,p_parent_table_name1 => 'per_all_assignments_f'
3415: ,p_parent_key_column1 => 'assignment_id'
3416: ,p_parent_key_value1 => p_assignment_id
3417: ,p_enforce_foreign_locking => true
3418: ,p_validation_start_date => l_validation_start_date