APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 323: per_all_assignments_f paf

319: --
320: select distinct legislation_code
321: into l_leg_code
322: from per_business_groups_perf pbg,
323: per_all_assignments_f paf
324: where paf.assignment_id = p_assignment_id
325: and p_effective_start_date between paf.effective_start_date
326: and paf.effective_end_date
327: and paf.business_group_id = pbg.business_group_id;

Line 1007: from per_all_assignments_f

1003: payroll_id,
1004: effective_start_date,
1005: effective_end_date,
1006: business_group_id
1007: from per_all_assignments_f
1008: where assignment_id = p_asg_id
1009: order by assignment_id, effective_start_date;
1010: --
1011: asg_id per_all_assignments_f.assignment_id%type;

Line 1011: asg_id per_all_assignments_f.assignment_id%type;

1007: from per_all_assignments_f
1008: where assignment_id = p_asg_id
1009: order by assignment_id, effective_start_date;
1010: --
1011: asg_id per_all_assignments_f.assignment_id%type;
1012: per_id per_all_assignments_f.person_id%type;
1013: pos_id per_all_assignments_f.period_of_service_id%type;
1014: pay_id per_all_assignments_f.payroll_id%type;
1015: effective_start_date date;

Line 1012: per_id per_all_assignments_f.person_id%type;

1008: where assignment_id = p_asg_id
1009: order by assignment_id, effective_start_date;
1010: --
1011: asg_id per_all_assignments_f.assignment_id%type;
1012: per_id per_all_assignments_f.person_id%type;
1013: pos_id per_all_assignments_f.period_of_service_id%type;
1014: pay_id per_all_assignments_f.payroll_id%type;
1015: effective_start_date date;
1016: effective_end_date date;

Line 1013: pos_id per_all_assignments_f.period_of_service_id%type;

1009: order by assignment_id, effective_start_date;
1010: --
1011: asg_id per_all_assignments_f.assignment_id%type;
1012: per_id per_all_assignments_f.person_id%type;
1013: pos_id per_all_assignments_f.period_of_service_id%type;
1014: pay_id per_all_assignments_f.payroll_id%type;
1015: effective_start_date date;
1016: effective_end_date date;
1017: first_row boolean;

Line 1014: pay_id per_all_assignments_f.payroll_id%type;

1010: --
1011: asg_id per_all_assignments_f.assignment_id%type;
1012: per_id per_all_assignments_f.person_id%type;
1013: pos_id per_all_assignments_f.period_of_service_id%type;
1014: pay_id per_all_assignments_f.payroll_id%type;
1015: effective_start_date date;
1016: effective_end_date date;
1017: first_row boolean;
1018: --