APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on PER_ALL_PEOPLE_F

Line 84: FROM per_all_people_f

80: -- curosr for Person_id
81: CURSOR lc_approver ( p_full_name VARCHAR2)
82: IS
83: SELECT person_id
84: FROM per_all_people_f
85: WHERE full_name = p_full_name ;
86:
87: -- assignment id for the approver
88: CURSOR gc_assignment_id (p_person_id IN per_people_f.person_id%TYPE,

Line 94: per_all_people_f peo

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
98: AND p_effective_date BETWEEN paf.effective_start_date

Line 2973: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE

2969: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2970: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2971: p_item_type IN wf_items.item_type%TYPE
2972: ,p_item_key IN wf_items.item_key%TYPE
2973: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
2974: ,p_person_id IN per_all_people_f.person_id%TYPE
2975: )
2976: AS
2977: -- Local Variables

Line 2974: ,p_person_id IN per_all_people_f.person_id%TYPE

2970: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2971: p_item_type IN wf_items.item_type%TYPE
2972: ,p_item_key IN wf_items.item_key%TYPE
2973: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
2974: ,p_person_id IN per_all_people_f.person_id%TYPE
2975: )
2976: AS
2977: -- Local Variables
2978: lv_exist VARCHAR2(10) DEFAULT 'N';