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_BIAF_REPORT dependencies on PER_CONTRACTS_F

Line 68: per_contracts_f pcf,

64: per_all_assignments_f paf ,
65: per_all_people_f apf,
66: per_addresses pav,
67: hr_organization_information hoi,
68: per_contracts_f pcf,
69: hr_soft_coding_keyflex hsck,
70: per_periods_of_service ppos
71: where hou.organization_id= paf.establishment_id
72: and hout.organization_id=hou.organization_id

Line 540: from per_contracts_f pcf ,

536: is
537: cursor get_date(f_person_id number) is
538: select pcf.effective_start_date,
539: pcf.effective_end_date
540: from per_contracts_f pcf ,
541: per_all_assignments_f paf,
542: per_all_people_f ppf
543: where ppf.person_id=f_person_id
544: and paf.person_id=ppf.person_id

Line 547: from per_contracts_f pcf1

543: where ppf.person_id=f_person_id
544: and paf.person_id=ppf.person_id
545: and paf.contract_id(+)=pcf.contract_id
546: and pcf.effective_start_date=(select min(pcf1.effective_start_date)
547: from per_contracts_f pcf1
548: where pcf1.contract_id=pcf.contract_id);
549:
550: l_start_date date;
551: l_end_date date;