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

Line 588: select pay_proposal_id from per_pay_proposals where assignment_id=p_assignment_id and

584: select pay_transaction_id from per_pay_transactions where
585: item_type=p_item_type and item_key=p_item_key and status='NEW';
586:
587: cursor proposals_id is
588: select pay_proposal_id from per_pay_proposals where assignment_id=p_assignment_id and
589: P_Effective_Date between change_date and date_to;
590:
591: message VARCHAR2(10000) := '';
592: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;

Line 595: pay_prop_id per_pay_proposals.pay_proposal_id%type;

591: message VARCHAR2(10000) := '';
592: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
593: l_old_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
594: pay_txn_id per_pay_transactions.pay_transaction_id%type;
595: pay_prop_id per_pay_proposals.pay_proposal_id%type;
596:
597: begin
598: l_pay_basis_id := p_pay_basis_id;
599: l_old_pay_basis_id := p_old_pay_basis_id;