APPS.PAY_AU_RECON_SUMMARY dependencies on FF_GLOBALS_F

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

155: g_business_group_id hr_organization_units.organization_id%type;
156: x number;
157: g_total_workplace number; /*4015082 */
158: g_balance_type_tab g_bal_type_tab;
159: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
160:
161: /* Changes for 9147438 start */
162: type fw_gross_type_table is table of varchar2(1) index by binary_integer;
163: t_fw_gross_type fw_gross_type_table;

Line 651: c_fbt_rate ff_globals_f.global_value%TYPE,

647:
648: Function get_total_fbt(c_year_start DATE,
649: c_assignment_id pay_assignment_actions.assignment_id%type,
650: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
651: c_fbt_rate ff_globals_f.global_value%TYPE,
652: c_ml_rate ff_globals_f.global_value%TYPE,
653: p_termination VARCHAR2)
654: return number is
655:

Line 652: c_ml_rate ff_globals_f.global_value%TYPE,

648: Function get_total_fbt(c_year_start DATE,
649: c_assignment_id pay_assignment_actions.assignment_id%type,
650: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
651: c_fbt_rate ff_globals_f.global_value%TYPE,
652: c_ml_rate ff_globals_f.global_value%TYPE,
653: p_termination VARCHAR2)
654: return number is
655:
656: l_total_fbt number;

Line 707: FROM ff_globals_f

703: --------------------------------------------
704: CURSOR c_get_fbt_global(c_year_end DATE)
705: IS
706: SELECT global_value
707: FROM ff_globals_f
708: WHERE global_name = 'FBT_THRESHOLD'
709: AND legislation_code = 'AU'
710: AND c_year_end BETWEEN effective_start_date
711: AND effective_end_date ;

Line 1747: c_fbt_rate ff_globals_f.global_value%TYPE,

1743:
1744: PROCEDURE get_value_bbr(c_year_start DATE,
1745: c_year_end DATE,
1746: c_assignment_id pay_assignment_actions.assignment_id%type,
1747: c_fbt_rate ff_globals_f.global_value%TYPE,
1748: c_ml_rate ff_globals_f.global_value%TYPE,
1749: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1750: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
1751: p_termination_date DATE, --Bug 3098367

Line 1748: c_ml_rate ff_globals_f.global_value%TYPE,

1744: PROCEDURE get_value_bbr(c_year_start DATE,
1745: c_year_end DATE,
1746: c_assignment_id pay_assignment_actions.assignment_id%type,
1747: c_fbt_rate ff_globals_f.global_value%TYPE,
1748: c_ml_rate ff_globals_f.global_value%TYPE,
1749: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1750: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
1751: p_termination_date DATE, --Bug 3098367
1752: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367

Line 2663: , p_fbt_rate IN ff_globals_f.global_value%TYPE

2659: PROCEDURE get_assgt_curr_term_values_bbr
2660: ( p_year_start IN date
2661: , p_year_end IN date
2662: , p_assignment_id IN pay_assignment_actions.assignment_id%type
2663: , p_fbt_rate IN ff_globals_f.global_value%TYPE
2664: , p_ml_rate IN ff_globals_f.global_value%TYPE
2665: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
2666: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
2667: , p_emp_type IN varchar2

Line 2664: , p_ml_rate IN ff_globals_f.global_value%TYPE

2660: ( p_year_start IN date
2661: , p_year_end IN date
2662: , p_assignment_id IN pay_assignment_actions.assignment_id%type
2663: , p_fbt_rate IN ff_globals_f.global_value%TYPE
2664: , p_ml_rate IN ff_globals_f.global_value%TYPE
2665: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
2666: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
2667: , p_emp_type IN varchar2
2668: , p_term_output_tab OUT NOCOPY bal_tab) IS

Line 3229: FROM ff_globals_f

3225: --------------------------------------------
3226: CURSOR c_get_fbt_global(c_year_end DATE)
3227: IS
3228: SELECT global_value
3229: FROM ff_globals_f
3230: WHERE global_name = 'FBT_THRESHOLD'
3231: AND legislation_code = 'AU'
3232: AND c_year_end BETWEEN effective_start_date
3233: AND effective_end_date ;