DBA Data[Home] [Help]

APPS.PA_GL_REV_XFER_AUDIT_PKG dependencies on PA_EVENTS

Line 89: pa_events pe,

85: to_number(null) ,
86: rdl.amount
87: FROM
88: pa_cust_event_rdl_all rdl,
89: pa_events pe,
90: pa_draft_revenues pdr,
91: gl_code_combinations cc,
92: xla_ae_lines ael,
93: xla_ae_headers aeh,

Line 962: FROM pa_events pe

958:
959:
960: UPDATE pa_gl_rev_xfer_audit_rep a
961: SET (transaction_type,transaction_date) = ( SELECT event_type,completion_date
962: FROM pa_events pe
963: WHERE a.project_id = pe.project_id
964: AND NVL(a.task_id,-1) = NVL(pe.task_id,-1)
965: AND a.rdl_event_num = pe.event_num)
966: WHERE line_type = 'ERDL'