APPS.PER_APPLICANT_PKG dependencies on PER_LETTER_GEN_STATUSES

Line 1946: from per_letter_gen_statuses s

1942: p_vacancy_id in number) is
1943: l_dummy_number number ;
1944: cursor check_statuses is
1945: select 1
1946: from per_letter_gen_statuses s
1947: where s.business_group_id + 0 = p_business_group_id
1948: and s.assignment_status_type_id = p_assignment_status_type_id
1949: and s.enabled_flag = 'Y' ;
1950: --

Line 1956: PER_LETTER_GEN_STATUSES PLGS

1952: --
1953: CURSOR csr_check_manual_or_auto IS
1954: SELECT 1
1955: FROM PER_LETTER_REQUESTS PLR,
1956: PER_LETTER_GEN_STATUSES PLGS
1957: WHERE PLGS.business_group_id + 0 = p_business_group_id
1958: AND PLR.business_group_id +0 = p_business_group_id
1959: AND PLGS.assignment_status_type_id = p_assignment_status_type_id
1960: AND PLR.letter_type_id = PLGS.letter_type_id

Line 2006: from PER_LETTER_GEN_STATUSES s

2002: 'PENDING',
2003: 'AUTO',
2004: p_effective_start_date,
2005: p_vacancy_id
2006: from PER_LETTER_GEN_STATUSES s
2007: where s.business_group_id + 0 = p_business_group_id
2008: and s.assignment_status_type_id = p_assignment_status_type_id
2009: and s.enabled_flag = 'Y'
2010: and not exists ( select null

Line 2043: from per_letter_gen_statuses s

2039: p_validation_start_date
2040: from per_letter_requests r
2041: where exists
2042: (select null
2043: from per_letter_gen_statuses s
2044: where s.letter_type_id = r.letter_type_id
2045: and s.business_group_id + 0 = r.business_group_id + 0
2046: and s.assignment_status_type_id= p_assignment_status_type_id
2047: and s.enabled_flag = 'Y')

Line 2077: from PER_LETTER_GEN_STATUSES s

2073: s.letter_type_id,
2074: 'PENDING',
2075: 'AUTO',
2076: p_effective_start_date
2077: from PER_LETTER_GEN_STATUSES s
2078: where s.business_group_id + 0 = p_business_group_id
2079: and s.assignment_status_type_id = p_assignment_status_type_id
2080: and s.enabled_flag = 'Y'
2081: and not exists ( select null

Line 2115: from per_letter_gen_statuses s

2111: p_validation_start_date
2112: from per_letter_requests r
2113: where exists
2114: (select null
2115: from per_letter_gen_statuses s
2116: where s.letter_type_id = r.letter_type_id
2117: and s.business_group_id + 0 = r.business_group_id + 0
2118: and s.assignment_status_type_id = p_assignment_status_type_id
2119: and s.enabled_flag = 'Y')