APPS.PAY_US_SIMULATION dependencies on HR_ALL_ORGANIZATION_UNITS

Line 60: FROM hr_all_organization_units org,

56:
57: CURSOR get_employer_name_phone ( cp_organization_id NUMBER)
58: IS
59: SELECT org.name,loc.telephone_number_1
60: FROM hr_all_organization_units org,
61: hr_locations_all loc
62: WHERE org.location_id=loc.location_id
63: AND org.organization_id = cp_organization_id;
64:

Line 68: ln_tax_unit_id hr_all_organization_units.organization_id%TYPE;

64:
65: lv_procedure_name VARCHAR2(100) := '.add_custom_xml';
66:
67: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
68: ln_tax_unit_id hr_all_organization_units.organization_id%TYPE;
69: ld_effective_date DATE;
70: ln_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
71: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
72: ln_organization_id hr_all_organization_units.organization_id%TYPE;

Line 72: ln_organization_id hr_all_organization_units.organization_id%TYPE;

68: ln_tax_unit_id hr_all_organization_units.organization_id%TYPE;
69: ld_effective_date DATE;
70: ln_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
71: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
72: ln_organization_id hr_all_organization_units.organization_id%TYPE;
73:
74: lv_employer_address1 pay_action_information.action_information1%TYPE;
75: lv_employer_address2 pay_action_information.action_information1%TYPE;
76: lv_employer_address3 pay_action_information.action_information1%TYPE;

Line 82: lv_employer_name hr_all_organization_units.name%TYPE;

78: lv_employer_state pay_action_information.action_information1%TYPE;
79: lv_employer_zip_code pay_action_information.action_information1%TYPE;
80: lv_employer_country pay_action_information.action_information1%TYPE;
81:
82: lv_employer_name hr_all_organization_units.name%TYPE;
83: lv_phone_number hr_locations_all.telephone_number_1%TYPE;
84:
85: ln_net_pay_ytd NUMBER;
86: ln_amount NUMBER;