APPS.GMS_BILLING dependencies on GMS_INSTALLMENTS

Line 318: from gms_installments a,

314: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
315:
316: Cursor Cur_installment_lock is
317: select a.installment_id
318: from gms_installments a,
319: gms_awards b
320: where b.award_project_id = X_Award_Project_id
321: and a.award_id = b.award_id;
322:

Line 344: from gms_installments

340: Begin
341:
342: Select 1
343: into x_dummy
344: from gms_installments
345: where installment_id = installment_records.installment_id
346: FOR UPDATE NOWAIT;
347: Exception
348: When RESOURCE_BUSY THEN

Line 1274: from gms_installments

1270: OR
1271: (C_Installment_Id is NULL
1272: AND gmf.installment_id in
1273: (select installment_id
1274: from gms_installments
1275: where award_id = X_award_id
1276: and (trunc(end_date_Active) >= trunc(X_Expenditure_item_date))
1277: /* and active_flag = 'Y' Bug 6878405 */
1278: and nvl(billable_flag,'N') = 'Y'

Line 1627: from gms_installments ins,

1623: Cursor Inst_Id is
1624: select ins.installment_id installment_id,
1625: gmf.total_funding_amount total_funding_amount,
1626: decode(X_Calling_Process,'Invoice',nvl(gmf.total_billed_amount,0),'Revenue',nvl(gmf.total_revenue_amount,0)) Inv_Rev_Amount
1627: from gms_installments ins,
1628: gms_summary_project_fundings gmf
1629: where ins.award_id = X_award_id
1630: and trunc(ins.end_date_active) >= trunc(X_Expenditure_item_date)
1631: /* and ins.active_flag = 'Y' Bug 6878405 */

Line 6369: GMS_INSTALLMENTS

6365: Installment_Id,
6366: Start_Date_Active,
6367: End_Date_Active
6368: from
6369: GMS_INSTALLMENTS
6370: where
6371: Award_Id = X_Award_Id
6372: /* and active_flag = 'Y' bug 6878405 */
6373: and nvl(billable_flag,'N') = 'Y'

Line 6856: from gms_installments

6852:
6853: /* bug 5242484 - start */
6854: select count(*)
6855: into x_tot_inst_count
6856: from gms_installments
6857: where award_id = X_Award_id
6858: /* and active_flag = 'Y' bug 6878405 */
6859: and nvl(billable_flag,'N') = 'Y';
6860: