eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_USER_HOOK_PKG dependencies on PER_ALL_PEOPLE_F

Line 58: ( p_check_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'

54: -- of APL, EMP and CWK
55: --
56: IF l_system_person_type IN ('APL','EMP','CWK') THEN
57: IF hr_multi_message.no_exclusive_error
58: ( p_check_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'
59: )
60: THEN
61: IF p_race_code IS NULL OR
62: p_race_code = 'N' OR

Line 71: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'

67: )
68: THEN
69: fnd_message.set_name('PER', 'HR_ZA_MAND_SEG_RACE');
70: hr_multi_message.add
71: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PER_INFORMATION4'
72: );
73: END IF;
74: END IF;
75: END IF;

Line 497: in per_all_people_f.business_group_id%type default null

493: -- validate_applicant
494: -------------------------------------------------------------------------------
495: PROCEDURE validate_applicant
496: ( p_business_group_id
497: in per_all_people_f.business_group_id%type default null
498: , p_date_received
499: in date
500: , p_person_type_id
501: in per_all_people_f.person_type_id%type default null

Line 501: in per_all_people_f.person_type_id%type default null

497: in per_all_people_f.business_group_id%type default null
498: , p_date_received
499: in date
500: , p_person_type_id
501: in per_all_people_f.person_type_id%type default null
502: , p_per_information_category
503: in per_all_people_f.per_information_category%type default null
504: , p_per_information2
505: in per_all_people_f.per_information2%type default null

Line 503: in per_all_people_f.per_information_category%type default null

499: in date
500: , p_person_type_id
501: in per_all_people_f.person_type_id%type default null
502: , p_per_information_category
503: in per_all_people_f.per_information_category%type default null
504: , p_per_information2
505: in per_all_people_f.per_information2%type default null
506: , p_per_information4
507: in per_all_people_f.per_information4%type default null

Line 505: in per_all_people_f.per_information2%type default null

501: in per_all_people_f.person_type_id%type default null
502: , p_per_information_category
503: in per_all_people_f.per_information_category%type default null
504: , p_per_information2
505: in per_all_people_f.per_information2%type default null
506: , p_per_information4
507: in per_all_people_f.per_information4%type default null
508: , p_per_information10
509: in per_all_people_f.per_information10%type default null

Line 507: in per_all_people_f.per_information4%type default null

503: in per_all_people_f.per_information_category%type default null
504: , p_per_information2
505: in per_all_people_f.per_information2%type default null
506: , p_per_information4
507: in per_all_people_f.per_information4%type default null
508: , p_per_information10
509: in per_all_people_f.per_information10%type default null
510: , p_email_address
511: in per_all_people_f.email_address%type default null

Line 509: in per_all_people_f.per_information10%type default null

505: in per_all_people_f.per_information2%type default null
506: , p_per_information4
507: in per_all_people_f.per_information4%type default null
508: , p_per_information10
509: in per_all_people_f.per_information10%type default null
510: , p_email_address
511: in per_all_people_f.email_address%type default null
512: )
513: AS

Line 511: in per_all_people_f.email_address%type default null

507: in per_all_people_f.per_information4%type default null
508: , p_per_information10
509: in per_all_people_f.per_information10%type default null
510: , p_email_address
511: in per_all_people_f.email_address%type default null
512: )
513: AS
514: ------------
515: -- Variables

Line 518: l_person_type_id per_all_people_f.person_type_id%type;

514: ------------
515: -- Variables
516: ------------
517: l_proc varchar2(40) := g_package||'validate_applicant';
518: l_person_type_id per_all_people_f.person_type_id%type;
519:
520: BEGIN
521: -- hr_utility.trace_on(null,'ZAUHK');
522: hr_utility.trace('validate person');

Line 614: in per_all_people_f.business_group_id%type default null

610: -- validate_employee
611: -------------------------------------------------------------------------------
612: PROCEDURE validate_employee
613: ( p_business_group_id
614: in per_all_people_f.business_group_id%type default null
615: , p_hire_date
616: in date
617: , p_person_type_id
618: in per_all_people_f.person_type_id%type default null

Line 618: in per_all_people_f.person_type_id%type default null

614: in per_all_people_f.business_group_id%type default null
615: , p_hire_date
616: in date
617: , p_person_type_id
618: in per_all_people_f.person_type_id%type default null
619: , p_per_information_category
620: in per_all_people_f.per_information_category%type default null
621: , p_per_information2
622: in per_all_people_f.per_information2%type default null

Line 620: in per_all_people_f.per_information_category%type default null

616: in date
617: , p_person_type_id
618: in per_all_people_f.person_type_id%type default null
619: , p_per_information_category
620: in per_all_people_f.per_information_category%type default null
621: , p_per_information2
622: in per_all_people_f.per_information2%type default null
623: , p_per_information4
624: in per_all_people_f.per_information4%type default null

Line 622: in per_all_people_f.per_information2%type default null

618: in per_all_people_f.person_type_id%type default null
619: , p_per_information_category
620: in per_all_people_f.per_information_category%type default null
621: , p_per_information2
622: in per_all_people_f.per_information2%type default null
623: , p_per_information4
624: in per_all_people_f.per_information4%type default null
625: , p_per_information10
626: in per_all_people_f.per_information10%type default null

Line 624: in per_all_people_f.per_information4%type default null

620: in per_all_people_f.per_information_category%type default null
621: , p_per_information2
622: in per_all_people_f.per_information2%type default null
623: , p_per_information4
624: in per_all_people_f.per_information4%type default null
625: , p_per_information10
626: in per_all_people_f.per_information10%type default null
627: , p_email_address
628: in per_all_people_f.email_address%type default null

Line 626: in per_all_people_f.per_information10%type default null

622: in per_all_people_f.per_information2%type default null
623: , p_per_information4
624: in per_all_people_f.per_information4%type default null
625: , p_per_information10
626: in per_all_people_f.per_information10%type default null
627: , p_email_address
628: in per_all_people_f.email_address%type default null
629: , p_per_information12
630: in per_all_people_f.per_information12%type default null

Line 628: in per_all_people_f.email_address%type default null

624: in per_all_people_f.per_information4%type default null
625: , p_per_information10
626: in per_all_people_f.per_information10%type default null
627: , p_email_address
628: in per_all_people_f.email_address%type default null
629: , p_per_information12
630: in per_all_people_f.per_information12%type default null
631: , p_last_name
632: in per_all_people_f.last_name%type default null

Line 630: in per_all_people_f.per_information12%type default null

626: in per_all_people_f.per_information10%type default null
627: , p_email_address
628: in per_all_people_f.email_address%type default null
629: , p_per_information12
630: in per_all_people_f.per_information12%type default null
631: , p_last_name
632: in per_all_people_f.last_name%type default null
633: , p_first_name
634: in per_all_people_f.first_name%type default null

Line 632: in per_all_people_f.last_name%type default null

628: in per_all_people_f.email_address%type default null
629: , p_per_information12
630: in per_all_people_f.per_information12%type default null
631: , p_last_name
632: in per_all_people_f.last_name%type default null
633: , p_first_name
634: in per_all_people_f.first_name%type default null
635: , p_middle_names
636: in per_all_people_f.MIDDLE_NAMES%type default null

Line 634: in per_all_people_f.first_name%type default null

630: in per_all_people_f.per_information12%type default null
631: , p_last_name
632: in per_all_people_f.last_name%type default null
633: , p_first_name
634: in per_all_people_f.first_name%type default null
635: , p_middle_names
636: in per_all_people_f.MIDDLE_NAMES%type default null
637: , p_employee_number
638: in per_all_people_f.EMPLOYEE_NUMBER%type default null

Line 636: in per_all_people_f.MIDDLE_NAMES%type default null

632: in per_all_people_f.last_name%type default null
633: , p_first_name
634: in per_all_people_f.first_name%type default null
635: , p_middle_names
636: in per_all_people_f.MIDDLE_NAMES%type default null
637: , p_employee_number
638: in per_all_people_f.EMPLOYEE_NUMBER%type default null
639: , p_national_identifier
640: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

Line 638: in per_all_people_f.EMPLOYEE_NUMBER%type default null

634: in per_all_people_f.first_name%type default null
635: , p_middle_names
636: in per_all_people_f.MIDDLE_NAMES%type default null
637: , p_employee_number
638: in per_all_people_f.EMPLOYEE_NUMBER%type default null
639: , p_national_identifier
640: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
641: , p_per_information1
642: in per_all_people_f.per_information1%type default null

Line 640: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

636: in per_all_people_f.MIDDLE_NAMES%type default null
637: , p_employee_number
638: in per_all_people_f.EMPLOYEE_NUMBER%type default null
639: , p_national_identifier
640: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
641: , p_per_information1
642: in per_all_people_f.per_information1%type default null
643: , p_date_of_birth
644: in per_all_people_f.date_of_birth%type default null

Line 642: in per_all_people_f.per_information1%type default null

638: in per_all_people_f.EMPLOYEE_NUMBER%type default null
639: , p_national_identifier
640: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
641: , p_per_information1
642: in per_all_people_f.per_information1%type default null
643: , p_date_of_birth
644: in per_all_people_f.date_of_birth%type default null
645: )
646: AS

Line 644: in per_all_people_f.date_of_birth%type default null

640: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
641: , p_per_information1
642: in per_all_people_f.per_information1%type default null
643: , p_date_of_birth
644: in per_all_people_f.date_of_birth%type default null
645: )
646: AS
647:
648: CURSOR c_asg_nop

Line 651: from PER_ASSIGNMENT_EXTRA_INFO pei, per_all_assignments_f paf, per_all_people_f papf

647:
648: CURSOR c_asg_nop
649: IS
650: select pei.AEI_INFORMATION4,papf.person_id
651: from PER_ASSIGNMENT_EXTRA_INFO pei, per_all_assignments_f paf, per_all_people_f papf
652: where pei.assignment_id = paf.assignment_id
653: and paf.person_id = papf.person_id
654: and papf.employee_number = p_employee_number
655: and paf.primary_flag = 'Y'

Line 684: l_person_type_id per_all_people_f.person_type_id%type;

680: ------------
681: -- Variables
682: ------------
683: l_proc varchar2(40) := g_package||'validate_employee';
684: l_person_type_id per_all_people_f.person_type_id%type;
685: l_asg_nop per_all_people_f.per_information12%type;
686: l_person_id per_all_people_f.person_id%type;
687: l_profile varchar2(1) := 'N';
688: l_auto_generated varchar2(10); -- Bug#12674949

Line 685: l_asg_nop per_all_people_f.per_information12%type;

681: -- Variables
682: ------------
683: l_proc varchar2(40) := g_package||'validate_employee';
684: l_person_type_id per_all_people_f.person_type_id%type;
685: l_asg_nop per_all_people_f.per_information12%type;
686: l_person_id per_all_people_f.person_id%type;
687: l_profile varchar2(1) := 'N';
688: l_auto_generated varchar2(10); -- Bug#12674949
689:

Line 686: l_person_id per_all_people_f.person_id%type;

682: ------------
683: l_proc varchar2(40) := g_package||'validate_employee';
684: l_person_type_id per_all_people_f.person_type_id%type;
685: l_asg_nop per_all_people_f.per_information12%type;
686: l_person_id per_all_people_f.person_id%type;
687: l_profile varchar2(1) := 'N';
688: l_auto_generated varchar2(10); -- Bug#12674949
689:
690: BEGIN

Line 872: in per_all_people_f.business_group_id%type default null

868: -- validate_cwk
869: -------------------------------------------------------------------------------
870: PROCEDURE validate_cwk
871: ( p_business_group_id
872: in per_all_people_f.business_group_id%type default null
873: , p_start_date
874: in date
875: , p_person_type_id
876: in per_all_people_f.person_type_id%type default null

Line 876: in per_all_people_f.person_type_id%type default null

872: in per_all_people_f.business_group_id%type default null
873: , p_start_date
874: in date
875: , p_person_type_id
876: in per_all_people_f.person_type_id%type default null
877: , p_per_information_category
878: in per_all_people_f.per_information_category%type default null
879: , p_per_information2
880: in per_all_people_f.per_information2%type default null

Line 878: in per_all_people_f.per_information_category%type default null

874: in date
875: , p_person_type_id
876: in per_all_people_f.person_type_id%type default null
877: , p_per_information_category
878: in per_all_people_f.per_information_category%type default null
879: , p_per_information2
880: in per_all_people_f.per_information2%type default null
881: , p_per_information4
882: in per_all_people_f.per_information4%type default null

Line 880: in per_all_people_f.per_information2%type default null

876: in per_all_people_f.person_type_id%type default null
877: , p_per_information_category
878: in per_all_people_f.per_information_category%type default null
879: , p_per_information2
880: in per_all_people_f.per_information2%type default null
881: , p_per_information4
882: in per_all_people_f.per_information4%type default null
883: , p_per_information10
884: in per_all_people_f.per_information10%type default null

Line 882: in per_all_people_f.per_information4%type default null

878: in per_all_people_f.per_information_category%type default null
879: , p_per_information2
880: in per_all_people_f.per_information2%type default null
881: , p_per_information4
882: in per_all_people_f.per_information4%type default null
883: , p_per_information10
884: in per_all_people_f.per_information10%type default null
885: , p_email_address
886: in per_all_people_f.email_address%type default null

Line 884: in per_all_people_f.per_information10%type default null

880: in per_all_people_f.per_information2%type default null
881: , p_per_information4
882: in per_all_people_f.per_information4%type default null
883: , p_per_information10
884: in per_all_people_f.per_information10%type default null
885: , p_email_address
886: in per_all_people_f.email_address%type default null
887: )
888: AS

Line 886: in per_all_people_f.email_address%type default null

882: in per_all_people_f.per_information4%type default null
883: , p_per_information10
884: in per_all_people_f.per_information10%type default null
885: , p_email_address
886: in per_all_people_f.email_address%type default null
887: )
888: AS
889: ------------
890: -- Variables

Line 893: l_person_type_id per_all_people_f.person_type_id%type;

889: ------------
890: -- Variables
891: ------------
892: l_proc varchar2(40) := g_package||'validate_cwk';
893: l_person_type_id per_all_people_f.person_type_id%type;
894:
895: BEGIN
896: -- hr_utility.trace_on(null,'ZAUHK');
897: hr_utility.trace('validate person');

Line 992: in per_all_people_f.person_id%type

988: -- validate_person
989: -------------------------------------------------------------------------------
990: PROCEDURE validate_person
991: ( p_person_id
992: in per_all_people_f.person_id%type
993: , p_effective_date
994: in date
995: , p_person_type_id
996: in per_all_people_f.person_type_id%type

Line 996: in per_all_people_f.person_type_id%type

992: in per_all_people_f.person_id%type
993: , p_effective_date
994: in date
995: , p_person_type_id
996: in per_all_people_f.person_type_id%type
997: , p_per_information_category
998: in per_all_people_f.per_information_category%type
999: , p_per_information2
1000: in per_all_people_f.per_information2%type default null

Line 998: in per_all_people_f.per_information_category%type

994: in date
995: , p_person_type_id
996: in per_all_people_f.person_type_id%type
997: , p_per_information_category
998: in per_all_people_f.per_information_category%type
999: , p_per_information2
1000: in per_all_people_f.per_information2%type default null
1001: , p_per_information4
1002: in per_all_people_f.per_information4%type

Line 1000: in per_all_people_f.per_information2%type default null

996: in per_all_people_f.person_type_id%type
997: , p_per_information_category
998: in per_all_people_f.per_information_category%type
999: , p_per_information2
1000: in per_all_people_f.per_information2%type default null
1001: , p_per_information4
1002: in per_all_people_f.per_information4%type
1003: , p_per_information10
1004: in per_all_people_f.per_information10%type default null

Line 1002: in per_all_people_f.per_information4%type

998: in per_all_people_f.per_information_category%type
999: , p_per_information2
1000: in per_all_people_f.per_information2%type default null
1001: , p_per_information4
1002: in per_all_people_f.per_information4%type
1003: , p_per_information10
1004: in per_all_people_f.per_information10%type default null
1005: , p_email_address
1006: in per_all_people_f.email_address%type default null

Line 1004: in per_all_people_f.per_information10%type default null

1000: in per_all_people_f.per_information2%type default null
1001: , p_per_information4
1002: in per_all_people_f.per_information4%type
1003: , p_per_information10
1004: in per_all_people_f.per_information10%type default null
1005: , p_email_address
1006: in per_all_people_f.email_address%type default null
1007: , p_per_information12
1008: in per_all_people_f.per_information12%type default null

Line 1006: in per_all_people_f.email_address%type default null

1002: in per_all_people_f.per_information4%type
1003: , p_per_information10
1004: in per_all_people_f.per_information10%type default null
1005: , p_email_address
1006: in per_all_people_f.email_address%type default null
1007: , p_per_information12
1008: in per_all_people_f.per_information12%type default null
1009: , p_last_name
1010: in per_all_people_f.last_name%type default null

Line 1008: in per_all_people_f.per_information12%type default null

1004: in per_all_people_f.per_information10%type default null
1005: , p_email_address
1006: in per_all_people_f.email_address%type default null
1007: , p_per_information12
1008: in per_all_people_f.per_information12%type default null
1009: , p_last_name
1010: in per_all_people_f.last_name%type default null
1011: , p_first_name
1012: in per_all_people_f.first_name%type default null

Line 1010: in per_all_people_f.last_name%type default null

1006: in per_all_people_f.email_address%type default null
1007: , p_per_information12
1008: in per_all_people_f.per_information12%type default null
1009: , p_last_name
1010: in per_all_people_f.last_name%type default null
1011: , p_first_name
1012: in per_all_people_f.first_name%type default null
1013: , p_middle_names
1014: in per_all_people_f.MIDDLE_NAMES%type default null

Line 1012: in per_all_people_f.first_name%type default null

1008: in per_all_people_f.per_information12%type default null
1009: , p_last_name
1010: in per_all_people_f.last_name%type default null
1011: , p_first_name
1012: in per_all_people_f.first_name%type default null
1013: , p_middle_names
1014: in per_all_people_f.MIDDLE_NAMES%type default null
1015: , p_employee_number
1016: in per_all_people_f.EMPLOYEE_NUMBER%type default null

Line 1014: in per_all_people_f.MIDDLE_NAMES%type default null

1010: in per_all_people_f.last_name%type default null
1011: , p_first_name
1012: in per_all_people_f.first_name%type default null
1013: , p_middle_names
1014: in per_all_people_f.MIDDLE_NAMES%type default null
1015: , p_employee_number
1016: in per_all_people_f.EMPLOYEE_NUMBER%type default null
1017: , p_national_identifier
1018: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

Line 1016: in per_all_people_f.EMPLOYEE_NUMBER%type default null

1012: in per_all_people_f.first_name%type default null
1013: , p_middle_names
1014: in per_all_people_f.MIDDLE_NAMES%type default null
1015: , p_employee_number
1016: in per_all_people_f.EMPLOYEE_NUMBER%type default null
1017: , p_national_identifier
1018: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
1019: , p_per_information1
1020: in per_all_people_f.per_information1%type default null

Line 1018: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

1014: in per_all_people_f.MIDDLE_NAMES%type default null
1015: , p_employee_number
1016: in per_all_people_f.EMPLOYEE_NUMBER%type default null
1017: , p_national_identifier
1018: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
1019: , p_per_information1
1020: in per_all_people_f.per_information1%type default null
1021: , p_date_of_birth
1022: in per_all_people_f.date_of_birth%type default null

Line 1020: in per_all_people_f.per_information1%type default null

1016: in per_all_people_f.EMPLOYEE_NUMBER%type default null
1017: , p_national_identifier
1018: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
1019: , p_per_information1
1020: in per_all_people_f.per_information1%type default null
1021: , p_date_of_birth
1022: in per_all_people_f.date_of_birth%type default null
1023: )
1024: AS

Line 1022: in per_all_people_f.date_of_birth%type default null

1018: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
1019: , p_per_information1
1020: in per_all_people_f.per_information1%type default null
1021: , p_date_of_birth
1022: in per_all_people_f.date_of_birth%type default null
1023: )
1024: AS
1025: ---------
1026: -- Cursor

Line 1031: FROM per_all_people_f

1027: ---------
1028: CURSOR c_person_person_type
1029: IS
1030: SELECT person_type_id
1031: FROM per_all_people_f
1032: WHERE person_id = p_person_id
1033: AND p_effective_date BETWEEN effective_start_date
1034: AND effective_end_date;
1035: CURSOR c_person_race

Line 1038: FROM per_all_people_f

1034: AND effective_end_date;
1035: CURSOR c_person_race
1036: IS
1037: SELECT per_information4
1038: FROM per_all_people_f
1039: WHERE person_id = p_person_id
1040: AND p_effective_date BETWEEN effective_start_date
1041: AND effective_end_date;
1042: CURSOR c_person_nop

Line 1045: from per_all_people_f

1041: AND effective_end_date;
1042: CURSOR c_person_nop
1043: IS
1044: select per_information12
1045: from per_all_people_f
1046: where person_id = p_person_id
1047: and p_effective_date BETWEEN effective_start_date
1048: AND effective_end_date;
1049:

