DBA Data[Home] [Help]

APPS.PQP_LOG_ALIEN_DATA_CHANGES dependencies on PQP_ANALYZED_ALIEN_DATA

Line 104: ,pqp_analyzed_alien_data pad

100: ,cp_effective_date DATE
101: ,cp_inc_code VARCHAR2) IS
102: SELECT 'X'
103: FROM pqp_analyzed_alien_details paad
104: ,pqp_analyzed_alien_data pad
105: where pad.analyzed_data_id=paad.analyzed_data_id
106: and pad.tax_year=to_number(to_char(cp_effective_date,'YYYY'))
107: and pad.assignment_id=cp_assignment_id
108: and pad.data_source='PQP_US_ALIEN_WINDSTAR'