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.HR_PUMP_GET dependencies on PER_COLLECTIVE_AGREEMENTS

Line 79: from per_collective_agreements pc

75: l_collective_agreement_id number;
76: begin
77: select pc.collective_agreement_id
78: into l_collective_agreement_id
79: from per_collective_agreements pc
80: where pc.business_group_id = p_business_group_id
81: and pc.name = p_cagr_name
82: and p_effective_date between
83: nvl(start_date,START_OF_TIME) and nvl(end_date,END_OF_TIME);

Line 3769: from per_collective_agreements pc

3765: l_object_version_number number;
3766: begin
3767: select pc.object_version_number
3768: into l_object_version_number
3769: from per_collective_agreements pc
3770: where pc.business_group_id = p_business_group_id
3771: and pc.name = p_cagr_name
3772: and p_effective_date between
3773: nvl(start_date,START_OF_TIME) and nvl(end_date,END_OF_TIME);