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.PQH_SS_PRINT dependencies on PER_PAY_PROPOSALS

Line 307: From per_pay_proposals ppp

303: FUNCTION get_salary(p_assignment_id IN per_assignments_f.assignment_type%TYPE)
304: RETURN VARCHAR2 IS
305: CURSOR salary IS
306: Select proposed_salary_n
307: From per_pay_proposals ppp
308: Where ppp.assignment_id = p_assignment_id
309: and ppp.change_date = ( select max(change_date)
310: from per_pay_proposals
311: where change_date <= g_effective_date

Line 310: from per_pay_proposals

306: Select proposed_salary_n
307: From per_pay_proposals ppp
308: Where ppp.assignment_id = p_assignment_id
309: and ppp.change_date = ( select max(change_date)
310: from per_pay_proposals
311: where change_date <= g_effective_date
312: and assignment_id =
313: p_assignment_id
314: and approved = 'Y' );

Line 315: l_salary per_pay_proposals.PROPOSED_SALARY_N%Type;

311: where change_date <= g_effective_date
312: and assignment_id =
313: p_assignment_id
314: and approved = 'Y' );
315: l_salary per_pay_proposals.PROPOSED_SALARY_N%Type;
316: BEGIN
317: IF p_assignment_id IS NOT null then
318: --
319: OPEN salary;

Line 364: FUNCTION get_change_amount(p_pay_proposal_id per_pay_proposals.pay_proposal_id%Type)

360: END;
361: --
362: --
363: --
364: FUNCTION get_change_amount(p_pay_proposal_id per_pay_proposals.pay_proposal_id%Type)
365: Return Varchar2
366: IS
367: CURSOR is_multiple_comp is
368: Select 1

Line 369: From per_pay_proposals ppp

365: Return Varchar2
366: IS
367: CURSOR is_multiple_comp is
368: Select 1
369: From per_pay_proposals ppp
370: where ppp.pay_proposal_id = p_pay_proposal_id
371: AND ppp.MULTIPLE_COMPONENTS = 'Y';
372:
373: CURSOR change_amount_cur is

Line 398: FUNCTION get_change_percent(p_pay_proposal_id per_pay_proposals.pay_proposal_id%Type)

394: END;
395: --
396: --
397: --
398: FUNCTION get_change_percent(p_pay_proposal_id per_pay_proposals.pay_proposal_id%Type)
399: Return Varchar2
400: IS
401: CURSOR is_multiple_comp is
402: Select 1

Line 403: From per_pay_proposals ppp

399: Return Varchar2
400: IS
401: CURSOR is_multiple_comp is
402: Select 1
403: From per_pay_proposals ppp
404: where ppp.pay_proposal_id = p_pay_proposal_id
405: AND ppp.MULTIPLE_COMPONENTS = 'Y';
406:
407: CURSOR change_percent_cur is