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 1361: from pa_implementations);

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

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

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