APPS.IRC_UTILITIES_PKG dependencies on PER_BUSINESS_GROUPS

Line 1324: FROM per_business_groups bus

1320: AND org.org_information_context(+) = 'Work Day Information';
1321: CURSOR csr_bus_fte IS
1322: SELECT fnd_number.canonical_to_number(bus.working_hours) normal_hours ,
1323: DECODE(bus.frequency ,'Y',1 ,'M',12 ,'W',52 ,'D',365 ,1)
1324: FROM per_business_groups bus
1325: WHERE bus.business_group_id = p_business_group_id;
1326: --
1327: l_fte_factor NUMBER := NULL;
1328: l_norm_hours_per_year NUMBER;

Line 1939: from per_business_groups

1935: to_currency varchar2(240) := l_to_currency;
1936: l_profile_date varchar2(240);
1937: cursor csr_corp_currency is
1938: select CURRENCY_CODE
1939: from per_business_groups
1940: where BUSINESS_GROUP_ID = fnd_profile.value('IRC_CORPORATE_BUSINESS_GROUP');
1941: begin
1942: --
1943: if(to_currency is null) then

Line 1977: from per_business_groups

1973: l_user_date date;
1974: l_to_currency varchar2(240);
1975: cursor csr_curr_code is
1976: select CURRENCY_CODE
1977: from per_business_groups
1978: where BUSINESS_GROUP_ID = fnd_profile.value('IRC_CORPORATE_BUSINESS_GROUP');
1979: begin
1980: l_user_date := to_date(profile_date||'-'||to_char(effective_date,'YYYY'),'dd-MM-YYYY');
1981: if(l_user_date > effective_date) then