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 1692: -- pa_ind_rate_sch_revisions rev,

1688: -- delete from pa_compiled_multipliers
1689: -- where ind_compiled_set_id in
1690: -- (select ics.ind_compiled_set_id
1691: -- from pa_ind_compiled_sets ics,
1692: -- pa_ind_rate_sch_revisions rev,
1693: -- pa_ind_rate_schedules sch
1694: -- where ics.ind_rate_sch_revision_id =
1695: -- rev.ind_rate_sch_revision_id
1696: -- and rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 1710: -- from pa_ind_rate_sch_revisions rev,

1706: -- x_err_stage := 'Delete compiled sets for task '|| x_task_id;
1707: -- delete from pa_ind_compiled_sets
1708: -- where ind_rate_sch_revision_id in
1709: -- (select rev.ind_rate_sch_revision_id
1710: -- from pa_ind_rate_sch_revisions rev,
1711: -- pa_ind_rate_schedules sch
1712: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id
1713: -- and sch.task_id in
1714: -- (select task_id

Line 1726: -- from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch

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

Line 1738: -- delete from pa_ind_rate_sch_revisions

1734: -- anlee
1735: -- Commenting out for performance bug 2800129
1736: -- Delete ind rate sch revisions, details of ind rate schedules
1737: -- x_err_stage := 'Delete ind rate sch revision for task '|| x_task_id;
1738: -- delete from pa_ind_rate_sch_revisions
1739: -- where ind_rate_sch_id in
1740: -- (select ind_rate_sch_id
1741: -- from pa_ind_rate_schedules
1742: -- where task_id in

Line 1768: from pa_ind_rate_sch_revisions rev

1764: ;
1765: cursor rev_cur ( l_ind_rate_sch_id IN pa_ind_rate_schedules_all_bg.ind_rate_sch_id%TYPE )
1766: is
1767: select rev.ind_rate_sch_revision_id
1768: from pa_ind_rate_sch_revisions rev
1769: where rev.ind_rate_sch_id = l_ind_rate_sch_id
1770: ;
1771: cursor ics_cur ( l_ind_rate_sch_revision_id IN pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE )
1772: is

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

1767: select rev.ind_rate_sch_revision_id
1768: from pa_ind_rate_sch_revisions rev
1769: where rev.ind_rate_sch_id = l_ind_rate_sch_id
1770: ;
1771: cursor ics_cur ( l_ind_rate_sch_revision_id IN pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE )
1772: is
1773: select ics.ind_compiled_set_id
1774: from pa_ind_compiled_sets ics
1775: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id

Line 1887: from pa_ind_rate_sch_revisions rev

1883: where icm.ind_rate_sch_revision_id = l_ind_rate_sch_rev_id_tab(i)
1884: ;
1885: forall i in l_ind_rate_sch_rev_id_tab.first .. l_ind_rate_sch_rev_id_tab.last
1886: delete
1887: from pa_ind_rate_sch_revisions rev
1888: where rev.ind_rate_sch_revision_id = l_ind_rate_sch_rev_id_tab(i)
1889: ;
1890: end if;
1891: