APPS.HR_SECURITY_INTERNAL dependencies on PER_ASSIGNMENTS_F

Line 2873: l_person_id per_assignments_f.person_id%TYPE;

2869: from per_applications ap
2870: where ap.person_id = p_person_id)
2871: ) );
2872: --
2873: l_person_id per_assignments_f.person_id%TYPE;
2874: l_organization_id per_assignments_f.organization_id%TYPE;
2875: l_position_id per_assignments_f.position_id%TYPE;
2876: l_payroll_id per_assignments_f.payroll_id%TYPE;
2877: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 2874: l_organization_id per_assignments_f.organization_id%TYPE;

2870: where ap.person_id = p_person_id)
2871: ) );
2872: --
2873: l_person_id per_assignments_f.person_id%TYPE;
2874: l_organization_id per_assignments_f.organization_id%TYPE;
2875: l_position_id per_assignments_f.position_id%TYPE;
2876: l_payroll_id per_assignments_f.payroll_id%TYPE;
2877: l_business_group_id per_assignments_f.business_group_id%TYPE;
2878: --

Line 2875: l_position_id per_assignments_f.position_id%TYPE;

2871: ) );
2872: --
2873: l_person_id per_assignments_f.person_id%TYPE;
2874: l_organization_id per_assignments_f.organization_id%TYPE;
2875: l_position_id per_assignments_f.position_id%TYPE;
2876: l_payroll_id per_assignments_f.payroll_id%TYPE;
2877: l_business_group_id per_assignments_f.business_group_id%TYPE;
2878: --
2879: begin

Line 2876: l_payroll_id per_assignments_f.payroll_id%TYPE;

2872: --
2873: l_person_id per_assignments_f.person_id%TYPE;
2874: l_organization_id per_assignments_f.organization_id%TYPE;
2875: l_position_id per_assignments_f.position_id%TYPE;
2876: l_payroll_id per_assignments_f.payroll_id%TYPE;
2877: l_business_group_id per_assignments_f.business_group_id%TYPE;
2878: --
2879: begin
2880: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2877: l_business_group_id per_assignments_f.business_group_id%TYPE;

2873: l_person_id per_assignments_f.person_id%TYPE;
2874: l_organization_id per_assignments_f.organization_id%TYPE;
2875: l_position_id per_assignments_f.position_id%TYPE;
2876: l_payroll_id per_assignments_f.payroll_id%TYPE;
2877: l_business_group_id per_assignments_f.business_group_id%TYPE;
2878: --
2879: begin
2880: hr_utility.set_location('Entering:'|| l_proc, 10);
2881: --