APPS.BEN_ENROLLMENT_RATE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1218: per_all_assignments_f ass

1214: p_effective_date date ) is
1215: select
1216: payroll_id
1217: from
1218: per_all_assignments_f ass
1219: where
1220: ass.person_id = p_person_id
1221: and p_effective_date between ass.effective_start_date and ass.effective_end_date
1222: and primary_flag = 'Y'

Line 1239: l_assignment_id per_all_assignments_f.assignment_id%type;

1235: --
1236: l_dfnd_dummy number;
1237: l_ann_dummy number;
1238: l_cmcd_dummy number;
1239: l_assignment_id per_all_assignments_f.assignment_id%type;
1240: l_payroll_id per_all_assignments_f.payroll_id%type;
1241: l_organization_id per_all_assignments_f.organization_id%type;
1242: --END GEVITY
1243: begin

Line 1240: l_payroll_id per_all_assignments_f.payroll_id%type;

1236: l_dfnd_dummy number;
1237: l_ann_dummy number;
1238: l_cmcd_dummy number;
1239: l_assignment_id per_all_assignments_f.assignment_id%type;
1240: l_payroll_id per_all_assignments_f.payroll_id%type;
1241: l_organization_id per_all_assignments_f.organization_id%type;
1242: --END GEVITY
1243: begin
1244: --

Line 1241: l_organization_id per_all_assignments_f.organization_id%type;

1237: l_ann_dummy number;
1238: l_cmcd_dummy number;
1239: l_assignment_id per_all_assignments_f.assignment_id%type;
1240: l_payroll_id per_all_assignments_f.payroll_id%type;
1241: l_organization_id per_all_assignments_f.organization_id%type;
1242: --END GEVITY
1243: begin
1244: --
1245: /*