DBA Data[Home] [Help]

APPS.PAY_FR_MIGRATE_TIME_ANALYSIS dependencies on PER_ALL_ASSIGNMENTS_F

Line 9: From per_all_assignments_f asg

5: p_business_group_id IN NUMBER) Is
6:
7: Cursor csr_get_all_asg IS
8: Select distinct asg.assignment_id
9: From per_all_assignments_f asg
10: Where asg.business_group_id = p_business_group_id
11: order by asg.assignment_id;
12:
13: Cursor csr_get_asg_datetrk(c_assignment_id number)IS

Line 21: From per_all_assignments_f asg

17: ,asg.frequency
18: ,scl.segment15 work_days
19: ,asg.person_id
20: ,full_name
21: From per_all_assignments_f asg
22: ,hr_soft_coding_keyflex scl
23: ,per_all_people_f per
24: Where asg.business_group_id = p_business_group_id
25: and asg.assignment_id = c_assignment_id