DBA Data[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_USER_COLUMNS_TL

Line 459: , pay_user_columns_tl puc

455:
456: cursor csr_get_legal_entity (p_csr_user_row_id number) is
457: select distinct substr(puc.user_column_name,1, instr(puc.user_column_name,'_')-1) organization_id
458: from pay_user_column_instances_f puci
459: , pay_user_columns_tl puc
460: where puci.user_row_id = p_csr_user_row_id
461: and puc.user_column_id = puci.user_column_id
462: and p_effective_date between puci.effective_start_date and puci.effective_end_date;
463: