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 965: p_bg_id PER_BUSINESS_GROUPS.business_group_id%type;

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

Line 966: p_bg_name PER_BUSINESS_GROUPS.name%type;

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

Line 978: from PER_BUSINESS_GROUPS

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