DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 12878: from pay_element_entries_f

12874: where bus.business_group_id = l_business_group_id;
12875: --
12876: cursor csr_get_salary is
12877: select element_entry_id
12878: from pay_element_entries_f
12879: where assignment_id = p_assignment_id
12880: and creator_type = 'SP'
12881: and l_validation_start_date between
12882: effective_start_date and effective_end_date;

Line 15988: from pay_element_entries_f

15984: where bus.business_group_id = l_business_group_id;
15985: --
15986: cursor csr_get_salary is
15987: select element_entry_id
15988: from pay_element_entries_f
15989: where assignment_id = p_assignment_id
15990: and creator_type = 'SP'
15991: and l_validation_start_date between
15992: effective_start_date and effective_end_date;

Line 15997: from pay_element_entries_f

15993:
15994: -- start of fix for bug 4464072
15995: cursor csr_chk_rec_exists is
15996: select element_entry_id
15997: from pay_element_entries_f
15998: where assignment_id = p_assignment_id
15999: and creator_type = 'SP'
16000: and element_entry_id = l_element_entry_id -- added for Bug14373426
16001: and (l_validation_start_date - 1) between