APPS.PER_APPLICANT_PKG dependencies on PER_LETTER_REQUESTS

Line 1955: FROM PER_LETTER_REQUESTS PLR,

1951: -- Fix for bug 3680947 starts here.
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

Line 1991: insert into per_letter_requests

1987: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then
1988:
1989: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
1990:
1991: insert into per_letter_requests
1992: ( letter_request_id,
1993: business_group_id,
1994: letter_type_id,
1995: request_status,

Line 1999: select per_letter_requests_s.nextval,

1995: request_status,
1996: auto_or_manual,
1997: date_from,
1998: vacancy_id)
1999: select per_letter_requests_s.nextval,
2000: p_business_group_id,
2001: s.letter_type_id,
2002: 'PENDING',
2003: 'AUTO',

Line 2011: from per_letter_requests r

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
2011: from per_letter_requests r
2012: where r.letter_type_id = s.letter_type_id
2013: and r.business_group_id + 0 = p_business_group_id
2014: and r.business_group_id + 0 = s.business_group_id + 0
2015: and nvl(r.vacancy_id,-1) = nvl(p_vacancy_id,-1)

Line 2040: from per_letter_requests r

2036: p_person_id,
2037: p_assignment_id,
2038: p_assignment_status_type_id,
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

Line 2063: insert into per_letter_requests

2059: else
2060:
2061: -- Profile HR: Letter by Vacancy has not been set to Yes
2062:
2063: insert into per_letter_requests
2064: (letter_request_id,
2065: business_group_id,
2066: letter_type_id,
2067: request_status,

Line 2071: per_letter_requests_s.nextval,

2067: request_status,
2068: auto_or_manual,
2069: date_from)
2070: select
2071: per_letter_requests_s.nextval,
2072: p_business_group_id,
2073: s.letter_type_id,
2074: 'PENDING',
2075: 'AUTO',

Line 2082: from per_letter_requests r

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
2082: from per_letter_requests r
2083: where r.letter_type_id = s.letter_type_id
2084: and r.business_group_id + 0 = p_business_group_id
2085: and r.business_group_id + 0 = s.business_group_id + 0
2086: and r.request_status = 'PENDING'

Line 2112: from per_letter_requests r

2108: p_person_id,
2109: p_assignment_id,
2110: p_assignment_status_type_id,
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