APPS.PER_POD_SHD dependencies on PER_POSITION_DEFINITIONS

Line 66: from per_position_definitions ppd

62: select pod.position_definition_id
63: from per_positions pod
64: where name = p_name
65: and exists (select 'x'
66: from per_position_definitions ppd
67: where ppd.position_definition_id = pod.position_definition_id
68: and ppd.id_flex_num = l_id_flex_num
69: and ppd.enabled_flag = 'Y');
70:

Line 75: -- from per_position_definitions pod

71: -- the cursor pgsel selects the position_definition_id
72: --
73: -- cursor pgsel is
74: -- select pod.position_definition_id
75: -- from per_position_definitions pod
76: -- where pod.id_flex_num = l_id_flex_num
77: -- and pod.enabled_flag = 'Y'
78: -- and (pod.segment1 = p_segment1
79: -- or (pod.segment1 is null

Line 314: If (p_constraint_name = 'PER_POSITION_DEFINITIONS_PK') Then

310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: If (p_constraint_name = 'PER_POSITION_DEFINITIONS_PK') Then
315: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
316: hr_utility.raise_error;
317: Else
318: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 373: from per_position_definitions

369: segment27,
370: segment28,
371: segment29,
372: segment30
373: from per_position_definitions
374: where position_definition_id = p_position_definition_id;
375: --
376: l_proc varchar2(72) := g_package||'api_updating';
377: l_fct_ret boolean;