DBA Data[Home] [Help]

APPS.PQP_USTIAA_PKG dependencies on PAY_PAYWSMEE_PKG

Line 863: and NVL(pay_paywsmee_pkg.PROCESSED(ee.element_entry_id,ee.original_entry_id,e.processing_type,ee.entry_type,ppa_run.date_earned),'N')='Y'

859: and ei.element_type_id = e.element_type_id
860: and ei.information_type = 'US_TIAA_CREF_CONT_TYPES'
861: and ppa_run.effective_date between e.effective_start_date and e.effective_end_date
862: -- Condition added as part of the Bug: 11869238
863: and NVL(pay_paywsmee_pkg.PROCESSED(ee.element_entry_id,ee.original_entry_id,e.processing_type,ee.entry_type,ppa_run.date_earned),'N')='Y'
864: -- and ppa_run.effective_date between ee.effective_start_date and ee.effective_end_date
865: );
866:
867: CURSOR csr_get_ele_entries(p_asgact_id NUMBER,