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.

APPS.PER_FR_TERMINATION dependencies on PER_CONTRACTS_F

Line 77: from per_contracts_f

73: l_exists varchar2(1);
74: --
75: cursor c_future_contracts is
76: select null
77: from per_contracts_f
78: where person_id = g_person_id
79: and effective_start_date > p_actual_termination_date + 1
80: and substrb(status,1,2) = 'A-';
81: --

Line 582: from per_contracts_f c

578: , type
579: , status
580: ,effective_start_date
581: ,effective_end_date
582: from per_contracts_f c
583: where person_id = g_person_id
584: and l_effective_date between effective_start_date and effective_end_date
585: and substrb(status,1,2) = 'A-';
586: --

Line 811: from per_contracts_f c

807: , type
808: , status
809: ,effective_start_date
810: ,effective_end_date
811: from per_contracts_f c
812: where person_id =
813: (select person_id
814: from per_periods_of_service
815: where period_of_service_id = p_period_of_service_id)

Line 828: from per_contracts_f c

824: , type
825: , status
826: ,effective_start_date
827: ,effective_end_date
828: from per_contracts_f c
829: where contract_id = p_contract_id
830: and effective_start_date = p_effective_date;
831: --
832: ctr2 c_get_ctr2%rowtype;