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 374: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

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

Line 394: c_business_group_id hr_all_organization_units.organization_id%TYPE,

390: Bug: 4256506 - Changed cursor c_max_asg_action_id. Merged sub query to fetch max action sequemce in main query. Done for
391: better performance.
392: */
393: cursor c_max_asg_action_id (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
394: c_business_group_id hr_all_organization_units.organization_id%TYPE,
395: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,
396: c_year_start date,
397: c_year_end date ) is
398: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

Line 395: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,

391: better performance.
392: */
393: cursor c_max_asg_action_id (c_assignment_id per_all_assignments_f.assignment_id%TYPE,
394: c_business_group_id hr_all_organization_units.organization_id%TYPE,
395: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,
396: c_year_start date,
397: c_year_end date ) is
398: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
399: from pay_assignment_actions paa

Line 1078: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

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
1081: p_output_tab OUT NOCOPY bal_tab,
1082: p_message OUT NOCOPY VARCHAR2

Line 1460: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE

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
1463: , p_message OUT NOCOPY VARCHAR2) IS
1464: