APPS.PER_DB_PER_ADDITIONAL dependencies on PER_LETTER_REQUESTS

Line 727: FROM per_letter_requests

723: begin
724: hr_utility.set_location('per_db_per_additional.insert_assignment',25);
725: SELECT letter_request_id
726: INTO l_letter_request_id
727: FROM per_letter_requests
728: WHERE letter_type_id = l_letter_type_id
729: AND business_group_id + 0 = p_business_group_id
730: AND vacancy_id = p_vacancy_id
731: AND request_status = 'PENDING' ;

Line 740: SELECT per_letter_requests_s.nextval

736: hr_utility.set_location('per_db_per_additional.insert_assignment',30);
737: if l_letter_request_id IS NOT NULL then null;
738: else
739: hr_utility.set_location('per_db_per_additional.insert_assignment',35);
740: SELECT per_letter_requests_s.nextval
741: INTO l_letter_request_id
742: FROM sys.dual;
743: --
744: hr_utility.set_location('per_db_per_additional.insert_assignment',40);

Line 745: INSERT INTO per_letter_requests

741: INTO l_letter_request_id
742: FROM sys.dual;
743: --
744: hr_utility.set_location('per_db_per_additional.insert_assignment',40);
745: INSERT INTO per_letter_requests
746: (letter_request_id
747: ,business_group_id
748: ,letter_type_id
749: ,date_from