APPS.PAY_ASG_LINK_USAGES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 80: from per_all_assignments_f asg,

76: select greatest(asg.effective_start_date,el.effective_start_date) effective_start_date,
77: least(asg.effective_end_date, el.effective_end_date) effective_end_date,
78: asg.business_group_id,
79: el.element_link_id
80: from per_all_assignments_f asg,
81: pay_people_groups ppg,
82: pay_element_links_f el,
83: pay_people_groups el_pg
84: where el_pg.id_flex_num = ppg.id_flex_num

Line 386: from per_all_assignments_f ASSIGNMENT,

382: statem := '
383: select assignment.assignment_id,
384: assignment.effective_start_date,
385: assignment.effective_end_date
386: from per_all_assignments_f ASSIGNMENT,
387: pay_people_groups ASSIGNMENT_GROUP
388: where assignment.assignment_type not in (''A'',''O'')
389: and assignment.business_group_id + 0 = :p_business_group_id
390: and assignment.effective_start_date <= :p_effective_end_date

Line 698: from per_all_assignments_f

694: select
695: people_group_id
696: ,effective_start_date
697: ,effective_end_date
698: from per_all_assignments_f
699: where assignment_id = p_assignment_id
700: and assignment_type not in ('A','O')
701: and people_group_id is not null
702: order by effective_start_date;

Line 916: from per_all_assignments_f

912: --
913: cursor csr_lock_asg
914: is
915: select 1
916: from per_all_assignments_f
917: where assignment_id = p_asg_id
918: and effective_start_date <= p_end_date
919: and effective_end_date >= p_start_date
920: for update nowait

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

931: --
932: -- Failed to lock the assignment.
933: --
934: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
935: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
936: hr_utility.raise_error;
937: end lock_asg;
938: --
939: begin

Line 1237: from per_all_assignments_f asg,

1233: select greatest(asg.effective_start_date,el.effective_start_date) effective_start_date,
1234: least(asg.effective_end_date, el.effective_end_date) effective_end_date,
1235: asg.business_group_id,
1236: el.element_link_id
1237: from per_all_assignments_f asg,
1238: pay_people_groups ppg,
1239: pay_element_links_f el,
1240: pay_people_groups el_pg
1241: where el_pg.id_flex_num = ppg.id_flex_num