DBA Data[Home] [Help]

APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_PROJECTS_ALL

Line 528: pa_projects_all pa,

524: pa.segment1||'-'||to_char(dr.draft_revenue_num) transaction_number
525: from pa_draft_revenues_all dr,
526: pa_implementations_all imp,
527: pa_xla_upg_ctrl gl,
528: pa_projects_all pa,
529: hr_organization_information hr/*Added for 4920063 */
530: where dr.rowid >= p_start_rowid
531: and dr.rowid <= p_end_rowid
532: and dr.TRANSFER_STATUS_CODE ='A'

Line 1217: pa_projects_all pa,

1213: pa_implementations_all imp,
1214: pa_mc_draft_revs_all mc,
1215: XLA_EVENTS evt,
1216: pa_xla_upg_ctrl gl,
1217: pa_projects_all pa,
1218: hr_organization_information hr
1219: where mc.rowid >= p_start_rowid
1220: and mc.rowid <= p_end_rowid
1221: and dr.project_id = mc.project_id