DBA Data[Home] [Help]

APPS.IRC_PARTY_API dependencies on FND_NUMBER

Line 2197: , fnd_number.canonical_to_number(org.org_information3) normal_hours

2193: --
2194: CURSOR csr_org_default_details(p_organization_id Number) IS
2195: SELECT org.org_information1
2196: , org.org_information2
2197: , fnd_number.canonical_to_number(org.org_information3) normal_hours
2198: , org.org_information4
2199: FROM HR_ORGANIZATION_INFORMATION org
2200: WHERE org.organization_id = p_organization_id
2201: AND org.org_information_context(+) = 'Work Day Information';

Line 2206: , fnd_number.canonical_to_number(bus.working_hours)

2202: --
2203: CURSOR csr_get_bg_default_details(p_business_group_id number) IS
2204: SELECT bus.default_start_time
2205: , bus.default_end_time
2206: , fnd_number.canonical_to_number(bus.working_hours)
2207: , bus.frequency
2208: FROM per_business_groups bus
2209: WHERE bus.business_group_id = p_business_group_id;
2210: --

Line 6305: , fnd_number.canonical_to_number(org.org_information3) normal_hours

6301: --
6302: CURSOR csr_org_default_details(p_organization_id Number) IS
6303: SELECT org.org_information1
6304: , org.org_information2
6305: , fnd_number.canonical_to_number(org.org_information3) normal_hours
6306: , org.org_information4
6307: FROM HR_ORGANIZATION_INFORMATION org
6308: WHERE org.organization_id = p_organization_id
6309: AND org.org_information_context(+) = 'Work Day Information';

Line 6314: , fnd_number.canonical_to_number(bus.working_hours)

6310: --
6311: CURSOR csr_get_bg_default_details(p_business_group_id number) IS
6312: SELECT bus.default_start_time
6313: , bus.default_end_time
6314: , fnd_number.canonical_to_number(bus.working_hours)
6315: , bus.frequency
6316: FROM per_business_groups bus
6317: WHERE bus.business_group_id = p_business_group_id;
6318: --