APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 382: per_all_assignments_f paf

378: end if;
379: select distinct legislation_code, paf.business_group_id
380: into l_leg_code, l_bg_id
381: from per_business_groups_perf pbg,
382: per_all_assignments_f paf
383: where paf.assignment_id = p_assignment_id
384: and p_effective_start_date between paf.effective_start_date
385: and paf.effective_end_date
386: and paf.business_group_id = pbg.business_group_id;

Line 1035: from per_all_assignments_f asg

1031: select pos.date_start
1032: ,pos.period_of_service_id
1033: into l_new_effective_start_date
1034: ,l_period_of_service_id
1035: from per_all_assignments_f asg
1036: ,per_periods_of_service pos
1037: where asg.assignment_id = p_assignment_id
1038: and asg.period_of_service_id = pos.period_of_service_id;
1039:

Line 1097: from per_all_assignments_f asg

1093: select pos.date_start
1094: ,pos.period_of_service_id
1095: into l_new_effective_start_date
1096: ,l_period_of_service_id
1097: from per_all_assignments_f asg
1098: ,per_periods_of_service pos
1099: where asg.assignment_id = p_assignment_id
1100: and asg.period_of_service_id = pos.period_of_service_id;
1101:

Line 1445: from per_all_assignments_f

1441: payroll_id,
1442: effective_start_date,
1443: effective_end_date,
1444: business_group_id
1445: from per_all_assignments_f
1446: where assignment_id = p_asg_id
1447: order by assignment_id, effective_start_date;
1448: --
1449: asg_id per_all_assignments_f.assignment_id%type;

Line 1449: asg_id per_all_assignments_f.assignment_id%type;

1445: from per_all_assignments_f
1446: where assignment_id = p_asg_id
1447: order by assignment_id, effective_start_date;
1448: --
1449: asg_id per_all_assignments_f.assignment_id%type;
1450: per_id per_all_assignments_f.person_id%type;
1451: pos_id per_all_assignments_f.period_of_service_id%type;
1452: pay_id per_all_assignments_f.payroll_id%type;
1453: effective_start_date date;

Line 1450: per_id per_all_assignments_f.person_id%type;

1446: where assignment_id = p_asg_id
1447: order by assignment_id, effective_start_date;
1448: --
1449: asg_id per_all_assignments_f.assignment_id%type;
1450: per_id per_all_assignments_f.person_id%type;
1451: pos_id per_all_assignments_f.period_of_service_id%type;
1452: pay_id per_all_assignments_f.payroll_id%type;
1453: effective_start_date date;
1454: effective_end_date date;

Line 1451: pos_id per_all_assignments_f.period_of_service_id%type;

1447: order by assignment_id, effective_start_date;
1448: --
1449: asg_id per_all_assignments_f.assignment_id%type;
1450: per_id per_all_assignments_f.person_id%type;
1451: pos_id per_all_assignments_f.period_of_service_id%type;
1452: pay_id per_all_assignments_f.payroll_id%type;
1453: effective_start_date date;
1454: effective_end_date date;
1455: first_row boolean;

Line 1452: pay_id per_all_assignments_f.payroll_id%type;

1448: --
1449: asg_id per_all_assignments_f.assignment_id%type;
1450: per_id per_all_assignments_f.person_id%type;
1451: pos_id per_all_assignments_f.period_of_service_id%type;
1452: pay_id per_all_assignments_f.payroll_id%type;
1453: effective_start_date date;
1454: effective_end_date date;
1455: first_row boolean;
1456: --