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_FULL_SYNC_MESSAGES dependencies on PER_BUSINESS_GROUPS

Line 964: p_bg_id PER_BUSINESS_GROUPS.business_group_id%type;

960: procedure hr_businessgrp_full_sync(errbuf OUT NOCOPY VARCHAR2
961: ,retcode OUT NOCOPY VARCHAR2)
962: is
963:
964: p_bg_id PER_BUSINESS_GROUPS.business_group_id%type;
965: p_bg_name PER_BUSINESS_GROUPS.name%type;
966: p_eff_status varchar2(10);
967: p_eff_date date;
968: p_effective_date date default sysdate;

Line 965: p_bg_name PER_BUSINESS_GROUPS.name%type;

961: ,retcode OUT NOCOPY VARCHAR2)
962: is
963:
964: p_bg_id PER_BUSINESS_GROUPS.business_group_id%type;
965: p_bg_name PER_BUSINESS_GROUPS.name%type;
966: p_eff_status varchar2(10);
967: p_eff_date date;
968: p_effective_date date default sysdate;
969:

Line 977: from PER_BUSINESS_GROUPS

973: case when date_to is null then date_from
974: else date_to end,
975: case when date_to is null then 'ACTIVE'
976: else 'INACTIVE' end
977: from PER_BUSINESS_GROUPS
978: where p_effective_date between date_from and
979: nvl (date_to, to_date('31-12-4712', 'DD-MM-YYYY'));
980:
981: