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 3043: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE

3039: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3040: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3041: p_item_type IN wf_items.item_type%TYPE
3042: ,p_item_key IN wf_items.item_key%TYPE
3043: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
3044: ,p_person_id IN per_all_people_f.person_id%TYPE
3045: )
3046: AS
3047: -- Local Variables

Line 3044: ,p_person_id IN per_all_people_f.person_id%TYPE

3040: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3041: p_item_type IN wf_items.item_type%TYPE
3042: ,p_item_key IN wf_items.item_key%TYPE
3043: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
3044: ,p_person_id IN per_all_people_f.person_id%TYPE
3045: )
3046: AS
3047: -- Local Variables
3048: lv_exist VARCHAR2(10) DEFAULT 'N';