APPS.PER_JBD_SHD dependencies on PER_JOB_DEFINITIONS

Line 60: from per_job_definitions jbd

56: -- the cursor pgsel selects the job_definition_id
57: --
58: cursor pgsel is
59: select jbd.job_definition_id
60: from per_job_definitions jbd
61: where jbd.id_flex_num = l_id_flex_num
62: and jbd.enabled_flag = 'Y'
63: and (jbd.segment1 = p_segment1
64: or (jbd.segment1 is null

Line 315: If (p_constraint_name = 'PER_JOB_DEFINITIONS_PK') Then

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

Line 371: from per_job_definitions

367: segment27,
368: segment28,
369: segment29,
370: segment30
371: from per_job_definitions
372: where job_definition_id = p_job_definition_id;
373: --
374: l_proc varchar2(72) := g_package||'api_updating';
375: l_fct_ret boolean;