APPS.PA_MULTI_ORG dependencies on PA_BILLING_ASSIGNMENTS

Line 61: x_stage := 'INSERT INTO PA_BILLING_ASSIGNMENTS';

57:
58: l_rec_count := l_rec_count + SQL%ROWCOUNT;
59:
60: -- Copy Billing Assignments
61: x_stage := 'INSERT INTO PA_BILLING_ASSIGNMENTS';
62: INSERT INTO pa_billing_assignments(
63: billing_assignment_id
64: , billing_extension_id
65: , project_type

Line 62: INSERT INTO pa_billing_assignments(

58: l_rec_count := l_rec_count + SQL%ROWCOUNT;
59:
60: -- Copy Billing Assignments
61: x_stage := 'INSERT INTO PA_BILLING_ASSIGNMENTS';
62: INSERT INTO pa_billing_assignments(
63: billing_assignment_id
64: , billing_extension_id
65: , project_type
66: , project_id

Line 79: pa_billing_assignments_s.NEXTVAL

75: , last_update_login
76: , distribution_rule
77: , org_id )
78: SELECT
79: pa_billing_assignments_s.NEXTVAL
80: , ba.billing_extension_id
81: , ba.project_type
82: , ba.project_id
83: , ba.top_task_id

Line 94: FROM pa_billing_assignments_all ba

90: , x_user
91: , x_login
92: , ba.distribution_rule
93: , x_org_id
94: FROM pa_billing_assignments_all ba
95: WHERE org_id = -3113
96: AND NOT EXISTS (
97: SELECT NULL
98: FROM pa_billing_assignments

Line 98: FROM pa_billing_assignments

94: FROM pa_billing_assignments_all ba
95: WHERE org_id = -3113
96: AND NOT EXISTS (
97: SELECT NULL
98: FROM pa_billing_assignments
99: WHERE org_id = x_org_id
100: AND distribution_rule = ba.distribution_rule
101: AND billing_extension_id = ba.billing_extension_id
102: AND project_type = ba.project_type