DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on FF_GLOBALS_F

Line 549: from ff_globals_f

545: -- cursor get values from globals bug 5766334
546: cursor csr_get_global_value(p_global_name varchar2,
547: p_cert_date date) is
548: select global_value
549: from ff_globals_f
550: where global_name = p_global_name
551: and p_cert_date between effective_start_date and effective_end_date;
552:
553: l_tax_rate_exempt ff_globals_f.global_value%TYPE;

Line 553: l_tax_rate_exempt ff_globals_f.global_value%TYPE;

549: from ff_globals_f
550: where global_name = p_global_name
551: and p_cert_date between effective_start_date and effective_end_date;
552:
553: l_tax_rate_exempt ff_globals_f.global_value%TYPE;
554: l_tax_rate_high ff_globals_f.global_value%TYPE;
555: --bug 6376140
556: --follw variables are added
557: r_pay c_pay%rowtype;

Line 554: l_tax_rate_high ff_globals_f.global_value%TYPE;

550: where global_name = p_global_name
551: and p_cert_date between effective_start_date and effective_end_date;
552:
553: l_tax_rate_exempt ff_globals_f.global_value%TYPE;
554: l_tax_rate_high ff_globals_f.global_value%TYPE;
555: --bug 6376140
556: --follw variables are added
557: r_pay c_pay%rowtype;
558: TYPE t_pps_number IS TABLE OF varchar2(30) INDEX BY Binary_Integer;