APPS.GMS_AWARD_PVT dependencies on PA_IMPLEMENTATIONS

Line 1340: FROM pa_implementations i,

1336: */
1337:
1338: CURSOR c_awd_manager IS
1339: SELECT 1
1340: FROM pa_implementations i,
1341: pa_employees e,
1342: per_assignments_f a
1343: WHERE e.business_group_id = i.business_group_id
1344: AND e.person_id = g_award_rec.award_manager_id

Line 1362: from pa_implementations);

1358: where x_date between gps.start_date
1359: and gps.end_date
1360: and gps.application_id = 101
1361: and gps.set_of_books_id = (select set_of_books_id
1362: from pa_implementations);
1363:
1364: /* Bug# 3985020 : Commented
1365: select count(*) from gl_period_statuses gps
1366: where x_date between gps.start_date and gps.end_date

Line 1368: and gps.set_of_books_id in (select set_of_books_id from pa_implementations_all);

1364: /* Bug# 3985020 : Commented
1365: select count(*) from gl_period_statuses gps
1366: where x_date between gps.start_date and gps.end_date
1367: and gps.application_id = 101
1368: and gps.set_of_books_id in (select set_of_books_id from pa_implementations_all);
1369: */
1370:
1371: cursor C_agreement is
1372: SELECT agreement_type