APPS.GMS_BUDGET_CORE dependencies on GMS_RESOURCE_ASSIGNMENTS_S

Line 1508: select gms_resource_assignments_s.nextval,

1504: created_by,
1505: last_update_login,
1506: unit_of_measure,
1507: track_as_labor_flag)
1508: select gms_resource_assignments_s.nextval,
1509: x_dest_version_id,
1510: dt.project_id,
1511: dt.task_id,
1512: sa.resource_list_member_id,

Line 1521: gms_resource_assignments sa,

1517: x_last_update_login,
1518: sa.unit_of_measure,
1519: sa.track_as_labor_flag
1520: from
1521: gms_resource_assignments sa,
1522: pa_tasks st,
1523: pa_tasks dt,
1524: gms_budget_versions dv
1525: where sa.budget_version_id = x_src_version_id

Line 1547: select gms_resource_assignments_s.nextval,

1543: created_by,
1544: last_update_login,
1545: unit_of_measure,
1546: track_as_labor_flag)
1547: select gms_resource_assignments_s.nextval,
1548: x_dest_version_id,
1549: dv.project_id,
1550: 0,
1551: sa.resource_list_member_id,

Line 1560: gms_resource_assignments sa,

1556: x_last_update_login,
1557: sa.unit_of_measure,
1558: sa.track_as_labor_flag
1559: from
1560: gms_resource_assignments sa,
1561: gms_budget_versions dv
1562: where sa.budget_version_id = x_src_version_id
1563: and sa.task_id = 0
1564: and dv.budget_version_id = x_dest_version_id;

Line 1723: gms_resource_assignments sa,

1719: 'B',
1720: 'B',
1721: 'B'
1722: from gms_budget_lines l,
1723: gms_resource_assignments sa,
1724: pa_tasks st,
1725: pa_tasks dt,
1726: gms_resource_assignments da
1727: where l.resource_assignment_id =

Line 1820: gms_resource_assignments sa,

1816: 'B',
1817: 'B',
1818: 'B'
1819: from gms_budget_lines l,
1820: gms_resource_assignments sa,
1821: gms_resource_assignments da
1822: where l.resource_assignment_id =
1823: budget_line_row.resource_assignment_id
1824: and l.start_date = budget_line_row.start_date

Line 3284: select gms_resource_assignments_s.nextval,

3280: created_by,
3281: last_update_login,
3282: unit_of_measure,
3283: track_as_labor_flag)
3284: select gms_resource_assignments_s.nextval,
3285: x_dest_version_id,
3286: s.project_id,
3287: s.task_id,
3288: s.resource_list_member_id,

Line 3297: gms_resource_assignments s

3293: x_last_update_login,
3294: s.unit_of_measure,
3295: s.track_as_labor_flag
3296: from
3297: gms_resource_assignments s
3298: where s.budget_version_id = x_src_version_id;
3299:
3300:
3301: x_err_stage := 'copy budget lines <' ||to_char(x_src_version_id)

Line 3386: gms_resource_assignments sa,

3382: 'B',
3383: 'B',
3384: 'B'
3385: from gms_budget_lines l,
3386: gms_resource_assignments sa,
3387: gms_resource_assignments da
3388: where l.resource_assignment_id = sa.resource_assignment_id
3389: and sa.budget_version_id = x_src_version_id
3390: and sa.task_id = da.task_id