DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F3_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 500: from pay_element_entries_f

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

Line 508: from pay_element_entries_f

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