APPS.PA_PROJECT_CORE dependencies on PA_IND_RATE_SCHEDULES

Line 504: pa_ind_rate_schedules sch

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
508: and sch.project_id = x_project_id);

Line 515: pa_ind_rate_schedules sch

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:
519: -- Delete ind cost multipliers, details of ind rate sch revisions

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 531: from pa_ind_rate_schedules

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 );
533:
534: -- Delete ind rate schedules
535: delete from pa_ind_rate_schedules

Line 535: delete from pa_ind_rate_schedules

531: from pa_ind_rate_schedules
532: where project_id = x_project_id );
533:
534: -- Delete ind rate schedules
535: delete from pa_ind_rate_schedules
536: where project_id = x_project_id;
537:
538: -- Delete project asset assigments
539: delete from pa_project_asset_assignments

Line 1709: -- pa_ind_rate_schedules sch

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
1713: -- and sch.task_id in

Line 1727: -- pa_ind_rate_schedules sch

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
1731: -- from pa_tasks

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 1757: -- from pa_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
1759: -- (select task_id
1760: -- from pa_tasks
1761: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1778: from pa_ind_rate_schedules sch

1774: ;
1775: cursor sch_cur ( l_task_id IN pa_tasks.task_id%TYPE )
1776: is
1777: select sch.ind_rate_sch_id
1778: from pa_ind_rate_schedules sch
1779: where sch.task_id = l_task_id
1780: ;
1781: cursor rev_cur ( l_ind_rate_sch_id IN pa_ind_rate_schedules_all_bg.ind_rate_sch_id%TYPE )
1782: is

Line 1781: cursor rev_cur ( l_ind_rate_sch_id IN pa_ind_rate_schedules_all_bg.ind_rate_sch_id%TYPE )

1777: select sch.ind_rate_sch_id
1778: from pa_ind_rate_schedules sch
1779: where sch.task_id = l_task_id
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

Line 1914: from pa_ind_rate_schedules sch

1910: if ( l_ind_rate_sch_id_tab.count > 0 )
1911: then
1912: forall i in l_ind_rate_sch_id_tab.first .. l_ind_rate_sch_id_tab.last
1913: delete
1914: from pa_ind_rate_schedules sch
1915: where sch.ind_rate_sch_id = l_ind_rate_sch_id_tab(i)
1916: ;
1917: end if;
1918: