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 3742: from per_collective_agreements pc

3738: l_object_version_number number;
3739: begin
3740: select pc.object_version_number
3741: into l_object_version_number
3742: from per_collective_agreements pc
3743: where pc.business_group_id = p_business_group_id
3744: and pc.name = p_cagr_name
3745: and p_effective_date between
3746: nvl(start_date,START_OF_TIME) and nvl(end_date,END_OF_TIME);