DBA Data[Home] [Help]

APPS.HR_MX_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 326: p_assignment_id per_all_assignments_f.assignment_id%TYPE)

322: -- --
323: --------------------------------------------------------------------------
324:
325: FUNCTION GET_BG_FROM_ASSIGNMENT (
326: p_assignment_id per_all_assignments_f.assignment_id%TYPE)
327: RETURN per_all_assignments_f.business_group_id%TYPE AS
328:
329: CURSOR csr_fetch_bg IS
330: SELECT business_group_id

Line 327: RETURN per_all_assignments_f.business_group_id%TYPE AS

323: --------------------------------------------------------------------------
324:
325: FUNCTION GET_BG_FROM_ASSIGNMENT (
326: p_assignment_id per_all_assignments_f.assignment_id%TYPE)
327: RETURN per_all_assignments_f.business_group_id%TYPE AS
328:
329: CURSOR csr_fetch_bg IS
330: SELECT business_group_id
331: FROM per_assignments_f

Line 335: l_bg_id per_all_assignments_f.business_group_id%TYPE;

331: FROM per_assignments_f
332: WHERE assignment_id = p_assignment_id
333: AND rownum < 2;
334:
335: l_bg_id per_all_assignments_f.business_group_id%TYPE;
336:
337: BEGIN
338: OPEN csr_fetch_bg;
339: FETCH csr_fetch_bg INTO l_bg_id;