Line 1071: from PER_ALL_PEOPLE_F

1067:
1068: CURSOR c_emp_num
1069: IS
1070: select EMPLOYEE_NUMBER
1071: from PER_ALL_PEOPLE_F
1072: where person_id = p_person_id;
1073:
1074: -- 11899934
1075:

Line 1086: FROM PER_ALL_PEOPLE_F

1082: SELECT ORG_INFORMATION2
1083: FROM HR_ORGANIZATION_INFORMATION
1084: WHERE ORG_INFORMATION_CONTEXT = 'Business Group Information'
1085: AND ORGANIZATION_ID = (SELECT BUSINESS_GROUP_ID
1086: FROM PER_ALL_PEOPLE_F
1087: WHERE PERSON_ID = p_person_id
1088: AND p_effective_date BETWEEN effective_start_date
1089: AND effective_end_date); /* Bug 12674949 */
1090:

Line 1097: l_person_type_id per_all_people_f.person_type_id%type;

1093: ------------
1094: -- Variables
1095: ------------
1096: l_proc varchar2(40) := g_package||'validate_person';
1097: l_person_type_id per_all_people_f.person_type_id%type;
1098: l_person_race per_all_people_f.per_information4%type;
1099: l_person_nop per_all_people_f.per_information12%type;
1100: l_alpha varchar2(52) := '- ,''.';
1101: l_invalid_char varchar2(1) := '~';

Line 1098: l_person_race per_all_people_f.per_information4%type;

1094: -- Variables
1095: ------------
1096: l_proc varchar2(40) := g_package||'validate_person';
1097: l_person_type_id per_all_people_f.person_type_id%type;
1098: l_person_race per_all_people_f.per_information4%type;
1099: l_person_nop per_all_people_f.per_information12%type;
1100: l_alpha varchar2(52) := '- ,''.';
1101: l_invalid_char varchar2(1) := '~';
1102: l_asg_nop per_all_people_f.per_information12%type;

Line 1099: l_person_nop per_all_people_f.per_information12%type;

1095: ------------
1096: l_proc varchar2(40) := g_package||'validate_person';
1097: l_person_type_id per_all_people_f.person_type_id%type;
1098: l_person_race per_all_people_f.per_information4%type;
1099: l_person_nop per_all_people_f.per_information12%type;
1100: l_alpha varchar2(52) := '- ,''.';
1101: l_invalid_char varchar2(1) := '~';
1102: l_asg_nop per_all_people_f.per_information12%type;
1103: l_profile varchar2(1) := 'N';

Line 1102: l_asg_nop per_all_people_f.per_information12%type;

1098: l_person_race per_all_people_f.per_information4%type;
1099: l_person_nop per_all_people_f.per_information12%type;
1100: l_alpha varchar2(52) := '- ,''.';
1101: l_invalid_char varchar2(1) := '~';
1102: l_asg_nop per_all_people_f.per_information12%type;
1103: l_profile varchar2(1) := 'N';
1104: l_emp_num varchar2(50); -- 11899934
1105: l_auto_generated varchar2(10); -- Bug#12674949
1106:

Line 1436: FROM per_all_people_f paf

1432: if l_asg_primary_flag = 'Y' then
1433:
1434: SELECT per_information12
1435: INTO l_person_nop
1436: FROM per_all_people_f paf
1437: ,per_all_assignments_f paaf
1438: WHERE paaf.assignment_id = P_ASSIGNMENT_ID
1439: AND paaf.person_id = paf.person_id
1440: AND paaf.primary_flag = 'Y'

Line 1514: FROM per_all_people_f paf

1510:
1511: if l_asg_primary_flag = 'Y' then
1512: SELECT paf.per_information12
1513: INTO l_person_nop
1514: FROM per_all_people_f paf
1515: ,per_all_assignments_f paaf
1516: ,per_assignment_extra_info pai
1517: WHERE pai.assignment_extra_info_id = P_ASSIGNMENT_EXTRA_INFO_ID
1518: AND pai.assignment_id = paaf.assignment_id