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

Line 16074: from per_pay_proposals

16070: l_proposal_reason varchar2(240) := NULL;
16071:
16072: cursor csr_pay_proposal_exists is
16073: select pay_proposal_id
16074: from per_pay_proposals
16075: where assignment_id = p_assignment_id
16076: and change_date = p_effective_date; */
16077: -- End changes for bug 12911607
16078: /* commented the code for Bug#14248434 */

Line 16094: from per_pay_proposals

16090: l_proposal_reason varchar2(240) := NULL;
16091:
16092: cursor csr_pay_proposal_exists is
16093: select pay_proposal_id
16094: from per_pay_proposals
16095: where assignment_id = p_assignment_id
16096: and change_date = p_effective_date;
16097:
16098: cursor future_pay_proposals is

Line 16100: from per_pay_proposals

16096: and change_date = p_effective_date;
16097:
16098: cursor future_pay_proposals is
16099: select 'exist'
16100: from per_pay_proposals
16101: where assignment_id = p_assignment_id
16102: and change_date >= p_effective_date;
16103:
16104: -- End changes for bug 12911607