APPS.PA_BILL_REV_XLA_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 529: hr_organization_information hr/*Added for 4920063 */

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'
533: and dr.event_id is null

Line 1219: hr_organization_information hr

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
1223: and dr.draft_revenue_num = mc.draft_revenue_num