APPS.PQH_ASG_WRAPPER dependencies on PER_ALL_ASSIGNMENTS_F

Line 1596: from per_all_assignments_f

1592: and hoi_estab.org_information2= 'Y';
1593: ---
1594: cursor csr_get_org is
1595: select organization_id
1596: from per_all_assignments_f
1597: where assignment_id = p_assignment_id
1598: and p_effective_date between effective_start_date and effective_end_date;
1599: ---
1600: v_log_message VARCHAR2(255);

Line 3449: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

3445: l_message_text VARCHAR2(255);
3446: l_dummy_b BOOLEAN;
3447: l_dummy_n NUMBER := null;
3448: l_dummy_v VARCHAR2(4000);
3449: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3450: --
3451: l_object_version_number NUMBER := p_object_version_number ;
3452: l_organization_id NUMBER := p_organization_id ;
3453: l_special_ceiling_step_id NUMBER := p_special_ceiling_step_id ;