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.PQP_TIAALOD_PKG dependencies on HR_ORGANIZATION_UNITS

Line 12: l_tax_unit_id hr_organization_units.organization_id%TYPE;

8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;
16: l_location_id hr_locations.location_id%TYPE;

Line 13: l_gre_name hr_organization_units.name%TYPE;

9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;
16: l_location_id hr_locations.location_id%TYPE;
17: l_location_code hr_locations.location_code%TYPE;

Line 14: l_organization_id hr_organization_units.organization_id%TYPE;

10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;
16: l_location_id hr_locations.location_id%TYPE;
17: l_location_code hr_locations.location_code%TYPE;
18: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 15: l_org_name hr_organization_units.name%TYPE;

11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;
16: l_location_id hr_locations.location_id%TYPE;
17: l_location_code hr_locations.location_code%TYPE;
18: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
19: l_bal_value NUMBER(11,2);

Line 69: gre_name hr_organization_units.name%TYPE,

65: national_id per_all_people_f.national_identifier%TYPE,
66: asg_ppg_code per_assignment_extra_info.aei_information1%TYPE,
67: org_ppg hr_organization_information.org_information1%TYPE,
68: pay_mode pay_payrolls_f.prl_information4%TYPE,
69: gre_name hr_organization_units.name%TYPE,
70: org_name hr_organization_units.name%TYPE,
71: effective_date DATE,
72: ppg_billing pay_payrolls_f.prl_information7%TYPE,
73:

Line 70: org_name hr_organization_units.name%TYPE,

66: asg_ppg_code per_assignment_extra_info.aei_information1%TYPE,
67: org_ppg hr_organization_information.org_information1%TYPE,
68: pay_mode pay_payrolls_f.prl_information4%TYPE,
69: gre_name hr_organization_units.name%TYPE,
70: org_name hr_organization_units.name%TYPE,
71: effective_date DATE,
72: ppg_billing pay_payrolls_f.prl_information7%TYPE,
73:
74: balance_name1 pay_balance_types.balance_name%TYPE,

Line 726: ltaxunit_id hr_organization_units.organization_id%TYPE := NULL;

722: SELECT org_information1
723: FROM hr_organization_information
724: WHERE org_information_context = 'PQP_US_TIAA_CREF_CODES'
725: AND organization_id = p_tax_unit_id;
726: ltaxunit_id hr_organization_units.organization_id%TYPE := NULL;
727: BEGIN
728: l_org_ppg:='';
729: FOR i IN 1..org_ppg_t.count
730: LOOP

Line 779: hr_organization_units hox,

775: hrl.location_code location_code,
776: paa.assignment_action_id assignment_action_id,
777: ppa.payroll_id pay_payroll_id
778: FROM hr_locations_all hrl,
779: hr_organization_units hox,
780: hr_organization_units hou,
781: per_assignments_f paf,
782: pay_payroll_actions ppa,
783: pay_assignment_actions paa,

Line 780: hr_organization_units hou,

776: paa.assignment_action_id assignment_action_id,
777: ppa.payroll_id pay_payroll_id
778: FROM hr_locations_all hrl,
779: hr_organization_units hox,
780: hr_organization_units hou,
781: per_assignments_f paf,
782: pay_payroll_actions ppa,
783: pay_assignment_actions paa,
784: pay_action_interlocks pai,