DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_BILLING_ASSIGNMENTS

Line 751: INSERT INTO pa_billing_assignments (

747:
748: -- copy task level billing assignment
749: x_err_stage := 'copying task level billing assignment ';
750:
751: INSERT INTO pa_billing_assignments (
752: BILLING_ASSIGNMENT_ID,
753: BILLING_EXTENSION_ID,
754: PROJECT_TYPE,
755: PROJECT_ID,

Line 798: pa_billing_assignments_s.nextval,

794: FUNDING_RATE_DATE,
795: FUNDING_EXCHANGE_RATE,
796: RECORD_VERSION_NUMBER)
797: select
798: pa_billing_assignments_s.nextval,
799: a.BILLING_EXTENSION_ID,
800: NULL, --for bug 3539025
801: x_new_project_id, -- bug 4189010
802: new_tsk.task_id,

Line 844: from pa_billing_assignments a,

840: a.FUNDING_RATE_TYPE,
841: a.FUNDING_RATE_DATE,
842: a.FUNDING_EXCHANGE_RATE,
843: 1
844: from pa_billing_assignments a,
845: -- pa_projects new_proj, bug 4189010
846: pa_tasks old_tsk,
847: pa_tasks new_tsk
848: where a.project_id = x_orig_project_id