APPS.PAY_GB_NICAR_06042002 dependencies on FF_GLOBALS_F

Line 229: from ff_globals_f

225:
226:
227: cursor csr_max_price_global is
228: select to_number(global_value)
229: from ff_globals_f
230: where global_name = 'NI_CAR_MAX_PRICE'
231: and p_session_date between
232: effective_start_date and effective_end_date;
233:

Line 867: from ff_globals_f

863:
864:
865: cursor csr_max_price_global is
866: select to_number(global_value)
867: from ff_globals_f
868: where global_name = 'NI_CAR_MAX_PRICE'
869: and p_session_date between
870: effective_start_date and effective_end_date;
871:

Line 1339: l_global_value ff_globals_f.global_value%type;

1335: p_session_date IN DATE)
1336: return NUMBER is
1337:
1338: l_percentage NUMBER;
1339: l_global_value ff_globals_f.global_value%type;
1340: l_global_name ff_globals_f.global_name%type;
1341:
1342: l_function_name VARCHAR2(12):= 'get_discount';
1343:

Line 1340: l_global_name ff_globals_f.global_name%type;

1336: return NUMBER is
1337:
1338: l_percentage NUMBER;
1339: l_global_value ff_globals_f.global_value%type;
1340: l_global_name ff_globals_f.global_name%type;
1341:
1342: l_function_name VARCHAR2(12):= 'get_discount';
1343:
1344: l_discount NUMBER;

Line 1348: from ff_globals_f

1344: l_discount NUMBER;
1345:
1346: cursor csr_global_value is
1347: select to_number(global_value)
1348: from ff_globals_f
1349: where legislation_code = 'GB'
1350: and upper(global_name) = upper(l_global_name)
1351: and p_session_date between effective_start_date
1352: and effective_end_date;

Line 1529: FROM ff_globals_f LIM

1525: --
1526: cursor csr1_globals is
1527: SELECT fnd_number.canonical_to_number(LIM.global_value)
1528: , fnd_number.canonical_to_number(NIR.global_value)
1529: FROM ff_globals_f LIM
1530: , ff_globals_f NIR
1531: WHERE LIM.global_name = 'NI_CAR_MAX_PRICE'
1532: AND csr0_session_date between LIM.effective_start_date and LIM.effective_end_date
1533: AND NIR.global_name = 'NI_ERS_RATE'

Line 1530: , ff_globals_f NIR

1526: cursor csr1_globals is
1527: SELECT fnd_number.canonical_to_number(LIM.global_value)
1528: , fnd_number.canonical_to_number(NIR.global_value)
1529: FROM ff_globals_f LIM
1530: , ff_globals_f NIR
1531: WHERE LIM.global_name = 'NI_CAR_MAX_PRICE'
1532: AND csr0_session_date between LIM.effective_start_date and LIM.effective_end_date
1533: AND NIR.global_name = 'NI_ERS_RATE'
1534: AND csr0_session_date between NIR.effective_start_date and NIR.effective_end_date;