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 3391: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

3387: l_message_text VARCHAR2(255);
3388: l_dummy_b BOOLEAN;
3389: l_dummy_n NUMBER := null;
3390: l_dummy_v VARCHAR2(4000);
3391: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3392: --
3393: l_object_version_number NUMBER := p_object_version_number ;
3394: l_organization_id NUMBER := p_organization_id ;
3395: l_special_ceiling_step_id NUMBER := p_special_ceiling_step_id ;