DBA Data[Home] [Help]

APPS.GLF02220_BJE_PKG dependencies on GL_BUDGET_RANGE_INTERIM

Line 23: GL_BUDGET_RANGE_INTERIM BI,

19: EXISTS
20: (SELECT
21: 'Budget Journals Transactions exist'
22: FROM
23: GL_BUDGET_RANGE_INTERIM BI,
24: GL_PERIOD_STATUSES PS
25: WHERE
26: BI.ledger_id = X_ledger_id
27: AND BI.status_number = X_status_number

Line 532: GL_BUDGET_RANGE_INTERIM BI,

528: 101,
529: X_Session_Id,
530: X_Serial_Id
531: FROM
532: GL_BUDGET_RANGE_INTERIM BI,
533: GL_PERIOD_STATUSES PS
534: WHERE
535: BI.ledger_id = X_ledger_id
536: AND BI.status_number = X_status_number

Line 854: GL_BUDGET_RANGE_INTERIM BI,

850: 11, BI.stat_amount11,
851: 12, BI.stat_amount12,
852: 13, BI.stat_amount13 )
853: FROM
854: GL_BUDGET_RANGE_INTERIM BI,
855: GL_PERIOD_STATUSES PS
856: WHERE
857: BI.ledger_id = X_ledger_id
858: AND BI.status_number = X_status_number

Line 907: DELETE FROM GL_BUDGET_RANGE_INTERIM

903:
904: PROCEDURE delete_range_interim_records( X_status_number IN NUMBER ) IS
905: BEGIN
906:
907: DELETE FROM GL_BUDGET_RANGE_INTERIM
908: WHERE
909: status_number = X_status_number;
910:
911: END delete_range_interim_records;