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 1693: -- pa_ind_rate_schedules sch

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

Line 1711: -- pa_ind_rate_schedules sch

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

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 1741: -- from pa_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
1743: -- (select task_id
1744: -- from pa_tasks
1745: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1762: from pa_ind_rate_schedules sch

1758: ;
1759: cursor sch_cur ( l_task_id IN pa_tasks.task_id%TYPE )
1760: is
1761: select sch.ind_rate_sch_id
1762: from pa_ind_rate_schedules sch
1763: where sch.task_id = l_task_id
1764: ;
1765: cursor rev_cur ( l_ind_rate_sch_id IN pa_ind_rate_schedules_all_bg.ind_rate_sch_id%TYPE )
1766: is

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

1761: select sch.ind_rate_sch_id
1762: from pa_ind_rate_schedules sch
1763: where sch.task_id = l_task_id
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

Line 1898: from pa_ind_rate_schedules sch

1894: if ( l_ind_rate_sch_id_tab.count > 0 )
1895: then
1896: forall i in l_ind_rate_sch_id_tab.first .. l_ind_rate_sch_id_tab.last
1897: delete
1898: from pa_ind_rate_schedules sch
1899: where sch.ind_rate_sch_id = l_ind_rate_sch_id_tab(i)
1900: ;
1901: end if;
1902: