APPS.PAY_AU_RECON_SUMMARY dependencies on FF_GLOBALS_F

Line 129: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */

125: g_total_workplace number; /*4015082 */
126:
127: g_balance_type_tab g_bal_type_tab;
128:
129: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
130:
131: Function total_gross
132: return number is
133: l_total_earnings_asg_ytd number;

Line 375: c_fbt_rate ff_globals_f.global_value%TYPE,

371:
372: Function get_total_fbt(c_year_start DATE,
373: c_assignment_id pay_assignment_actions.assignment_id%type,
374: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
375: c_fbt_rate ff_globals_f.global_value%TYPE,
376: c_ml_rate ff_globals_f.global_value%TYPE,
377: p_termination VARCHAR2)
378: return number is
379:

Line 376: c_ml_rate ff_globals_f.global_value%TYPE,

372: Function get_total_fbt(c_year_start DATE,
373: c_assignment_id pay_assignment_actions.assignment_id%type,
374: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
375: c_fbt_rate ff_globals_f.global_value%TYPE,
376: c_ml_rate ff_globals_f.global_value%TYPE,
377: p_termination VARCHAR2)
378: return number is
379:
380: l_total_fbt number;

Line 420: FROM ff_globals_f

416: --------------------------------------------
417: CURSOR c_get_fbt_global(c_year_end DATE)
418: IS
419: SELECT global_value
420: FROM ff_globals_f
421: WHERE global_name = 'FBT_THRESHOLD'
422: AND legislation_code = 'AU'
423: AND c_year_end BETWEEN effective_start_date
424: AND effective_end_date ;

Line 1075: c_fbt_rate ff_globals_f.global_value%TYPE,

1071:
1072: PROCEDURE get_value_bbr(c_year_start DATE,
1073: c_year_end DATE,
1074: c_assignment_id pay_assignment_actions.assignment_id%type,
1075: c_fbt_rate ff_globals_f.global_value%TYPE,
1076: c_ml_rate ff_globals_f.global_value%TYPE,
1077: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1078: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
1079: p_termination_date DATE, --Bug 3098367

Line 1076: c_ml_rate ff_globals_f.global_value%TYPE,

1072: PROCEDURE get_value_bbr(c_year_start DATE,
1073: c_year_end DATE,
1074: c_assignment_id pay_assignment_actions.assignment_id%type,
1075: c_fbt_rate ff_globals_f.global_value%TYPE,
1076: c_ml_rate ff_globals_f.global_value%TYPE,
1077: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1078: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
1079: p_termination_date DATE, --Bug 3098367
1080: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367

Line 1457: , p_fbt_rate IN ff_globals_f.global_value%TYPE

1453: PROCEDURE get_assgt_curr_term_values_bbr
1454: ( p_year_start IN date
1455: , p_year_end IN date
1456: , p_assignment_id IN pay_assignment_actions.assignment_id%type
1457: , p_fbt_rate IN ff_globals_f.global_value%TYPE
1458: , p_ml_rate IN ff_globals_f.global_value%TYPE
1459: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
1460: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
1461: , p_emp_type IN varchar2

Line 1458: , p_ml_rate IN ff_globals_f.global_value%TYPE

1454: ( p_year_start IN date
1455: , p_year_end IN date
1456: , p_assignment_id IN pay_assignment_actions.assignment_id%type
1457: , p_fbt_rate IN ff_globals_f.global_value%TYPE
1458: , p_ml_rate IN ff_globals_f.global_value%TYPE
1459: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
1460: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
1461: , p_emp_type IN varchar2
1462: , p_term_output_tab OUT NOCOPY bal_tab

Line 1988: FROM ff_globals_f

1984: --------------------------------------------
1985: CURSOR c_get_fbt_global(c_year_end DATE)
1986: IS
1987: SELECT global_value
1988: FROM ff_globals_f
1989: WHERE global_name = 'FBT_THRESHOLD'
1990: AND legislation_code = 'AU'
1991: AND c_year_end BETWEEN effective_start_date
1992: AND effective_end_date ;