APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on PER_ALL_ASSIGNMENTS_F

Line 24: gn_assignment_id per_all_assignments_f.assignment_id%TYPE;

20: gv_form_name CONSTANT VARCHAR2(100) DEFAULT 'approvalsForm';
21: gv_tip_test_mode BOOLEAN DEFAULT FALSE;
22: gv_user_date_format VARCHAR2(2000);
23: gn_person_id per_people_f.person_id%TYPE;
24: gn_assignment_id per_all_assignments_f.assignment_id%TYPE;
25: gv_error_table hr_dynamic_approval_web.t_person_table;
26: grt_wf_attributes_rec hr_dynamic_approval_web.grt_wf_attributes;
27:
28: gv_current_row NUMBER DEFAULT 1;

Line 93: per_all_assignments_f paf,

89: p_effective_date IN DATE
90: ) IS
91: SELECT paf.assignment_id
92: FROM
93: per_all_assignments_f paf,
94: per_all_people_f peo
95: WHERE
96: peo.person_id = paf.person_id
97: AND peo.person_id = p_person_id