APPS.PER_APPLICANT_PKG dependencies on PER_LETTER_REQUESTS

Line 2361: FROM PER_LETTER_REQUESTS PLR,

2357: -- Fix for bug 3680947 starts here.
2358: --
2359: CURSOR csr_check_manual_or_auto IS
2360: SELECT 1
2361: FROM PER_LETTER_REQUESTS PLR,
2362: PER_LETTER_GEN_STATUSES PLGS
2363: WHERE PLGS.business_group_id + 0 = p_business_group_id
2364: AND PLR.business_group_id +0 = p_business_group_id
2365: AND PLGS.assignment_status_type_id = p_assignment_status_type_id

Line 2415: insert into per_letter_requests

2411: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
2412: END IF;
2413:
2414:
2415: insert into per_letter_requests
2416: ( letter_request_id,
2417: business_group_id,
2418: letter_type_id,
2419: request_status,

Line 2423: select per_letter_requests_s.nextval,

2419: request_status,
2420: auto_or_manual,
2421: date_from,
2422: vacancy_id)
2423: select per_letter_requests_s.nextval,
2424: p_business_group_id,
2425: s.letter_type_id,
2426: 'PENDING',
2427: 'AUTO',

Line 2435: from per_letter_requests r

2431: where s.business_group_id + 0 = p_business_group_id
2432: and s.assignment_status_type_id = p_assignment_status_type_id
2433: and s.enabled_flag = 'Y'
2434: and not exists ( select null
2435: from per_letter_requests r
2436: where r.letter_type_id = s.letter_type_id
2437: and r.business_group_id + 0 = p_business_group_id
2438: and r.business_group_id + 0 = s.business_group_id + 0
2439: and nvl(r.vacancy_id,-1) = nvl(p_vacancy_id,-1)

Line 2467: from per_letter_requests r

2463: p_person_id,
2464: p_assignment_id,
2465: p_assignment_status_type_id,
2466: p_validation_start_date
2467: from per_letter_requests r
2468: where exists
2469: (select null
2470: from per_letter_gen_statuses s
2471: where s.letter_type_id = r.letter_type_id

Line 2493: insert into per_letter_requests

2489: IF g_debug THEN
2490: hr_utility.set_location(g_package || l_proc, 50);
2491: END IF;
2492:
2493: insert into per_letter_requests
2494: (letter_request_id,
2495: business_group_id,
2496: letter_type_id,
2497: request_status,

Line 2501: per_letter_requests_s.nextval,

2497: request_status,
2498: auto_or_manual,
2499: date_from)
2500: select
2501: per_letter_requests_s.nextval,
2502: p_business_group_id,
2503: s.letter_type_id,
2504: 'PENDING',
2505: 'AUTO',

Line 2512: from per_letter_requests r

2508: where s.business_group_id + 0 = p_business_group_id
2509: and s.assignment_status_type_id = p_assignment_status_type_id
2510: and s.enabled_flag = 'Y'
2511: and not exists ( select null
2512: from per_letter_requests r
2513: where r.letter_type_id = s.letter_type_id
2514: and r.business_group_id + 0 = p_business_group_id
2515: and r.business_group_id + 0 = s.business_group_id + 0
2516: and r.request_status = 'PENDING'

Line 2545: from per_letter_requests r

2541: p_person_id,
2542: p_assignment_id,
2543: p_assignment_status_type_id,
2544: p_validation_start_date
2545: from per_letter_requests r
2546: where exists
2547: (select null
2548: from per_letter_gen_statuses s
2549: where s.letter_type_id = r.letter_type_id