APPS.BEN_UPDATE_LEDGERS dependencies on PER_ALL_ASSIGNMENTS_F

Line 214: from per_all_assignments_f asg

210: /*
211: cursor c_person (c_person_id in number,
212: c_effective_date in date) is
213: select distinct asg.payroll_id
214: from per_all_assignments_f asg
215: where asg.person_id = c_person_id
216: and asg.assignment_type <> 'C'
217: and asg.primary_flag = 'Y'
218: and c_effective_date between

Line 343: l_assignment_id per_all_assignments_f.assignment_id%type;

339: --
340: l_dfnd_dummy number;
341: l_ann_dummy number;
342: l_cmcd_dummy number;
343: l_assignment_id per_all_assignments_f.assignment_id%type;
344: l_payroll_id per_all_assignments_f.payroll_id%type;
345: l_organization_id per_all_assignments_f.organization_id%type;
346: --END GEVITY
347: begin

Line 344: l_payroll_id per_all_assignments_f.payroll_id%type;

340: l_dfnd_dummy number;
341: l_ann_dummy number;
342: l_cmcd_dummy number;
343: l_assignment_id per_all_assignments_f.assignment_id%type;
344: l_payroll_id per_all_assignments_f.payroll_id%type;
345: l_organization_id per_all_assignments_f.organization_id%type;
346: --END GEVITY
347: begin
348: hr_utility.set_location('Entering '||l_proc, 10);

Line 345: l_organization_id per_all_assignments_f.organization_id%type;

341: l_ann_dummy number;
342: l_cmcd_dummy number;
343: l_assignment_id per_all_assignments_f.assignment_id%type;
344: l_payroll_id per_all_assignments_f.payroll_id%type;
345: l_organization_id per_all_assignments_f.organization_id%type;
346: --END GEVITY
347: begin
348: hr_utility.set_location('Entering '||l_proc, 10);
349: -- init all the out parms