APPS.HR_PERSON_TYPE_USAGE_API dependencies on PER_PERSON_TYPES

Line 283: l_temp_type per_person_types.system_person_type%type;

279: -- Declare cursors and local variables
280: --
281: l_proc varchar2(72) := g_package||'check_per_type_on_specific_day';
282: l_result varchar2(4);
283: l_temp_type per_person_types.system_person_type%type;
284: l_temp_id number;
285: --
286: cursor check_person_type is
287: select system_person_type

Line 288: from per_person_types ppt

284: l_temp_id number;
285: --
286: cursor check_person_type is
287: select system_person_type
288: from per_person_types ppt
289: where p_person_type = system_person_type;
290: --
291: cursor check_person_id is
292: select person_id

Line 298: from per_person_types ppt,

294: where person_id = p_person_id;
295: --
296: cursor current_person_type is
297: select 'Y'
298: from per_person_types ppt,
299: per_person_type_usages_f ptu
300: where ptu.person_id = p_person_id
301: and ptu.effective_start_date <= p_effective_date
302: and ptu.effective_end_date >= p_effective_date

Line 377: from per_person_types ppt

373: -- Declare cursors and local variables
374: --
375: cursor check_person_type is
376: select system_person_type
377: from per_person_types ppt
378: where p_person_type = system_person_type;
379: --
380: cursor check_person_id is
381: select person_id

Line 387: from per_person_types ppt,

383: where person_id = p_person_id;
384: --
385: cursor check_person_ex_type is
386: select 'Y'
387: from per_person_types ppt,
388: per_person_type_usages_f ptu
389: where ptu.person_id = p_person_id
390: and ppt.system_person_type = p_person_type
391: and ptu.effective_end_date < p_effective_date

Line 393: and not exists (select 'Y' from per_person_types ppt1,

389: where ptu.person_id = p_person_id
390: and ppt.system_person_type = p_person_type
391: and ptu.effective_end_date < p_effective_date
392: and ptu.person_type_id = ppt.person_type_id
393: and not exists (select 'Y' from per_person_types ppt1,
394: per_person_type_usages_f ptu1
395: where ptu1.person_id = p_person_id
396: and ppt1.system_person_type = p_person_type
397: and ptu1.effective_end_date >= p_effective_date

Line 403: l_temp_type per_person_types.system_person_type%type;

399: and ptu1.person_type_id = ppt1.person_type_id);
400: --
401: --
402: l_proc varchar2(72) := g_package||'check_person_ex_type';
403: l_temp_type per_person_types.system_person_type%type;
404: l_temp_id number;
405: l_result varchar2(4);
406: --
407: begin

Line 510: l_person_type per_person_types.system_person_type%TYPE;

506: ,p_effective_start_date out nocopy date
507: ,p_effective_end_date out nocopy date
508: ) is
509: l_proc varchar2(80) := g_package||'create_person_type_usage';
510: l_person_type per_person_types.system_person_type%TYPE;
511: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
512: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
513: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
514: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

Line 521: from per_person_types

517: --
518: cursor csr_valid_person_type
519: is
520: select system_person_type
521: from per_person_types
522: where person_type_id = p_person_type_id;
523: --
524: begin
525: --

Line 772: l_system_person_type per_person_types.system_person_type%TYPE;

768: ,p_effective_end_date out nocopy date
769: ) is
770:
771: l_proc varchar2(80) := g_package||'delete_person_type_usage';
772: l_system_person_type per_person_types.system_person_type%TYPE;
773: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
774: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
775: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
776:

Line 780: from per_person_type_usages_f ptu , per_person_types ppt

776:
777: cursor csr_ptu
778: is
779: select ppt.system_person_type
780: from per_person_type_usages_f ptu , per_person_types ppt
781: where ptu.person_type_usage_id = p_person_type_usage_id
782: and ptu.person_type_id = ppt.person_type_id
783: and ( p_effective_date between
784: ptu.effective_start_date and ptu.effective_end_date);