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 577: from per_contracts_f c

573: , type
574: , status
575: ,effective_start_date
576: ,effective_end_date
577: from per_contracts_f c
578: where person_id = g_person_id
579: and l_effective_date between effective_start_date and effective_end_date
580: and substrb(status,1,2) = 'A-';
581: --

Line 806: from per_contracts_f c

802: , type
803: , status
804: ,effective_start_date
805: ,effective_end_date
806: from per_contracts_f c
807: where person_id =
808: (select person_id
809: from per_periods_of_service
810: where period_of_service_id = p_period_of_service_id)

Line 823: from per_contracts_f c

819: , type
820: , status
821: ,effective_start_date
822: ,effective_end_date
823: from per_contracts_f c
824: where contract_id = p_contract_id
825: and effective_start_date = p_effective_date;
826: --
827: ctr2 c_get_ctr2%rowtype;