APPS.FA_CDE_PKG dependencies on FA_PERIODIC_PRODUCTION

Line 32: FROM FA_PERIODIC_PRODUCTION

28: production *
29: (LEAST (TO_DATE (X_period.end_jdate, 'J'), end_date) -
30: GREATEST (TO_DATE (X_period.start_jdate, 'J'), start_date) + 1)
31: / (end_date - start_date + 1) prod
32: FROM FA_PERIODIC_PRODUCTION
33: WHERE asset_id = X_dpr_ptr.asset_id
34: AND book_type_code = h_dist_book
35: AND start_date <= TO_DATE (X_period.end_jdate, 'J')
36: AND end_date >= TO_DATE (X_period.start_jdate, 'J')

Line 53: UPDATE FA_PERIODIC_PRODUCTION

49: FOR h IN PROD LOOP
50: X_prodn := X_prodn + h.prod;
51:
52: IF NOT X_projecting_flag AND h.used <> 'YES' THEN
53: UPDATE FA_PERIODIC_PRODUCTION
54: SET Used_Flag = 'YES'
55: WHERE ROWID = h.ROWID;
56:
57: IF SQL%NOTFOUND THEN