eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_RECON_SUMMARY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 486: p_tax_unit_id hr_all_organization_units.organization_id%type)

482: Function get_total_allowances ( p_year_start DATE,
483: p_year_end DATE,
484: p_assignment_id pay_assignment_actions.assignment_id%type,
485: p_assignment_action_id pay_assignment_actions.assignment_id%type,
486: p_tax_unit_id hr_all_organization_units.organization_id%type)
487: return number is
488:
489: CURSOR get_alw_balance_name (p_def_bal_id pay_defined_balances.defined_balance_id%type) IS
490: select NVL(pbt.reporting_name,pbt.balance_name)

Line 650: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

646:
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

Line 680: c_business_group_id hr_all_organization_units.organization_id%TYPE,

676: */
677: /* Bug: 12400821 - Performance Improvement done */
678:
679: cursor c_max_asg_action_id (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
680: c_business_group_id hr_all_organization_units.organization_id%TYPE,
681: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,
682: c_year_start date,
683: c_year_end date ) is
684: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

Line 681: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,

677: /* Bug: 12400821 - Performance Improvement done */
678:
679: cursor c_max_asg_action_id (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
680: c_business_group_id hr_all_organization_units.organization_id%TYPE,
681: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,
682: c_year_start date,
683: c_year_end date ) is
684: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
685: from pay_assignment_actions paa

Line 1750: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

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
1753: p_output_tab OUT NOCOPY bal_tab
1754: ) IS

Line 2666: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE

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
2669:
2670: g_debug boolean;