APPS.IGI_ITR_PREP_APPRV_PKG dependencies on FND_USER

Line 72: ,p_preparer_fnd_user_id NUMBER

68: -- returns a value of 'Y' or 'N'
69: --
70: PROCEDURE can_preparer_approve(p_cc_id NUMBER
71: ,p_cc_line_num NUMBER
72: ,p_preparer_fnd_user_id NUMBER
73: ,p_sob_id NUMBER
74: ,p_prep_can_approve OUT NOCOPY VARCHAR2
75: )
76: IS

Line 98: FROM fnd_user

94:
95: -- get employee id of the preparer
96: SELECT employee_id
97: INTO l_preparer_id
98: FROM fnd_user
99: WHERE user_id = p_preparer_fnd_user_id;
100:
101: diagn_msg(l_state_level,'can_preparer_approve','l_preparer_id ='||l_preparer_id);
102:

Line 99: WHERE user_id = p_preparer_fnd_user_id;

95: -- get employee id of the preparer
96: SELECT employee_id
97: INTO l_preparer_id
98: FROM fnd_user
99: WHERE user_id = p_preparer_fnd_user_id;
100:
101: diagn_msg(l_state_level,'can_preparer_approve','l_preparer_id ='||l_preparer_id);
102:
103: