APPS.PER_APPLICANT_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 2025: insert into per_letter_request_lines

2021: -- Bug fix 3648715
2022: -- Insert statment modified - 'r.business_group_id +0' changed to
2023: -- r.business_group_id to improve performance.
2024:
2025: insert into per_letter_request_lines
2026: (letter_request_line_id,
2027: business_group_id,
2028: letter_request_id,
2029: person_id,

Line 2033: select per_letter_request_lines_s.nextval,

2029: person_id,
2030: assignment_id,
2031: assignment_status_type_id,
2032: date_from )
2033: select per_letter_request_lines_s.nextval,
2034: p_business_group_id,
2035: r.letter_request_id,
2036: p_person_id,
2037: p_assignment_id,

Line 2050: from per_letter_request_lines l

2046: and s.assignment_status_type_id= p_assignment_status_type_id
2047: and s.enabled_flag = 'Y')
2048: and not exists
2049: (select l.assignment_id
2050: from per_letter_request_lines l
2051: where l.letter_request_id = r.letter_request_id
2052: and l.assignment_id = p_assignment_id
2053: and l.business_group_id + 0 = r.business_group_id + 0
2054: and l.date_from = p_validation_start_date)

Line 2096: insert into per_letter_request_lines

2092: -- bug fix 3648715
2093: -- Insert statment modified - 'r.business_group_id +0' changed to
2094: -- r.business_group_id to improve performance.
2095:
2096: insert into per_letter_request_lines
2097: (letter_request_line_id,
2098: business_group_id,
2099: letter_request_id,
2100: person_id,

Line 2105: per_letter_request_lines_s.nextval,

2101: assignment_id,
2102: assignment_status_type_id,
2103: date_from )
2104: select
2105: per_letter_request_lines_s.nextval,
2106: p_business_group_id,
2107: r.letter_request_id,
2108: p_person_id,
2109: p_assignment_id,

Line 2122: from per_letter_request_lines l

2118: and s.assignment_status_type_id = p_assignment_status_type_id
2119: and s.enabled_flag = 'Y')
2120: and not exists
2121: (select l.assignment_id
2122: from per_letter_request_lines l
2123: where l.letter_request_id = r.letter_request_id
2124: and l.assignment_id = p_assignment_id
2125: and l.business_group_id + 0 = r.business_group_id + 0
2126: and l.date_from = p_validation_start_date)