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 1218: pa_projects_all pa,

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