DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 6871: PAY_ELEMENT_CLASSIFICATIONS pc

6867: FROM PAY_ELEMENT_ENTRIES_F pee,
6868: PAY_ELEMENT_LINKS_F pel,
6869: PAY_ELEMENT_TYPES_F pet,
6870: PER_ASSIGNMENTS_F pa,
6871: PAY_ELEMENT_CLASSIFICATIONS pc
6872: WHERE pee.assignment_id = p_assignment_id
6873: AND pa.assignment_id = p_assignment_id
6874: AND pee.effective_end_date >= pa.effective_start_date
6875: AND pee.effective_start_date <= pa.effective_end_date