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.PAY_KR_DIM_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 410: from per_periods_of_service pps,

406: l_hire_date date;
407: l_expiry_date date;
408: cursor csr_hire_date is
409: select pps.date_start
410: from per_periods_of_service pps,
411: per_assignments_f pa,
412: pay_assignment_actions paa
413: where paa.assignment_action_id = p_owner_assignment_action_id
414: and pa.assignment_id = paa.assignment_id

Line 441: from per_periods_of_service ppos,

437: --------------------------------------------------------------------------
438: is
439: cursor csr_start_date is
440: select ppos.date_start
441: from per_periods_of_service ppos,
442: pay_assignment_actions pac,
443: per_assignments_f pa
444: Where pac.assignment_action_id = p_asg_action
445: and pac.assignment_id = pa.assignment_id

Line 473: from per_periods_of_service pps,

469: is
470: l_hire_date date;
471: cursor csr_hire_date is
472: select pps.date_start
473: from per_periods_of_service pps,
474: per_assignments_f pa,
475: pay_assignment_actions paa
476: where paa.assignment_action_id = p_owner_assignment_action_id
477: and pa.assignment_id = paa.assignment_id