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_SOFT_CODING_KEYFLEX

Line 222: FROM hr_soft_coding_keyflex

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
225: FROM per_all_assignments_f
226: WHERE assignment_id=p_assignment_id

Line 313: FROM hr_soft_coding_keyflex hsck, per_all_assignments_f paaf

309:
310: ELSIF (l_instr_count3 > 0 AND l_supported_loc = 'N') THEN
311: hr_utility.trace('Entered IP Tax Unit case');
312: SELECT hsck.segment1 INTO l_tax_unit
313: FROM hr_soft_coding_keyflex hsck, per_all_assignments_f paaf
314: WHERE paaf.assignment_id = p_assignment_id
315: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
316: AND sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
317:

Line 374: FROM hr_soft_coding_keyflex hsck,

370: WHERE r.user_row_id = g_component_code;
371:
372: CURSOR c_tax_unit_id IS
373: SELECT segment1,segment11,segment12
374: FROM hr_soft_coding_keyflex hsck,
375: per_all_assignments_f paaf
376: WHERE paaf.assignment_id = p_assignment_id
377: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
378: AND p_paydate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;

Line 381: l_segment1 hr_soft_coding_keyflex.segment1%type;

377: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
378: AND p_paydate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
379:
380: l_instr_count NUMBER :=0;
381: l_segment1 hr_soft_coding_keyflex.segment1%type;
382: l_segment11 hr_soft_coding_keyflex.segment11%type;
383: l_segment12 hr_soft_coding_keyflex.segment12%type;
384: l_component_name VARCHAR2(80);
385: l_tax_unit NUMBER;

Line 382: l_segment11 hr_soft_coding_keyflex.segment11%type;

378: AND p_paydate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
379:
380: l_instr_count NUMBER :=0;
381: l_segment1 hr_soft_coding_keyflex.segment1%type;
382: l_segment11 hr_soft_coding_keyflex.segment11%type;
383: l_segment12 hr_soft_coding_keyflex.segment12%type;
384: l_component_name VARCHAR2(80);
385: l_tax_unit NUMBER;
386: l_supported_loc VARCHAR2(1);

Line 383: l_segment12 hr_soft_coding_keyflex.segment12%type;

379:
380: l_instr_count NUMBER :=0;
381: l_segment1 hr_soft_coding_keyflex.segment1%type;
382: l_segment11 hr_soft_coding_keyflex.segment11%type;
383: l_segment12 hr_soft_coding_keyflex.segment12%type;
384: l_component_name VARCHAR2(80);
385: l_tax_unit NUMBER;
386: l_supported_loc VARCHAR2(1);
387: