DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_BILLING_ASSIGNMENTS

Line 808: INSERT INTO pa_billing_assignments (

804:
805: -- copy task level billing assignment
806: x_err_stage := 'copying task level billing assignment ';
807:
808: INSERT INTO pa_billing_assignments (
809: BILLING_ASSIGNMENT_ID,
810: BILLING_EXTENSION_ID,
811: PROJECT_TYPE,
812: PROJECT_ID,

Line 855: pa_billing_assignments_s.nextval,

851: FUNDING_RATE_DATE,
852: FUNDING_EXCHANGE_RATE,
853: RECORD_VERSION_NUMBER)
854: select
855: pa_billing_assignments_s.nextval,
856: a.BILLING_EXTENSION_ID,
857: NULL, --for bug 3539025
858: x_new_project_id, -- bug 4189010
859: new_tsk.task_id,

Line 901: from pa_billing_assignments a,

897: a.FUNDING_RATE_TYPE,
898: a.FUNDING_RATE_DATE,
899: a.FUNDING_EXCHANGE_RATE,
900: 1
901: from pa_billing_assignments a,
902: -- pa_projects new_proj, bug 4189010
903: pa_tasks old_tsk,
904: pa_tasks new_tsk
905: where a.project_id = x_orig_project_id