APPS.PAY_US_REPORTING_UTILS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2328: c_tax_unit_id hr_organization_units.organization_id%type)

2324:
2325: CURSOR get_archived_values(
2326: c_user_entity_id ff_database_items.user_entity_id%type,
2327: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2328: c_tax_unit_id hr_organization_units.organization_id%type)
2329: IS
2330: SELECT target.value
2331: FROM ff_archive_item_contexts con2,
2332: ff_contexts fc2,

Line 2346: c_tax_unit_id hr_organization_units.organization_id%type,

2342:
2343: CURSOR get_jd_archived_values(
2344: c_user_entity_id ff_database_items.user_entity_id%type,
2345: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2346: c_tax_unit_id hr_organization_units.organization_id%type,
2347: c_jurisdiction_code varchar2)
2348: IS
2349: SELECT target.value
2350: FROM ff_archive_item_contexts con2,

Line 2734: from hr_organization_units o, pay_state_rules psr

2730: -- substr(replace(replace(replace(upper(o.short_name),'_'),' '),'-'),1,6)||
2731: c_state_code ||
2732: substr(to_char(fnd_date.canonical_to_date(c_mag_effective_date ), 'MMYY'),1,4) ||
2733: c_format_type
2734: from hr_organization_units o, pay_state_rules psr
2735: where o.organization_id = c_bus_group_id
2736: and psr.state_code = c_state_code;
2737:
2738: --