APPS.OTA_TDB_BUS dependencies on PER_LETTER_REQUEST_LINES

Line 2808: from per_letter_request_lines

2804: and a.enabled_flag='Y'; ---***added for bug#2791524;
2805:
2806: cursor c_request_exists is
2807: select null
2808: from per_letter_request_lines
2809: where ota_booking_id = p_booking_id
2810: and ota_booking_status_type_id = p_booking_status_type_id
2811: and letter_request_id = l_letter_request_id;
2812:

Line 2878: insert into per_letter_request_lines

2874: --
2875: if c_request_exists%notfound then
2876: --
2877: ----***added person_id in insert statement.Bug#2791524.
2878: insert into per_letter_request_lines
2879: (letter_request_line_id,
2880: business_group_id,
2881: letter_request_id,
2882: person_id,

Line 2888: (per_letter_request_lines_s.nextval,

2884: ota_booking_status_type_id,
2885: date_from
2886: )
2887: values
2888: (per_letter_request_lines_s.nextval,
2889: l_business_group_id,
2890: l_letter_req_id,
2891: p_delegate_person_id,
2892: p_booking_id,

Line 2930: from per_letter_request_lines

2926: and auto_or_manual = 'AUTO';
2927: --
2928: cursor c_request_exists is
2929: select null
2930: from per_letter_request_lines
2931: where ota_booking_id = p_booking_id
2932: and ota_booking_status_type_id = p_booking_status_type_id
2933: and letter_request_id = l_letter_request_id;
2934: --

Line 2962: insert into per_letter_request_lines

2958: fetch c_request_exists into l_dummy;
2959: --
2960: if c_request_exists%notfound then
2961: --
2962: insert into per_letter_request_lines
2963: (letter_request_line_id,
2964: business_group_id,
2965: letter_request_id,
2966: ota_booking_id,

Line 2971: (per_letter_request_lines_s.nextval,

2967: ota_booking_status_type_id,
2968: date_from
2969: )
2970: values
2971: (per_letter_request_lines_s.nextval,
2972: r_letters.business_group_id,
2973: l_letter_request_id,
2974: p_booking_id,
2975: p_booking_status_type_id,