eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_LETTER_REQUEST_LINES

Line 2452: insert into per_letter_request_lines

2448: IF g_debug THEN
2449: hr_utility.set_location(g_package || l_proc, 40);
2450: END IF;
2451:
2452: insert into per_letter_request_lines
2453: (letter_request_line_id,
2454: business_group_id,
2455: letter_request_id,
2456: person_id,

Line 2460: select per_letter_request_lines_s.nextval,

2456: person_id,
2457: assignment_id,
2458: assignment_status_type_id,
2459: date_from )
2460: select per_letter_request_lines_s.nextval,
2461: p_business_group_id,
2462: r.letter_request_id,
2463: p_person_id,
2464: p_assignment_id,

Line 2477: from per_letter_request_lines l

2473: and s.assignment_status_type_id= p_assignment_status_type_id
2474: and s.enabled_flag = 'Y')
2475: and not exists
2476: (select l.assignment_id
2477: from per_letter_request_lines l
2478: where l.letter_request_id = r.letter_request_id
2479: and l.assignment_id = p_assignment_id
2480: and l.business_group_id + 0 = r.business_group_id + 0
2481: and l.date_from = p_validation_start_date)

Line 2529: insert into per_letter_request_lines

2525: IF g_debug THEN
2526: hr_utility.set_location(g_package || l_proc, 60);
2527: END IF;
2528:
2529: insert into per_letter_request_lines
2530: (letter_request_line_id,
2531: business_group_id,
2532: letter_request_id,
2533: person_id,

Line 2538: per_letter_request_lines_s.nextval,

2534: assignment_id,
2535: assignment_status_type_id,
2536: date_from )
2537: select
2538: per_letter_request_lines_s.nextval,
2539: p_business_group_id,
2540: r.letter_request_id,
2541: p_person_id,
2542: p_assignment_id,

Line 2555: from per_letter_request_lines l

2551: and s.assignment_status_type_id = p_assignment_status_type_id
2552: and s.enabled_flag = 'Y')
2553: and not exists
2554: (select l.assignment_id
2555: from per_letter_request_lines l
2556: where l.letter_request_id = r.letter_request_id
2557: and l.assignment_id = p_assignment_id
2558: and l.business_group_id + 0 = r.business_group_id + 0
2559: and l.date_from = p_validation_start_date)