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.

[Home] [Help]

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 207: l_orgname hr_organization_units.name%TYPE;

203: RETURN NUMBER
204:
205: IS
206: l_ret_value NUMBER;
207: l_orgname hr_organization_units.name%TYPE;
208: CURSOR c_get_bal_dim IS
209: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_'),
210: INSTR(DATABASE_ITEM_SUFFIX,'_LE_') ,
211: INSTR(DATABASE_ITEM_SUFFIX,'_COMP_'),

Line 220: FROM hr_organization_units hou

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

Line 358: l_orgname hr_organization_units.name%TYPE;

354: l_ret_value1 NUMBER := 0;
355: l_ret_value11 NUMBER := 0;
356: l_ret_value12 NUMBER := 0;
357: l_total_value NUMBER := 0;
358: l_orgname hr_organization_units.name%TYPE;
359: CURSOR c_get_bal_dim IS
360: SELECT INSTR(DATABASE_ITEM_SUFFIX,'_GRE_')
361: FROM pay_balance_dimensions where balance_dimension_id =
362: (SELECT balance_dimension_id

Line 1196: hr_organization_units hou1,

1192: paf.location_id location_id,
1193: paa.chunk_number chnkno,
1194: paa.payroll_action_id pactid
1195: FROM
1196: hr_organization_units hou1,
1197: per_assignments_f paf,
1198: pay_payroll_actions ppa,
1199: pay_assignment_actions paa1,
1200: pay_action_interlocks pai,