APPS.HR_SECURITY_INTERNAL dependencies on PER_ASSIGNMENTS_F

Line 2833: l_person_id per_assignments_f.person_id%TYPE;

2829: from per_applications ap
2830: where ap.person_id = p_person_id)
2831: ) );
2832: --
2833: l_person_id per_assignments_f.person_id%TYPE;
2834: l_organization_id per_assignments_f.organization_id%TYPE;
2835: l_position_id per_assignments_f.position_id%TYPE;
2836: l_payroll_id per_assignments_f.payroll_id%TYPE;
2837: l_business_group_id per_assignments_f.business_group_id%TYPE;

Line 2834: l_organization_id per_assignments_f.organization_id%TYPE;

2830: where ap.person_id = p_person_id)
2831: ) );
2832: --
2833: l_person_id per_assignments_f.person_id%TYPE;
2834: l_organization_id per_assignments_f.organization_id%TYPE;
2835: l_position_id per_assignments_f.position_id%TYPE;
2836: l_payroll_id per_assignments_f.payroll_id%TYPE;
2837: l_business_group_id per_assignments_f.business_group_id%TYPE;
2838: --

Line 2835: l_position_id per_assignments_f.position_id%TYPE;

2831: ) );
2832: --
2833: l_person_id per_assignments_f.person_id%TYPE;
2834: l_organization_id per_assignments_f.organization_id%TYPE;
2835: l_position_id per_assignments_f.position_id%TYPE;
2836: l_payroll_id per_assignments_f.payroll_id%TYPE;
2837: l_business_group_id per_assignments_f.business_group_id%TYPE;
2838: --
2839: begin

Line 2836: l_payroll_id per_assignments_f.payroll_id%TYPE;

2832: --
2833: l_person_id per_assignments_f.person_id%TYPE;
2834: l_organization_id per_assignments_f.organization_id%TYPE;
2835: l_position_id per_assignments_f.position_id%TYPE;
2836: l_payroll_id per_assignments_f.payroll_id%TYPE;
2837: l_business_group_id per_assignments_f.business_group_id%TYPE;
2838: --
2839: begin
2840: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2837: l_business_group_id per_assignments_f.business_group_id%TYPE;

2833: l_person_id per_assignments_f.person_id%TYPE;
2834: l_organization_id per_assignments_f.organization_id%TYPE;
2835: l_position_id per_assignments_f.position_id%TYPE;
2836: l_payroll_id per_assignments_f.payroll_id%TYPE;
2837: l_business_group_id per_assignments_f.business_group_id%TYPE;
2838: --
2839: begin
2840: hr_utility.set_location('Entering:'|| l_proc, 10);
2841: --