DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on FND_NUMBER

Line 1315: SELECT fnd_number.canonical_to_number(org.org_information3) normal_hours ,

1311: DECODE(pos.frequency ,'Y',1 ,'M',12 ,'W',52 ,'D',365 ,1)
1312: FROM hr_all_positions pos
1313: WHERE pos.position_id=p_position_id;
1314: CURSOR csr_org_fte IS
1315: SELECT fnd_number.canonical_to_number(org.org_information3) normal_hours ,
1316: DECODE(org.org_information4 ,'Y',1 ,'M',12 ,'W',52 ,'D',365 ,1)
1317: FROM HR_ORGANIZATION_INFORMATION org
1318: WHERE org.organization_id =p_organization_id
1319: AND org.organization_id = p_organization_id

Line 1322: SELECT fnd_number.canonical_to_number(bus.working_hours) normal_hours ,

1318: WHERE org.organization_id =p_organization_id
1319: AND org.organization_id = p_organization_id
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: --