APPS.PER_EVENTS_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 446: insert into per_letter_request_lines

442:
443: -- bug fix 3648618.
444: -- '+0' removed from where clause to improve performance.
445:
446: insert into per_letter_request_lines
447: ( letter_request_line_id
448: , business_group_id
449: , letter_request_id
450: , person_id

Line 459: select per_letter_request_lines_s.nextval

455: , last_updated_by
456: , last_update_login
457: , created_by
458: , creation_date)
459: select per_letter_request_lines_s.nextval
460: , p_business_group_id
461: , r.letter_request_id
462: , p_person_id
463: , p_ASSIGNMENT_ID

Line 483: from per_letter_request_lines l

479: p_ASSIGNMENT_STATUS_TYPE_ID
480: and s.enabled_flag = 'Y')
481: and not exists
482: (select l.assignment_id
483: from per_letter_request_lines l
484: where l.letter_request_id = r.letter_request_id
485: and l.business_group_id + 0 = p_business_group_id
486: and l.assignment_id = p_ASSIGNMENT_ID
487: and l.business_group_id +0 = r.business_group_id + 0)

Line 539: insert into per_letter_request_lines

535:
536: -- bug fix 3648618.
537: -- '+0' removed from where clause to improve performance.
538:
539: insert into per_letter_request_lines
540: ( letter_request_line_id
541: , business_group_id
542: , letter_request_id
543: , person_id

Line 552: select per_letter_request_lines_s.nextval

548: , last_updated_by
549: , last_update_login
550: , created_by
551: , creation_date)
552: select per_letter_request_lines_s.nextval
553: , p_business_group_id
554: , r.letter_request_id
555: , p_person_id
556: , p_ASSIGNMENT_ID

Line 576: from per_letter_request_lines l

572: p_ASSIGNMENT_STATUS_TYPE_ID
573: and s.enabled_flag = 'Y')
574: and not exists
575: (select l.assignment_id
576: from per_letter_request_lines l
577: where l.letter_request_id = r.letter_request_id
578: and l.business_group_id + 0 = p_business_group_id
579: and l.assignment_id = p_ASSIGNMENT_ID
580: and l.business_group_id +0 = r.business_group_id + 0)