DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 12277: from pay_element_entries_f

12273: where bus.business_group_id = l_business_group_id;
12274: --
12275: cursor csr_get_salary is
12276: select element_entry_id
12277: from pay_element_entries_f
12278: where assignment_id = p_assignment_id
12279: and creator_type = 'SP'
12280: and l_validation_start_date between
12281: effective_start_date and effective_end_date;

Line 15386: from pay_element_entries_f

15382: where bus.business_group_id = l_business_group_id;
15383: --
15384: cursor csr_get_salary is
15385: select element_entry_id
15386: from pay_element_entries_f
15387: where assignment_id = p_assignment_id
15388: and creator_type = 'SP'
15389: and l_validation_start_date between
15390: effective_start_date and effective_end_date;

Line 15395: from pay_element_entries_f

15391:
15392: -- start of fix for bug 4464072
15393: cursor csr_chk_rec_exists is
15394: select element_entry_id
15395: from pay_element_entries_f
15396: where assignment_id = p_assignment_id
15397: and creator_type = 'SP'
15398: and (l_validation_start_date - 1) between
15399: effective_start_date and effective_end_date;