APPS.PER_APPLICANT_PKG dependencies on PER_LETTER_GEN_STATUSES

Line 2352: from per_letter_gen_statuses s

2348: l_proc varchar2(25) := 'check_for_letter_requests';
2349:
2350: cursor check_statuses is
2351: select 1
2352: from per_letter_gen_statuses s
2353: where s.business_group_id + 0 = p_business_group_id
2354: and s.assignment_status_type_id = p_assignment_status_type_id
2355: and s.enabled_flag = 'Y' ;
2356: --

Line 2362: PER_LETTER_GEN_STATUSES PLGS

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
2366: AND PLR.letter_type_id = PLGS.letter_type_id

Line 2430: from PER_LETTER_GEN_STATUSES s

2426: 'PENDING',
2427: 'AUTO',
2428: p_effective_start_date,
2429: p_vacancy_id
2430: from PER_LETTER_GEN_STATUSES s
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

Line 2470: from per_letter_gen_statuses s

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
2472: and s.business_group_id + 0 = r.business_group_id + 0
2473: and s.assignment_status_type_id= p_assignment_status_type_id
2474: and s.enabled_flag = 'Y')

Line 2507: from PER_LETTER_GEN_STATUSES s

2503: s.letter_type_id,
2504: 'PENDING',
2505: 'AUTO',
2506: p_effective_start_date
2507: from PER_LETTER_GEN_STATUSES s
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

Line 2548: from per_letter_gen_statuses s

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
2550: and s.business_group_id + 0 = r.business_group_id + 0
2551: and s.assignment_status_type_id = p_assignment_status_type_id
2552: and s.enabled_flag = 'Y')