28: End;
29:
30: FUNCTION get_query_only
31: return VARCHAR2 IS
32: l_query_only_profile_value VARCHAR2(240) := fnd_profile.VALUE('PER_QUERY_ONLY_MODE');
33: BEGIN
34:
35: RETURN l_query_only_profile_value;
36:
1584: FUNCTION get_fte_factor(p_assignment_id IN NUMBER
1585: ,p_effective_date IN DATE)
1586: return NUMBER IS
1587:
1588: l_fte_profile_value VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');
1589: l_fte_precision_value NUMBER;
1590:
1591: CURSOR csr_fte_BFTE
1592: IS
1609: BEGIN
1610: --Bug 8226280 smadhuna FTE Factor Precision profile to be used for rounding
1611: BEGIN
1612:
1613: l_fte_precision_value := fnd_profile.VALUE('HR_FTE_PRECISION');
1614:
1615: IF l_fte_precision_value NOT IN ( 1,2,3,4,5,6,7,8,9 ) THEN
1616: l_fte_precision_value := NULL;
1617: END IF;