DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on FF_GLOBALS_F

Line 364: from ff_globals_f

360: -- cursor get values from globals bug 5766334
361: cursor csr_get_global_value(p_global_name varchar2,
362: p_cert_date date) is
363: select global_value
364: from ff_globals_f
365: where global_name = p_global_name
366: and p_cert_date between effective_start_date and effective_end_date;
367:
368: l_tax_rate_exempt ff_globals_f.global_value%TYPE;

Line 368: l_tax_rate_exempt ff_globals_f.global_value%TYPE;

364: from ff_globals_f
365: where global_name = p_global_name
366: and p_cert_date between effective_start_date and effective_end_date;
367:
368: l_tax_rate_exempt ff_globals_f.global_value%TYPE;
369: l_tax_rate_high ff_globals_f.global_value%TYPE;
370: --bug 6376140
371: --follw variables are added
372: r_pay c_pay%rowtype;

Line 369: l_tax_rate_high ff_globals_f.global_value%TYPE;

365: where global_name = p_global_name
366: and p_cert_date between effective_start_date and effective_end_date;
367:
368: l_tax_rate_exempt ff_globals_f.global_value%TYPE;
369: l_tax_rate_high ff_globals_f.global_value%TYPE;
370: --bug 6376140
371: --follw variables are added
372: r_pay c_pay%rowtype;
373: TYPE t_pps_number IS TABLE OF varchar2(30) INDEX BY Binary_Integer;

Line 3517: from ff_globals_f

3513: -- cursor get values from globals bug 5766334
3514: cursor csr_get_global_value(p_global_name varchar2,
3515: p_cert_date date) is
3516: select global_value
3517: from ff_globals_f
3518: where global_name = p_global_name
3519: and p_cert_date between effective_start_date and effective_end_date;
3520:
3521: l_tax_rate_exempt ff_globals_f.global_value%TYPE;

Line 3521: l_tax_rate_exempt ff_globals_f.global_value%TYPE;

3517: from ff_globals_f
3518: where global_name = p_global_name
3519: and p_cert_date between effective_start_date and effective_end_date;
3520:
3521: l_tax_rate_exempt ff_globals_f.global_value%TYPE;
3522: l_tax_rate_high ff_globals_f.global_value%TYPE;
3523: --bug 6376140
3524: --follw variables are added
3525: r_pay c_pay%rowtype;

Line 3522: l_tax_rate_high ff_globals_f.global_value%TYPE;

3518: where global_name = p_global_name
3519: and p_cert_date between effective_start_date and effective_end_date;
3520:
3521: l_tax_rate_exempt ff_globals_f.global_value%TYPE;
3522: l_tax_rate_high ff_globals_f.global_value%TYPE;
3523: --bug 6376140
3524: --follw variables are added
3525: r_pay c_pay%rowtype;
3526: TYPE t_pps_number IS TABLE OF varchar2(30) INDEX BY Binary_Integer;