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_EXPREPLOD_PKG dependencies on HR_ORGANIZATION_UNITS

Line 19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;

15: l_effective_date pay_payroll_actions.effective_date%TYPE ;
16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
20: l_gre_name hr_organization_units.name%TYPE ;
21: l_organization_id hr_organization_units.organization_id%TYPE ;
22: l_org_name hr_organization_units.name%TYPE ;
23: l_location_id hr_locations.location_id%TYPE ;

Line 20: l_gre_name hr_organization_units.name%TYPE ;

16: l_action_type pay_payroll_actions.action_type%TYPE ;
17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
20: l_gre_name hr_organization_units.name%TYPE ;
21: l_organization_id hr_organization_units.organization_id%TYPE ;
22: l_org_name hr_organization_units.name%TYPE ;
23: l_location_id hr_locations.location_id%TYPE ;
24: l_location_code hr_locations.location_code%TYPE ;

Line 21: l_organization_id hr_organization_units.organization_id%TYPE ;

17: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
20: l_gre_name hr_organization_units.name%TYPE ;
21: l_organization_id hr_organization_units.organization_id%TYPE ;
22: l_org_name hr_organization_units.name%TYPE ;
23: l_location_id hr_locations.location_id%TYPE ;
24: l_location_code hr_locations.location_code%TYPE ;
25: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;

Line 22: l_org_name hr_organization_units.name%TYPE ;

18: l_assignment_id pay_assignment_actions.assignment_id%TYPE ;
19: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
20: l_gre_name hr_organization_units.name%TYPE ;
21: l_organization_id hr_organization_units.organization_id%TYPE ;
22: l_org_name hr_organization_units.name%TYPE ;
23: l_location_id hr_locations.location_id%TYPE ;
24: l_location_code hr_locations.location_code%TYPE ;
25: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
26: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;

Line 206: l_orgname hr_organization_units.name%TYPE;

202: RETURN NUMBER
203:
204: IS
205: l_ret_value NUMBER;
206: l_orgname hr_organization_units.name%TYPE;
207: CURSOR c_get_bal_dim IS
208: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_'),
209: INSTR(DATABASE_ITEM_SUFFIX,'_LE_')
210: FROM pay_balance_dimensions where balance_dimension_id =

Line 217: FROM hr_organization_units hou

213: WHERE defined_balance_id =p_defined_balance_id
214: );
215: CURSOR c_grename IS
216: SELECT hou.name
217: FROM hr_organization_units hou
218: WHERE organization_id=(SELECT segment1
219: FROM hr_soft_coding_keyflex
220: WHERE soft_coding_keyflex_id =
221: (SELECT soft_coding_keyflex_id

Line 1018: hr_organization_units hou1,

1014: paf.location_id location_id,
1015: paa.chunk_number chnkno,
1016: paa.payroll_action_id pactid
1017: FROM
1018: hr_organization_units hou1,
1019: per_assignments_f paf,
1020: pay_payroll_actions ppa,
1021: pay_assignment_actions paa1,
1022: pay_action_interlocks pai,