APPS.PAY_ASG_LINK_USAGES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 232: from per_all_assignments_f ASSIGNMENT,

228: statem := '
229: select assignment.assignment_id,
230: assignment.effective_start_date,
231: assignment.effective_end_date
232: from per_all_assignments_f ASSIGNMENT,
233: pay_people_groups ASSIGNMENT_GROUP
234: where assignment.assignment_type not in (''A'',''O'')
235: and assignment.business_group_id + 0 = :p_business_group_id
236: and assignment.effective_start_date <= :p_effective_end_date

Line 519: from per_all_assignments_f

515: select
516: people_group_id
517: ,effective_start_date
518: ,effective_end_date
519: from per_all_assignments_f
520: where assignment_id = p_assignment_id
521: and assignment_type not in ('A','O')
522: and people_group_id is not null
523: order by effective_start_date;

Line 737: from per_all_assignments_f

733: --
734: cursor csr_lock_asg
735: is
736: select 1
737: from per_all_assignments_f
738: where assignment_id = p_asg_id
739: and effective_start_date <= p_end_date
740: and effective_end_date >= p_start_date
741: for update nowait

Line 756: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

752: --
753: -- Failed to lock the assignment.
754: --
755: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
756: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
757: hr_utility.raise_error;
758: end lock_asg;
759: --
760: begin

Line 1049: from per_all_assignments_f asg,

1045: asg.effective_end_date,
1046: asg.business_group_id,
1047: asg.people_group_id,
1048: ppg.id_flex_num
1049: from per_all_assignments_f asg,
1050: pay_people_groups ppg
1051: where asg.assignment_id = p_assignment_id
1052: and asg.assignment_type not in ('A','O')
1053: and asg.people_group_id is not null