eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_CORE dependencies on PA_IND_RATE_SCH_REVISIONS

Line 503: pa_ind_rate_sch_revisions rev,

499: delete from pa_compiled_multipliers
500: where ind_compiled_set_id in
501: (select ics.ind_compiled_set_id
502: from pa_ind_compiled_sets ics,
503: pa_ind_rate_sch_revisions rev,
504: pa_ind_rate_schedules sch
505: where ics.ind_rate_sch_revision_id =
506: rev.ind_rate_sch_revision_id
507: and rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 514: from pa_ind_rate_sch_revisions rev,

510: -- Delete compiled compiled set
511: delete from pa_ind_compiled_sets
512: where ind_rate_sch_revision_id in
513: (select rev.ind_rate_sch_revision_id
514: from pa_ind_rate_sch_revisions rev,
515: pa_ind_rate_schedules sch
516: where rev.ind_rate_sch_id = sch.ind_rate_sch_id
517: and sch.project_id = x_project_id);
518:

Line 523: from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch

519: -- Delete ind cost multipliers, details of ind rate sch revisions
520: delete from pa_ind_cost_multipliers
521: where ind_rate_sch_revision_id in
522: (select rev.ind_rate_sch_revision_id
523: from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch
524: where rev.ind_rate_sch_id = sch.ind_rate_sch_id
525: and sch.project_id = x_project_id);
526:
527: -- Delete ind rate sch revisions, details of ind rate schedules

Line 528: delete from pa_ind_rate_sch_revisions

524: where rev.ind_rate_sch_id = sch.ind_rate_sch_id
525: and sch.project_id = x_project_id);
526:
527: -- Delete ind rate sch revisions, details of ind rate schedules
528: delete from pa_ind_rate_sch_revisions
529: where ind_rate_sch_id in
530: (select ind_rate_sch_id
531: from pa_ind_rate_schedules
532: where project_id = x_project_id );

Line 1708: -- pa_ind_rate_sch_revisions rev,

1704: -- delete from pa_compiled_multipliers
1705: -- where ind_compiled_set_id in
1706: -- (select ics.ind_compiled_set_id
1707: -- from pa_ind_compiled_sets ics,
1708: -- pa_ind_rate_sch_revisions rev,
1709: -- pa_ind_rate_schedules sch
1710: -- where ics.ind_rate_sch_revision_id =
1711: -- rev.ind_rate_sch_revision_id
1712: -- and rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 1726: -- from pa_ind_rate_sch_revisions rev,

1722: -- x_err_stage := 'Delete compiled sets for task '|| x_task_id;
1723: -- delete from pa_ind_compiled_sets
1724: -- where ind_rate_sch_revision_id in
1725: -- (select rev.ind_rate_sch_revision_id
1726: -- from pa_ind_rate_sch_revisions rev,
1727: -- pa_ind_rate_schedules sch
1728: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id
1729: -- and sch.task_id in
1730: -- (select task_id

Line 1742: -- from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch

1738: -- x_err_stage := 'Delete ind cost multiplier for task '|| x_task_id;
1739: -- delete from pa_ind_cost_multipliers
1740: -- where ind_rate_sch_revision_id in
1741: -- (select rev.ind_rate_sch_revision_id
1742: -- from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch
1743: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id
1744: -- and sch.task_id in
1745: -- (select task_id
1746: -- from pa_tasks

Line 1754: -- delete from pa_ind_rate_sch_revisions

1750: -- anlee
1751: -- Commenting out for performance bug 2800129
1752: -- Delete ind rate sch revisions, details of ind rate schedules
1753: -- x_err_stage := 'Delete ind rate sch revision for task '|| x_task_id;
1754: -- delete from pa_ind_rate_sch_revisions
1755: -- where ind_rate_sch_id in
1756: -- (select ind_rate_sch_id
1757: -- from pa_ind_rate_schedules
1758: -- where task_id in

Line 1784: from pa_ind_rate_sch_revisions rev

1780: ;
1781: cursor rev_cur ( l_ind_rate_sch_id IN pa_ind_rate_schedules_all_bg.ind_rate_sch_id%TYPE )
1782: is
1783: select rev.ind_rate_sch_revision_id
1784: from pa_ind_rate_sch_revisions rev
1785: where rev.ind_rate_sch_id = l_ind_rate_sch_id
1786: ;
1787: cursor ics_cur ( l_ind_rate_sch_revision_id IN pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE )
1788: is

Line 1787: cursor ics_cur ( l_ind_rate_sch_revision_id IN pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE )

1783: select rev.ind_rate_sch_revision_id
1784: from pa_ind_rate_sch_revisions rev
1785: where rev.ind_rate_sch_id = l_ind_rate_sch_id
1786: ;
1787: cursor ics_cur ( l_ind_rate_sch_revision_id IN pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE )
1788: is
1789: select ics.ind_compiled_set_id
1790: from pa_ind_compiled_sets ics
1791: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id

Line 1903: from pa_ind_rate_sch_revisions rev

1899: where icm.ind_rate_sch_revision_id = l_ind_rate_sch_rev_id_tab(i)
1900: ;
1901: forall i in l_ind_rate_sch_rev_id_tab.first .. l_ind_rate_sch_rev_id_tab.last
1902: delete
1903: from pa_ind_rate_sch_revisions rev
1904: where rev.ind_rate_sch_revision_id = l_ind_rate_sch_rev_id_tab(i)
1905: ;
1906: end if;
1907: