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.PER_ASSIGNMENTS_F3_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 503: from pay_element_entries_f

499:
500: -- fix for bug 4531033 starts here
501: cursor csr_get_salary is
502: select element_entry_id
503: from pay_element_entries_f
504: where assignment_id = p_ass_id
505: and creator_type = 'SP'
506: and l_val_start_date between
507: effective_start_date and effective_end_date;

Line 511: from pay_element_entries_f

507: effective_start_date and effective_end_date;
508:
509: cursor csr_chk_rec_exists is
510: select element_entry_id
511: from pay_element_entries_f
512: where assignment_id = p_ass_id
513: and creator_type = 'SP'
514: and (l_val_start_date - 1) between
515: effective_start_date and effective_end_date;

Line 571: pay_element_entries_f ele,

567:
568: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
569: Select ele.element_entry_id
570: from per_pay_bases bas,
571: pay_element_entries_f ele,
572: pay_element_entry_values_f entval
573: where bas.pay_basis_id = P_pay_basis_id
574: and entval.input_value_id = bas.input_value_id
575: and p_effective_date